graphic2
graphic1

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

Test the Parameter Query

4. Try it: Run the Parameter Query

Go to Query Tools ->Design->Results->Run.

 

What Do You See? You will be prompted to Enter the Year.

 

Type: 2011

Click OK.

 

Now What Do You See? The Parameter Query found all of the movies that match the year that we typed in.

 

Do This, Too: Save the Query

Go to File->Save.

Enter the Query Name: MoviesByYearSQ.
Click OK.

Close the Query.

Query Tools ->Design->Results->Run

graphic3