Define the default join type by using the keyboard

1. If you haven’t already done so, switch to the Database window. You can press F11 to switch to the Database window from any other window.
   
   
2. Press ALT+T to select the Tools menu, and then press R to open the Relationships window.
   
   
3. Press ALT+R to select the Relationships menu, and then press R to open the Edit Relationships dialog box.
   
   
4. Press ALT+T. In the Table/Query box, select the name of the table that contains the primary key, and then select the appropriate table in the Related Table/Query box.
   
   
5. Press ALT+J. In the Join Properties dialog box, select the desired join type.

   Option 1 defines an inner join. This is the default.

   Option 2 defines a left outer join.

   Option 3 defines a right outer join.

Note   You cannot change the default join type if the tables are linked tables. If the linked tables are stored in another Microsoft Access database, you can open the database in which they are stored to set the join type.

Defining the join type for a relationship in the Relationships window doesn't affect the relationship itself; instead it sets the kind of join that will be used by default when creating queries based on the related tables. You can always override the default join type later when defining a query.

Learn more about join types.