Exam 2: Building and Using Queries

Access saves ____ automatically as you move from record to record.

If, for example, a find-and-replace effort does not work correctly, click the Undo button to cancel the changes.

Filters are used to select a subset of records in a datasheet.

To move a field in the query design grid, click its ____, and then drag it left or right.

Quotation marks are automatically added to criteria for fields with a Date/Time data type.​

The question mark (?) is the wildcard character which stands for any single character in criteria.

In Query Design View, record selectors are thin gray bars above the field names in the query grid.

As you add rows of OR criteria to the query design grid, you decrease the number of records selected for the resulting datasheet.

Query criteria are not case sensitive.​

Explain the difference between AND and OR criteria.

In Query Design View, the query design ____________________ shows you the field names, sort orders, and criteria used with a query.

A query datasheet is sometimes called a ____ of the data.

You enter and edit data in a query datasheet in the same way you do in a table datasheet.

You use Query Design View to add ____ to limit the number of records shown in the resulting datasheet.

Filter By ____________________ is a fast and easy way to filter records for an exact match.

In Access, the Save As command allows you to save either the entire database or the current object with a new name.​

To move fields in the query grid, drag the field ____________________.

The wildcard character that stands for any single character is the ____.