FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Access Module Maintaining and Querying a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

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

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

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

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

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

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

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

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

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 aggregate function would be used to calculate the lowest field value for the selected records?

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 ____ 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?

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

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

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