Add a Parameter

3. Try it: Edit the Criteria

Go to the HomePhone Field.

Enter the following Criteria:

 

[Enter the phone number]

 

That's it. This is what the User will see when the Query runs.

 

Keep going..

Query Tools ->Design

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.3. Manipulate fields: Create a Parameter Query