-
-
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.