How to Join Tables in Microsoft Access

Quick summary

Joining tables in Microsoft Access using Query Design lets you combine related data from multiple tables into a single result set. You can control how records are matched by selecting a join type, then run the query to instantly view the combined output.

Steps

1. Go to the Create tab in the ribbon.
2. Click Query Design to open the query builder.
3. Select the tables you want to join from the list and click Add Selected Tables.
4. Drag and drop a field from one table onto 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 for your query.
7. Click OK to confirm the join properties.
8. Add fields to the query grid to include them in the result set.
9. Click the Run button to execute the query and view the results.