Create table relationships (Access basics, part 2)

• • 
  • 5:07
  • Creating relationships between your tables
• • 
  • 3:20
  • Create a relationship with the Lookup Wizard
• • 
  • 1:31
  • Create relationships with the Relationships Pane
• • 
  • 3:17
  • Create a many-to-many relationship
• • 
  • 3:06
  • 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.