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