Exam 3: Access Module Maintaining and Querying a Database

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

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

The most simple technique to use for filtering records is Filter By Form .

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

The Expression Builder dialog box is available from which group on the Query DESIGN tab on the Ribbon?

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

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

When a question is asked of a database using a select query, the answer is returned as a data sheet. 

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

It is more efficient to use the Query Wizard for common, informational queries than to design your own query.  

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

Access may base queries on one or more tables or queries .

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

The first field specified in the sorting process is called the ____________________ field.

Which aggregate function would be used to calculate the lowest field value for the selected records?

Which view must be used to delete an entire record?

Changes made to a field in a query datasheet updates the same field in the table on which the query is based. 

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

A sort field is unique if more than one record can have the same value for the sort field.

Which aggregate function supports the Yes/No field data type?