Changing join types

  1. Click on the relationship line between two tables, then select Edit Relationships | Join Type.
  1. Choose the required join:
  1. Click OK to confirm, then click OK again to return to the Relationships window. Click Close to exit the Relationships window.

Get Learn Microsoft Office 2019 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial