How to Join Tables in Microsoft Access
- George Apostolov
How to Join Tables in Microsoft Access: step-by-step guide
Go to the 'Create' tab in the ribbon.
Click 'Query Design'.
Select the tables you want to join from the list and click 'Add Selected Tables'.
Drag and drop the field from one table to the related field in the other table to create a join.
Right-click the join line between the tables and select 'Join Properties'.
Choose the appropriate join type.
Click 'OK' to proceed.
Add fields to the query grid to include them in the result set.
Click the 'Run' button to run the query to view the results.
Quick answer: 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.
About this Microsoft tutorial
Combine data and view query results in Microsoft Access by creating and configuring table joins using Query Design. This guide shows how to join Tables in Microsoft Access in 9 steps, starting with "Go to the 'Create' tab in the ribbon" and finishing with "Click the 'Run' button to run the query to view the results". The interactive demo above is a click-through copy of the real Microsoft interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to join Tables in Microsoft Access?
9 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 Microsoft data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Microsoft. Related guides: How to Keep Top Row Visible Microsoft Excel, How to Link Cells Between Worksheets in Microsoft Excel and How to Link Worksheet Data in Microsoft Excel. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
