How to Create Make Table Query MS Access

Quick summary

A Make Table query in MS Access lets you create a new database table by extracting and saving data from an existing table or query. This is useful for archiving records, creating backups, or generating summary datasets without altering the original source.

Steps

1. Go to the Create tab in the ribbon.
2. Click Query Design to open a new query in Design view.
3. In the Show Table dialog box, select the table or query containing the data you want to use.
4. Click Add Selected Tables to add it to the query.
5. Drag the fields you want to include in the new table from the table or query list to the query grid.
6. Click Make Table in the Query Type group on the ribbon.
7. Enter a name for the new table and click OK.
8. Click Run — the red exclamation mark icon in the ribbon — to execute the query and create the table.