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

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...

 

Query Tools ->Design->Results->Run

graphic2
graphic1