Exam 3: Building and Using Queries

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

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

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

When you double-click a field in a field list in Query Design View, it is ____.

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

One way to create a new query is with the ____________________, which prompts you for the information it needs to create a new query.

Match each term with the statement that best describes it. -Limiting conditions used to narrow the number of records on a datasheet

To move a field in the query design grid, click its ____, and then drag it left or right.

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

To find numbers greater than or equal to 500, use which comparison operator?

In Query Design View, record selectors are thin gray bars above the field names in the query grid. ____________________

-The top button in the accompanying figure ____.

Match each term with the statement that best describes it. -Creates a datasheet of selected fields and records from one or more tables

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

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

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

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

A query can be used to create calculated fields.

The wildcard character that stands for any single character is the ____.

-The bottom button in the accompanying figure ____.