Exam 2: Building and Using Queries

A query can be used to create calculated fields.

To add a table's field list to the upper pane of Query Design View, click the ____________________ Table button on the Design tab.

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

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

To filter for comparative data, use the Filter By Selection feature.

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

Is ____________________ criteria will find all records where no entry has been made in the field.

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

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

In Query Design View, the query design ____________________ shows you the field names, sort orders, and criteria used with a query.

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.

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

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

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.

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

As you add rows of OR criteria to the query design grid, you decrease the number of records selected for the resulting datasheet. ____________________

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

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