Update the Oldies

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