How to Use Inner Join MS Access
- George Apostolov
How to Use Inner Join MS 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 the field from the first table (left table) to the related field in the second table (right table). This creates a join line between the tables.
By default, Access creates an 'INNER JOIN' unless you change it in the join properties. Click 'OK'.
Click the 'Run' button to execute the query and view the results.
Drag the fields you want to include in your query into the query grid.
That's it! You have successfully used inner join in MS Access.
Quick answer: To use an inner join in MS Access, go to the Create tab, click Query Design, and add your tables. Drag the field from the first table to the related field in the second table to create a join line. Click OK, add desired fields to the query grid, and click Run to view results.
About this tutorial
Execute an inner join using the app by linking related table fields in Query Design and running the query. This guide shows how to use Inner Join MS Access in 8 steps, starting with "Go to the 'Create' tab in the ribbon" and finishing with "That's it! You have successfully used inner join in MS Access". 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 use Inner Join 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
