Exam 12: Access 2007 Unit B: Building and Using Queries

To filter for comparative data and to specify more complex criteria, use the Filter By Selection feature.

Click the ____ View button from Query Design View to display the resulting fields and records from a query.

In the figure above, item 8 points to the ____.

Sorting in a Z to A, then 9 to 0 order is called a(n) ____ order.

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

SQL is the acronym for " simple query language ".

A filter can be used to create calculated fields.

This button sorts records in ascending order.

Explain the difference between AND and OR criteria.

A filter cannot be saved as a query.

In the figure above, item 4 points to Duration as the ____.

A query is commonly used as the source of data for a form or report.

This button provides a list of values in the selected field by which to customize a filter.

____________________ are symbols you can use as substitutes for characters to find information that matches your find criteria.

A(n) ____________________ is a database object that creates a datasheet of specified fields and records from one or more tables.

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

In the figure above, item 1 points to the ____.

In the figure above, button 1 is the ____ button.

In the figure above, item 7 points to the ____.

In the figure above, button 3 is the ____ button.