Establish Relationships Between Tables in Access 2016

This updated guide examines Establish Relationships Between Tables in Access 2016 and organizes the essential facts, background, and practical takeaways in clear American English.

One of the good database design goals is to eliminate data redundancy.

To achieve that goal, you need to divide your data into multiple tables on multiple topics so that each entity is interpreted only once.
To do this, all related fields will be placed in a table.
To perform this step correctly, you must first understand the relationship between your tables and then specify these relationships in your Access database.

Why should relations be established between tables?

MS Access uses relationships to join tables that help you use them in a database object. You should create table relationships before you create other database objects such as forms, queries, macros, reports, and reasons like this:

To work with records from two or more tables, you often have to create a query with the participation of multiple tables.
The query works by matching the values in the first primary key field of the table with the foreign key in the second table.
When designing forms or reports, MS Access uses the information collected from defined table relationships to provide appropriate choices.
When designing databases, you divide your data into multiple tables by multiple topics, each with a primary key and then add foreign keys to the relevant tables. Main key pairs - foreign key is the basis for table relationships and query multiple tables.

Now let's add another table of personnel information to your database and name it tblHRData with Table Design as shown in the following screenshot.

Establish Relationships Between Tables in Access 2016 � contextual image 1 — Create the table tblHRData using Table Design View

Next, save and name this table.

Establish Relationships Between Tables in Access 2016 � contextual image 2 — Name and click OK to save the table

Now we have an extra table. In the next lessons, Tipsmake will go into specific examples of setting up each type of relationship . You keep watching!

Previous article: Standardizing databases in Access - Relationships between tables

Next lesson: 1-1 relationship between tables in ACCESS

FAQ

What is Establish Relationships Between Tables in Access 2016 about?

It provides a structured overview of microsoft access 2016, explains the main context, and highlights practical takeaways for readers.

Why does this topic matter?

Understanding the main concepts helps readers evaluate the issue, avoid common mistakes, and make better-informed decisions.

How should readers use this information?

Use the guidance as a practical starting point, confirm details that may have changed, and follow current product, safety, or security recommendations.