Exam 6: Improving Queries

Describe the one-to-many relationships of the tables shown in the accompanying figure.

The Find ____ Query Wizard is used to determine whether a table contains duplicate values in one or more fields.

In the accompanying figure, how many fields will display on the resulting datasheet?

Use the ____ Query Wizard to guide you through the steps of creating a crosstab query.

Explain the position and purpose for the three typical field positions used in a crosstab query.

In the accompanying figure, item 2 refers to a(n) ____.

In the accompanying figure, item 3 points to ____.

When the comparison operator Null is used as criteria in the query design grid, the query finds records in which ____.

When you open a query in Datasheet View, you run it.

When you are saving a query, you are saving a set of instructions written in Standard Query Language. _________________________

Which type of query retrieves data from one or more linked tables and displays the results in a datasheet?

____ criteria are two or more criteria on the same Criteria row of the query design grid.

In the query design grid, what characters surround text criteria?

The < comparison operator means ____.

In Query Design View, one-to-many join lines identify linking fields between related tables.

The < comparison operator means ____.

A(n) ____ query is used to calculate statistics about a group of records.

A summary query calculates statistics about ____.

The ____ function returns a number of characters from the first part of a field.

You want to add the PaymentDate field from the Payments table in the query shown in the accompanying figure. Describe how you can do this.