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

Create an Update Query

5. Try This: Create an Update Query

Go to Query Tools ->Design->Query Type.

Select a Type: Update.

 

What Do You See? You should see a new Row in the QBE grid at the bottom of the Query.

 

Update to What? The data has to MATCH the Field it is changing. RentalPriceID is a Number that refers to a specific price and description.

 

Try This, Too: Edit the Update Value

Enter the RentalPriceID: 1

 

RentalPriceID 1 is $4.50 with a 1-Day Rental.

 
graphic2

Query Tools ->Design->Query Type->Update

graphic1