Access Lesson 7

The Queries group on the _______ tab contains the commands used to create queries.

• Create
• Query Design
• select query
• Datasheet

The _______ button creates a new, blank query in Design view.

• Datasheet
• Query Design
• record source
• Simple Query

A(n) _______ is the most basic type of Access query.

• field list
• Design
• select query
• Find Unmatched

The tables or queries from which a query gets its data are referred to as its _______.

• select query
• Find Unmatched
• Design
• record source

To run a query after it has been created, double-click it in the Navigation Pane to open it in _______ view and see the results.

• Datasheet
• Query Design
• duplicates
• Design

Two or more records are considered _______ only when all the fields in your query results contain the same values.

• Simple Query
• Datasheet
• duplicates
• select query

When you need to include multiple tables in your query, use the _______ Wizard to build a query from a primary table and a related table.

• select query
• Simple Query
• record source
• Design

To view only the records in one table that don�t have a matching record in another table, you can create a(n) _______ query.

• Find Unmatched
• Query Design
• field list
• duplicates

By switching to _______ view, you can access all the tools needed to modify your query.

• select query
• record source
• Find Unmatched
• Design

A(n) _______ is a window that lists all the fields in the underlying record source or database object.

• field list
• Query Design
• duplicates
• Simple Query