How to Create Make Table Query MS Access



Guide

  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.

🚀

Create your first interactive demo in minutes

No credit card required • Start building today

Start free

    This website uses cookies to enhance the user experience.

    AcceptDecline