Quick summary
An Inner Join in MS Access lets you combine rows from two tables where a matching field exists in both, returning only records with values in common. Using the Query Design view, you can visually link tables, set join conditions, and run the query without writing SQL manually.
Steps
- Go to the 'Create' tab in the ribbon.
- Click 'Query Design' to open the query designer.
- Select the tables you want to join from the list and click 'Add Selected Tables'.
- Drag a field from the first (left) table to the related field in the second (right) table to create a join line between the tables.
- By default, Access creates an 'Inner Join' — confirm the join type and click 'OK'.
- Drag the fields you want to include into the query grid.
- Click the 'Run' button to execute the query and view the results.
- Your Inner Join query in MS Access is now complete.
