AL7KAMC

Create a query is like

• sorting the data
• asking the database a question
• creating a new table
• opening an existing table

The results that a query returns can be

• sorted
• grouped
• filtered
• all of the above

When one table will provide the information you need, you can create a 

• record source
• simple select query
• query criterion
• parameter query

Which query CANNOT be created using the Query Wizard?

• Parameter Query
• Simple Query
• Find Duplicates Query
• Find Unmatched Query

Queries are different from sort or filter commands because they can be

• applied to multiple fields
• saved
• modified
• used on forms

A query can get its data from

• one or more tables
• existing queries
• all of the above
• none of the above

To find records that contain matching field values, you can create a query using which wizard?

• Find Matching
• Matching Fields
• Duplicate Records
• Find Duplicates

Before creating a query from multiple tables, you must first ensure that the tables have

• unmatched records
• a defined relationship
• a filter applied
• no related records

To add a table to a query, you must be in what view?

• SQL
• Datasheet
• Normal
• Design

A rule that identifies the records you want to include in the query result is called a 

• parameter query
• query criterion
• select query
• field list