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 After you confirm that the archive data is complete, without duplicates, the final step is to delete the old movies from the movie table: tblMovieTItles.   First, you will write a SELECT query that selects only archived movies. Test the query. Then, change the SELECT query into a DELETE query.   Try it: Create a SELECT Query Go to Create->Query Design. Add table: tblMovieTitles. Add fields to the grid: ID, Movie, Archived. Archive Criteria: Yes   Run the Query: This query should select 208 movies.   Save the Query: ArchiveMovieDQ   Create -> Query Design