Administrator: Rave Reviews (Start) 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38

The Last Action Query

Now that you know that your query works, you can use the Query Tools to change this query from SELECT to DELETE.

 

Try it: Create a Delete Query

Look for the Query Tools.

Go to Design ->Query Type ->Delete.

 

Run the Query: You will be prompted! This query should delete 208 movies.

 

Save the Query: ArchiveMovieDQ

Query Tools-> Design ->Run!
 

 

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

  4.1. Create queries   4.1.3.  Create action queries: DELETE