Access Chapter Review 5.2

What does a find unmatched query do?

It finds all records in a table or query that have no related records in a second table or query.

What are the four query wizards you can use to create a new query?

Simple Query Wizard, Crosstab Query Wizard, Find Duplicates Query Wizard, Find Unmatched Query Wizard.

What happens if you set a query's Top Value property to 2, and the first five records have the same value for the primary sort fields.?

Access displays the first five records.

What is a find duplicates query?

A query that finds duplicate records in a table or query based on the values in one or more fields.

What is the purpose of a crosstab query?

It performs aggregate function calculations on the values of one database field and displays.

What happens when you set a query's Top Values Property?

You limit the number of records displayed in the query results.