Make Tables queries are used when you have data stored in one or more tables that you’d like sent to a new table.
Make Table queries are typically used to copy or archive data in a database.
Creating an Make Table Query
Create a Select Query that contains the criteria for the records you want to move to a new table
Run the Query to be sure you’re pulling the correct records
Switch to Design view
Click the Make Table command in the Query Type group on the Design tab
Figure 53. Make Table Query Dialog Box
5. Enter the new table name in the Table Name drop-down
6. Click OK
7. Click the Run command in the Results group on the Design tab
8. Click Yes