|
The same
Query that selected the Movies can be changed into an Action Query
and Update the Archive Field to "Yes." Here are the steps. Before
You Begin: Change the View Go to
Home->Views-View->Design View. 2.
Try it: Create an Update Query Go to
Query Tools ->Design->Query Type. Select a
Query Type: Update. What Do
You See? There will be a new Row in the QBE grid: Update to. Try
This, Too: Enter the Update Value Go to a
Field: Archived. Update to:
Yes. Better
Do This, Now: Save the Query Go to
File->Save. Enter a
name: ArchiveMovieUQ, where UQ
means Update Query. Keep
going...
Query Tools ->Design->Query Type-> Update
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.1. Construct queries: Create an
Update Query |
|
| |
