Question 1

A combination of database fields,constants,and operators that are used to perform a calculation is called a(n) ____. 
A) builder
B) expression 
C) operator
D) query

Accepted Answer

A combination of database fields, constants, and operators used to perform a calculation is called an expression. A builder is a tool for visually creating a query or report. An operator is a symbol or function used to perform a calculation, and a query is a request for information from a database.

Question 2

Which keyboard shortcut selects the first field value in the first record when in Navigation Mode? 
A) Tab
B) Home + Up Arrow 
C) Up Arrow
D) Ctrl+Home

Accepted Answer

The shortcut Ctrl+Home selects the first field value in the first record when in Navigation Mode. The other options (Tab, Home + Up Arrow, Up Arrow) do not specifically select the first field value in the first record.

Question 3

When the sort field data for each record in a database is different,the sort field is ____. 
A) ascending
B) unique 
C) nonunique
D) descending

Accepted Answer

The answer of  When the sort field data for each...

Question 4

The condition "Seattle" for the field City in a student database is an example of what type of value? 
A) text value
B) field value 
C) comparison value
D) criteria value

Accepted Answer

"Seattle" is an example of a text value, which is a type of data that consists of characters, digits, or symbols. It is used to represent names, descriptions, or other textual information in a database. A field value is a term used to describe the data entered into a specific field, so option B is not correct. "Comparison value" and "criteria value" are not commonly used terms in database management, so options C and D are also incorrect.

Question 5

The process of adding,modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database. 
A) reconstructing
B) maintaining 
C) developing
D) editing

Accepted Answer

Maintaining a database involves updating and keeping the records current and accurate through adding, modifying and deleting records. Reconstructing refers to rebuilding a database from scratch, developing refers to creating a new database and editing is just one aspect of maintaining a database.

Question 6

The primary key of a table must be unique for each record; however,the ____ sort field does not have to be unique. 
A) table
B) chronological 
C) primary
D) adjacent

Accepted Answer

The answer of  The primary key of a table must...

Question 7

The comparison operator,< >,is used to insert a condition that means ____. 
A) greater than
B) And 
C) less than
D) not equal to

Accepted Answer

The comparison operator, < >, is used to indicate inequality or "not equal to." It is commonly used in conditional statements to check if a particular value is not equal to another value.

Question 8

Date criteria are automatically enclosed in ____ when entered in a query design. 
A) quotes
B) parenthesis 
C) brackets
D) number signs

Accepted Answer

Date criteria are automatically enclosed in number signs (#) when entered in a query design.

Question 9

Data may be sorted in a table datasheet,a form,and a ____. 
A) report
B) query datasheet 
C) record
D) related table

Accepted Answer

The answer of  Data may be sorted in a table...

Question 10

In a query,Access sorts fields first based on the sort field that is ____ in the design grid of the Query window when in Design view. 
A) leftmost
B) rightmost 
C) adjacent to the leftmost field
D) adjacent to the rightmost field

Accepted Answer

Access sorts fields from left to right, so the leftmost field in the design grid determines the primary sort order. If there are ties for the leftmost field, then the adjacent fields to the right are used to further sort the data.

Question 11

The AutoFilter sort method works on a(n)____ field(s). 
A) multiple
B) 10 fields 
C) adjacent
D) single

Accepted Answer

The AutoFilter sort method works on a single field at a time.

Question 12

To use an existing query as the basis for a new query,it is necessary to ____ the query before designing the new query. 
A) modify
B) rename 
C) delete the existing query
D) include comparison operators

Accepted Answer

The answer of  To use an existing query as the...

Question 13

The ____ command removes the display of one or more fields in Datasheet view. 
A) Hide Fields
B) Unhide Fields 
C) Remove Fields
D) Display Fields

Accepted Answer

The "Hide Fields" command allows the user to remove the display of one or more fields in Datasheet view, while keeping the actual data intact. This can be useful for decluttering the view or hiding sensitive information.

Question 14

