Parameter Queries

Parameter Queries prompt you to answer a question before the Query runs.

 

Before You Begin: All of the Tables, Forms and Queries are closed.

 

1. Try it: Create a Parameter Query
Go to Create ->Queries-> Query Design.

 

What Do You See? A new, blank query will open. The Show Table will prompt you to choose a Table or Query for the Record Source.

 

Select a Table: tblCustomers

Click Add.

 

Click Close. Keep going...

Create ->Queries-> Query Design

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.2. Manage source tables and relationships: Use the Show/Table Command