Exam 2: Getting Started With Access 2013

The top button in the accompanying figure ____.

The asterisk (*) is the wildcard used to represent one and only one character in criteria.

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

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

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

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

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

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

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

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

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

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

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.

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

The bottom button in the accompanying figure ____.

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

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

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

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