Exam 77-424: Microsoft Access 2013
3.0 Create Queries
3.1 Create a Query: Create Parameter Queries (Filter with Criteria)

Test the Criteria

3. Try This: Test the Criteria

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

 

What Do You See? There are 4 Movies in this database that were released in the Year 2012. 

 

Then What? The Query selected the Movies we would like to Update to RentalPriceID 1, the premium 1-Day Rental for new Movies.

 

Do This: Return to Design View

Go to Home->Views->View.

Select a View: Design View.

 

Keep going...

 

Query Tools ->Design->Results->Run

graphic2
graphci1