|
An Update
Query is an Action Query. When you run the Update Query, you will be
notified that this Action will change the Records and that there is
No UNDO.
3.
Try it: Run the Update Query Go to
Query Tools ->Design->Results-> Run. What Do
You See? This Query will update 73 Rows in tblMovies. That
number matches the one we saw when we tested the Query as a Select
Query. Click Yes to Run the Update. Trust
But Verify: Confirm the Updated Rows Go to
All Access Objects->Table. Open a
Table: tblMovies. What Do
You See, Now? Did the Update Query change the Archived Field to
Yes for the Movies released before 1990? Please
Close tblMovies and return to the ArchiveMovieUQ Query.
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.1. Construct queries: Create an
Update Query
Query Tools ->Design->Results-> Run |
|
| |