Which view must be used to delete an entire record? 
A) Design
B) Query 
C) Navigation
D) Datasheet

Accepted Answer

The datasheet view allows you to see and edit all records in a table, including the option to select and delete entire records. In the datasheet view, you can click on the record selector (the box to the left of the record) to select the entire record and then press the delete key to delete it.

Question 15

A field with the Short Text data type sorted in descending order will display the data in which order? 
A) A to Z
B) lowest to highest 
C) Z to A
D) highest to lowest

Accepted Answer

Short Text data type is sorted based on alphabet. Descending order means the highest alphabet will be displayed first, which is Z, followed by Y, X, and so on until A. Therefore, the correct answer is C, Z to A.

Question 16

In the criterion,<=250,the operator will return values for the specified field that are ____. 
A) less than 250
B) equal to 250 
C) less than or equal to 250
D) greater than or equal to 250

Accepted Answer

The "<=" operator means "less than or equal to", so the values returned will be less than or equal to 250. Therefore, option C is the correct answer.

Question 17

Which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point? 
A) navigation mode
B) design mode 
C) editing mode
D) selection mode

Accepted Answer

When in editing mode, users can insert or delete characters within a field value based on the location of the insertion point. Navigation mode is used for moving around the record, design mode is used for modifying the structure of the record, and selection mode is used for selecting specific parts of the record for editing.

Question 18

A criterion,or rule,that determines which records are selected when a query is run is called a(n) ____. 
A) sort order
B) condition 
C) operator
D) match

Accepted Answer

A criterion or rule that determines which records are selected when a query is run is called a condition. The condition specifies the specific criteria that must be met in order for a record to be included in the query results. A sort order determines the order in which the resulting records are displayed, while operators are used to compare values or perform mathematical operations. A match refers to a record that meets the specified criteria in the query.

Question 19

Queries based on more than one table,must have a ____ field. 
A) common
B) similar 
C) text
D) calculated

Accepted Answer

Queries based on more than one table require a common field, which is a field that exists in both tables and can be used to join them together. This allows the data from both tables to be combined and analyzed in a meaningful way. It is not sufficient for the fields to be similar or to have matching text, as they must be directly linked in order to create a relationship between the tables. Additionally, calculated fields may be useful in some queries but are not a requirement for joining tables together. Therefore, the best choice is A) common.

Question 20

A query based on more than one table is a(n) ____query. 
A) multiple
B) advanced 
C) relationship
D) multitable

Accepted Answer

A multitable query involves retrieving data from more than one table in a database. It requires specifying the relationship between the tables and joining them together to extract relevant information. Therefore, option D is the best choice for this question.

Quiz 3: Maintaining and Querying a Database

A combination of database fields,constants,and operators that are used to perform a calculation is called a(n) ____.

Which keyboard shortcut selects the first field value in the first record when in Navigation Mode?

When the sort field data for each record in a database is different,the sort field is ____.

The condition "Seattle" for the field City in a student database is an example of what type of value?

The process of adding,modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.

The primary key of a table must be unique for each record; however,the ____ sort field does not have to be unique.

The comparison operator,< >,is used to insert a condition that means ____.

Date criteria are automatically enclosed in ____ when entered in a query design.

Data may be sorted in a table datasheet,a form,and a ____.

In a query,Access sorts fields first based on the sort field that is ____ in the design grid of the Query window when in Design view.

The AutoFilter sort method works on a(n) ____ field(s) .

To use an existing query as the basis for a new query,it is necessary to ____ the query before designing the new query.

The ____ command removes the display of one or more fields in Datasheet view.

Which view must be used to delete an entire record?

A field with the Short Text data type sorted in descending order will display the data in which order?

In the criterion,<=250,the operator will return values for the specified field that are ____.

Which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point?

A criterion,or rule,that determines which records are selected when a query is run is called a(n) ____.

Queries based on more than one table,must have a ____ field.

A query based on more than one table is a(n) ____query.