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

Select Query vs. Action Query 4. Try This: Consider the Query Types Go to Query Tools ->Design->Query Type. What Do You See? We are programming a Select Query. Select Queries grab certain Records in a Table. There are several other Query Types we can consider.   Action Queries change the Records. There are three Action Queries: Append, Update and Delete.   An Append Query adds more Records to a Table. An Update Query changes the data in the Table. A Delete Query deletes Records.   So, Here's the Plan: We will use an Update Query that changes the RentalPriceID based on the Criteria for the Year.   Query Tools ->Design->Query Type