graphic2
graphic1

Exam 77-424: Microsoft Access 2013
3.0 Create Queries
3.1 Create a Query: Create Parameter Queries

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