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

graphic2
graphic1