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.

How to Create a Database in Access First, launch Access and choose File, New. Since you’ll be building this database from scratch, choose Blank database.