Exam 2: Access 2: Building and Using Queries

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

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

The record selector button is to the right of a record in a datasheet. ____________________

The ____ button filters records that equal, do not equal, or are otherwise compared with the current value.

Is ____________________ criteria will find all records where no entry has been made in the field.

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

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

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

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

The ____ button provides a list of values in the selected field that can be used to customize a filter.

To add a table's field list to the upper pane of Query Design View, click the ____________________ Table button on the Design tab.

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

A filter can be used to create calculated fields.

In large datasheets, you may want to ____ certain fields so that they remain on the screen at all times.

____ are tests or limiting conditions you set to determine which records will be selected in a filter or query.

To delete records from a query datasheet, click the record selector button to the left of the record, click the Home tab, click the Delete button in the Records group, and click Yes.