Add the Fields

When a customer goes to check out some movies, the clerk at the register asks for a phone number. Our Parameter Query can do the same thing.

 

2. Try it: Add Fields to the Query

Go to tblCustomer.

Double click to select the following Fields:

CustomerID

FirstName

LastName

HomePhone

 

Keep going...

Query Tools ->Design

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.3. Manipulate fields: Create a Parameter Query