Exam 2: Building and Using Queries

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

Enter OR criteria on different Criteria rows in the query design grid.

To add, delete, or change fields in a query, you use Query Design View.

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

Criteria ____ is the term for rules by which criteria must be entered in a query.

To sort records based on the selected field in the order Z to A, use the _____ button.​

You can enter, edit, and navigate data in a query datasheet just like a(n) report datasheet.

Use the ____ command to save the current object with a new name.

____________________ a table or query datasheet temporarily displays only those records that match given criteria.

The wildcard character that stands for any group of characters is the ____.

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.

____________________ are limiting conditions you set in the query design grid.

The easiest way to filter the records for an exact match is to use the Filter By Form feature.

The ____________________ button provides filter features such as Filter By Form, and Clear All Filters.​

Case 2-1 Daniel Arno owns a lawn and landscape business with many customers. Occasionally, he wants to filter the data about his customers in various ways. -Daniel wants to make even more use of wildcard characters. Which operator is he most apt to use in these searches?

A(n) ____________________ answers a question about the information in the database.

A(n) ____ is a temporary view of the data that is removed when you close the datasheet.