Exam 2: Building and Using Queries

The bottom button in the accompanying figure ____.

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

By copying a query before starting to make modifications to it, you can avoid changing the original query by mistake.

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

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

In the accompanying figure, "StateName" and "Price" are ____ names.

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

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

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

A(n) ____ is a saved object within the datasheet.

In the accompanying figure, the item with the infinity sign at one end and the numeral 1 at the other is called a(n) ____ line.

Query Design View presents the fields you can use for a query in small windows called field ____.

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

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

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

A filter can be used to create calculated fields.

A join line is also called a(n) ____ line.

To find all records where there is any entry in the field, even if the entry is 0, which criteria should you use?

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