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.