# How to Create Make Table Query MS Access

> To create a make table query in MS Access, go to the Create tab, click Query Design, select and add your tables, and drag the desired fields to the query grid. Next, click Make Table, name the new table, click OK, and click Run.

Canonical: https://livedemo.ai/tutorials/how-to-create-make-table-query-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a39d6ab56e05a00fe0948/preview?step=1

## Steps

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