Guide

1. Go to the 'Create' tab in the ribbon.

2. Click 'Query Design'.

3. Select the tables you want to join from the list and click 'Add Selected Tables'.

4. Drag and drop the field from one table to 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.

7. Click 'OK' to proceed.

8. Add fields to the query grid to include them in the result set.

9. Click the 'Run' button to run the query to view the results.