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.

Learn how to build tables with the Table Designer in Access. The process will help you analyze large amounts of information, and manage data efficiently.

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.

Tips Create a new table in design view by clicking the "Create" tab on the ribbon and clicking "Table Design" in the "Tables" section.

Have you been eyeing a Microsoft Access database that has a table whose structure you would like to use to create a table in another database?