Access 2003 In Pictures

Create table relationships

What are "relationships?"

Relationships are links that associate a field in one table with a field in another.

An example is a school database with two tables:

  • Students
  • Classes

The Students table holds students' names and addresses:

Students

Student Name

Address

John

Elm St.

Jane

Oak St.

The Math Class table holds information about the students in math class:

Math Class

Student Name

Grade

John

A

Jane

B

Both tables have a Student Name field.

By linking the Student Name fields, you make sure that John in the Students table is the same John listed in the Math Class table:

Students

Math Class

Student Name

Address

Student Name

Grade

John

Elm St.

John

A

Jane

Oak St.

Jane

B