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.

 

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.1. Construct queries: Select Queries

Query Tools ->Design->Results->Run