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: 2012

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

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.3. Manipulate fields: Create a Parameter Query