![Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.](https://support.content.office.net/en-us/media/4873755a-8b1e-497e-bc54-101d1e75d3e7.png)
-
-
Creating relationships between your tables
-
-
-
Create a relationship with the Lookup Wizard
-
-
-
Create relationships with the Relationships Pane
-
-
-
Create a many-to-many relationship
-
-
-
Create a one-to-one relationship
-
Learn how to create table relationships, a key part of any database. This course explains the three types of relationships, and when and how to create each one.
Inside this course:
Creating relationships between your tables
(5:07)
An introduction to relationships and the 3 types of relationships.
Create a relationship with the Lookup Wizard
(3:19)
How to create a one-to-many relationship with the Lookup Wizard.
Create relationships with the Relationships Pane
(1:31)
Creating a one-to-many relationship with the Relationships pane.
Create a many-to-many relationship
(3:25)
When and how you create a many-to-many relationship.
Create a one-to-one relationship
(3:06)
How to build a one-to-one relationship.
Course summary
A brief reminder of the key points in this course.
More courses available at Microsoft Office Training.