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.

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.

How to Build a Data Dictionary in Access. A data dictionary is like a bill of materials for a database; it lists all database components, including reports, tables, field names and field types.