In Microsoft Access, a Relationship helps you to merge or link data from one table to another. Relationships allow the user to create Queries, Forms, and Reports.

Database normalization is the cornerstone of database theory. Once a database is normalized, relationships between the data in multiple tables must be established.