How to Use Left Join MS Access
- George Apostolov
How to Use Left 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 left table (primary table) to the related field in the right table (secondary table). This creates a join line between the tables.
Right-click the join line between the tables and select 'Join Properties'.
Select the option for 'Include ALL records from [Left Table] and only those records from [Right Table] where the joined fields are equal'.
Click 'OK' to proceed.
Drag the fields you want to display into the query grid.
Click the 'Run' button to see the results.
Quick answer: To execute a Left Join in MS Access, navigate to the Create tab, open Query Design, and add your tables. Next, create a join line by dragging the primary field to the secondary field. Right-click the line, choose Join Properties, select the All records option, and click OK. Finally, add fields to the grid and click Run.
About this tutorial
Generate a left join query in the app by linking tables, configuring join properties, and running the query to view combined results. This guide shows how to use Left Join MS Access in 9 steps, starting with "Go to the 'Create' tab in the ribbon" and finishing with "Click the 'Run' button to see the results". 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 Left Join MS 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 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
