How to Create Make Table Query MS Access
- George Apostolov
How to Create Make Table Query MS Access: step-by-step guide
Go to the 'Create' tab in the ribbon.
Click 'Query Design'.
In the 'Show Table' dialog box, select the table or query containing the data you want to use.
Click 'Add Selected Tables'.
Drag the fields you want to include in the new table from the table/query list to the query grid.
Click 'Make Table' in the 'Query Type' group.
Enter a name for the new table and click 'OK'.
Click 'Run', the red exclamation mark icon in the ribbon.
Quick answer: 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.
About this tutorial
Generate a new table from existing data using the make table query tool in the app by selecting fields, naming the table, and running the query. This guide shows how to create Make Table Query MS Access in 8 steps, starting with "Go to the 'Create' tab in the ribbon" and finishing with "Click 'Run', the red exclamation mark icon in the ribbon". The interactive demo above is a click-through copy of the real product interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to create Make Table Query MS Access?
8 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your data or settings. Once you know the flow, repeat it in your own workspace.
Create your first interactive demo in minutes
No credit card required • Start building today
