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.