Exam 2: Building and Using Queries

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

When you double-click a field in a field list in Query Design View, it is ____.

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

To find numbers greater than or equal to 500, use which comparison operator?

Deleting a field from a query also deletes it from the underlying table.

One way to create a new query is with the ____________________, which prompts you for the information it needs to create a new query.

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

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

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

To make a page wider than it is tall, use landscape orientation. _________________________

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

A query allows the selection of a subset of fields and records from one or more tables, then presents the selected data as a single datasheet.

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.

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

Which of the following comparison operators means "less than or equal to"?

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

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

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

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