Exam 77-424: Microsoft Access 2013 2.0 Build Tables 2.3 Manage Records: Update Records

Test and Run the Query 9. Try This: Test the New Query Criteria The Select Query is open in Design View. Go to Query Tools ->Design->Results->Run.   What Do You See? In this database there are 205 Movies that were released before the Year 2000.    Do This: Return to the Design View Go to Home->Views->View->Design View.   And Do This: Change Back to an Update Query Go to Query Tools ->Design->Query Type. Select a Type: Update.   Try This, Too: Edit the Update Value Enter the RentalPriceID: 3 RentalPriceID 3 is $2.50 with a 5-Day Rental.   Try This, Now: Run the Update Query Go to Query Tools ->Design->Results->Run. When it runs, 205 rows in tblMovies will be updated, You will be asked to confirm this action.   Click Yes. Keep going...   Query Tools ->Design->Results->Run