Create table relationships (Access basics, part 2)
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
An introduction to relationships and the 3 types of relationships.
Create a relationship with the Lookup Wizard
How to create a one-to-many relationship with the Lookup Wizard.
Create relationships with the Relationships Pane
Creating a one-to-many relationship with the Relationships pane.
Create a many-to-many relationship
When and how you create a many-to-many relationship.
Create a one-to-one relationship
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.