How to Create Make Table Query MS Access
A Make Table Query in Microsoft Access is used to create a new table by copying data from an existing table or query. Here’s how to do it:
- 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.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it