# How to Join Tables in Microsoft Access

> To join tables in Microsoft Access, go to the Create tab, open Query Design, and add your tables. Drag fields to create a join, right-click the line to set join properties, and click OK. Finally, add fields to the grid and click the Run button to view your results.

Canonical: https://livedemo.ai/tutorials/how-to-join-tables-in-microsoft-access/
Apps: Microsoft
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a47b5ab56e05a00ff23e5/preview?step=1

## Steps

1. Go to the 'Create' tab in the ribbon.
2. Click 'Query Design'.
3. Select the tables you want to join from the list and click 'Add Selected Tables'.
4. Drag and drop the field from one table to the related field in the other table to create a join.
5. Right-click the join line between the tables and select 'Join Properties'.
6. Choose the appropriate join type.
7. Click 'OK' to proceed.
8. Add fields to the query grid to include them in the result set.
9. Click the 'Run' button to run the query to view the results.