O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Relationships Explained

One-to-Many Relationships

One of the strengths of Access is the ability to create relationships between tables. As an example of a relationship, consider the Customers and Orders tables from the Northwind sample database.

One-to-Many Relationships

In the Northwind business case, every order comes from a single customer. Of course, a customer can place more than one order, which means that the Customers and Orders tables are in a one-to-many relationship with the Customers table on the "one" side and the Orders table on the "many" side.

Many-to-Many Relationships

It is also possible for two tables to be in a many-to-many relationship, where multiple records ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required