Access 2010 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:

1. The Students table holds all students' names and addresses.

2. The Math Class table shows which students are taking math.

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.

Examine current table relationships

1 Click the Database Tools tab.