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.

When you create a Microsoft Access table, Access will automatically create a primary key to your database table. Still, you can also specify the field you want as the primary key for your database ...