Lab 3 Relationships in ER Diagram and Relationships in MS Access

MS Access Lab 3

Summary

Introduction to Relationships

Why Define Relationships?

Relationships in ER Diagram vs. Relationships in MS Access

Creating Relationships Between Tables

One-to-Many Relationship (1:N)

Many-to-Many Relationship (M:N)

Creating a Field/Column that looks up or lists values in tables

Creating a field that looks up data from another table

Creating a field that lists values from another table

1. Introduction: What is a Relationship?

Definition in class: An association between 2 (or more) separate entities.

Definition in MS Access: An association between 2 common fields (column) in two tables.

There are three types of relationships:

One-to-One (1:1)

One-to-Many (1:N)

Many-to-Many (M:N).

1. Why...