Exam 3: Building and Using Queries

-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.

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

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

Explain the difference between AND and OR criteria.

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

Match each term with the statement that best describes it. -Used to search for a pattern

By default, the printout of a datasheet contains the object name and current date in the footer. ____________________

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

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

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

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

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

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

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

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