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.
A brief reminder of the key points in this course.
More courses available at Microsoft Office Training.