Video: Create table relationships (Access basics, part 2)

Applies To
Access 2013
  • 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 summaryA brief reminder of the key points in this course.

More courses available at Microsoft Office Training.