Copy to a New Table
Query, ArchiveMovieUQ, will also work
as another type of Action Query: a Make Table Query. The Make Table
Query selects the Records that match the Criteria and copies those
Records into a new Table.
Try it: Create a Make Table Query
Query Tools ->Design->Query Type.
Query Type: Make Table.
You See? You will be prompted to name the new Table.
Table Name: tblArchiveMovies.
OK to Run the Make Table Query.
This, Now: Save the Make Table Query
File->Save Object As.
means this is a Make Table Query.
Memo to Self: By default, this
new Table will be made in the Current Database.