What Is a Relationship in Microsoft Access?

A relationship in Microsoft Access connects information between tables. It helps prevent redundant information and ensures that information is consistent from table to table. Relationships also help users create reports.

There are three kinds of table relationships. One-to-many relationships connect one row from the first table to many rows in the second table. Many-to-many relationships have many rows in the first table that are connected to many rows in the second table. One-to-one relationships can have only one match between tables. One-to-many relationships are the most common.

The relationships rows do not have to have the same title. Be sure that all of the tables are closed before creating relationships.