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

One More Query... In the first lesson on Queries we used the Query Criteria to find all of the movies that matched the Year we entered. In order to change the search, we had to return to the Design View and edit the Criteria under the Year from say 2012 to 2011.   This Parameter Query will be more flexible.   Before You Begin: All of the Tables, Forms and Queries are closed.   1. Try it: Create a Parameter Query Go to Create ->Queries-> Query Design.   What Do You See? A new, blank query will open. The Show Table will prompt you to choose a Table or Query for the Record Source.   Select a Table: tblMovies Click Add. Click Close. Keep going... Create ->Queries-> Query Design