Exam 77-424: Microsoft Access 2013 3.0 Create Queries 3.2 Modify a Query: Add New Fields

Business Rules In this business model, the Rental Prices are based on a date. New Movies have a higher Rental Price than old ones.   You can use an Action Query to add the Rental Prices to the Movie Table. An Action Query selects the Movies based on your Criteria and updates the RentalPriceID in tblMovies.   This lesson begins with a Select Query that has a Criteria for the Year. We'll test the Criteria to see if  works: Does the Query select the right Movies?   1. Try This: Create a Select Query Go to Create ->Queries->Query Design. Select a Table: tblMovies. Click Add. Click Close.   Keep going...   Create ->Queries->Query Design