Administrator: Rave Reviews Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 More

Update the Oldies

Now that you have selected the movies, you can use an ACTION query to UPDATE Archive to "Yes".

 

Try it: Update the Old Movies

Go to the Query Tools

Select Design ->Update

    

Select the Archive field on the QBE grid.

Update to: Yes

 

Run the Query

You will be prompted about the update. This query should UPDATE 206 movies.

 

Save this Query as: ArchiveMovieUQ

Query Tools -> Design ->Update
 

 

  Microsoft Access 2007 Exam 77-605 Topic: 4. Creating and modifying queries

  4.1.3.   Create action queries: UPDATE