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.

A Form is a formatted document with fields containing data from a Table or Query in Microsoft Access. A Query is a request for data. A Form is an efficient way to locate data.