Run the Action Query

Action Queries alter the data in the Table. It is a one-way step: there is no Undo. You will be prompted to confirm this action.

 

6. Try This: Run the Action Query

The Update Query is open in Design View.

Go to Query Tools ->Design->Results->Run.

 

What Do You See? When the Query Runs, it will update four rows in tblMovies with the Year: 2012.

 

You have to confirm this action.

Click Yes. Keep going.

 

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.1. Construct queries: Update Queries

Query Tools ->Design->Results->Run