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.

In Microsoft Access, a Query can answer a simple question, merge data from different tables, perform calculations, add, change, and delete data from the database.