Establish relationships between tables in Access 2016

In this article, TipsMake.com will work with you to learn the necessity of creating relationships between related tables. The relationship between tables is the data link between tables. By defining these relationships, you can drag records from related tables based on the fields of each table.

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

  1. To achieve that goal, you need to divide your data into multiple tables on multiple topics so that each entity is interpreted only once.
  2. To do this, all related fields will be placed in a table.
  3. 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:

  1. To work with records from two or more tables, you often have to create a query with the participation of multiple tables.
  2. The query works by matching the values ​​in the first primary key field of the table with the foreign key in the second table.
  3. When designing forms or reports, MS Access uses the information collected from defined table relationships to provide appropriate choices.
  4. 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 Picture 1
Create the table tblHRData using Table Design View

Next, save and name this table.

Establish relationships between tables in Access 2016 Picture 2
Name and click OK to save the table

Now we have an extra table. In the next lessons, Quantrimang 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

3.5 ★ | 2 Vote

May be interested

  • MS Access 2003 - Lesson 39: Analyzing tablesMS Access 2003 - Lesson 39: Analyzing tables
    access includes a very powerful tool that you can use to analyze data in one or more tables.
  • MS Access 2003 - Lesson 15: Create an initial tableMS Access 2003 - Lesson 15: Create an initial table
    in this section, you are ready to create a table for the new database. in chapter 2, you used the table wizard to create tables easily. this not only shows that creating a table manually is difficult; but it is a sure way to understand the table.
  • Work with data in Access 2016Work with data in Access 2016
    in the previous lesson, you became familiar with the access 2016 interface as well as the opening and closing of the basic database. this article will continue to go deeper into access 2016 around the content of working with data in access 2016.
  • MS Access 2003 - Lesson 12: Working with a tableMS Access 2003 - Lesson 12: Working with a table
    you have learned how to create and design tables in access. and now it's time to learn how to manipulate all tables.
  • Create data queries in Access 2016 from simple to complexCreate data queries in Access 2016 from simple to complex
    the query allows to retrieve information from one or more tables based on the search conditions you defined. in this lesson, you will learn how to create queries on a simple table and query on multiple tables in access 2016.
  • How to Link Tables in AccessHow to Link Tables in Access
    microsoft access allows tables and databases to connect with each other. this capability can increase your efficiency and easily spread information that is required for multiple departments or reports. you can make changes in the original...
  • MS Access 2003 - Lesson 8: Change information in the tableMS Access 2003 - Lesson 8: Change information in the table
    in the previous section, you learned how to use the datasheet view mode to enter information for the table. the datasheet view mode also allows you to edit available information quickly and easily.
  • Advantages of MongoDBAdvantages of MongoDB
    any relation database has a unique schema design to index the data tables and relationships between those tables. meanwhile in mongodb there is no concept of relationship.
  • How to fix errors Can't Establish Secure Connection on SafariHow to fix errors Can't Establish Secure Connection on Safari
    if you have a problem can't establish secure connection when browsing frequently visited websites on safari, read the following article to find out how to fix it.
  • Table in CSSTable in CSS
    tables in html can become much more beautiful thanks to css.