How to Create or Make Relationships Between Tables in a Database in Access (Example)


The relationships between tables is a function that has been implemented in Access to be able to establish the union between the values ​​of a database, even when they are separated from each other.

It is well known that this program is responsible for working exclusively with databases or informational tables, it has a sequence of functions that allow them to be handled correctly.

The number of data will depend on the information capacity that the user wants to create, which most of the time end up being redundant cells, so after removing repeating data, the program will take care of establishing the junction point between two or more values ​​within the table.

You may also be interested in:

Although not many users are familiar with the work that is done within Access, they should know that accomplishing this task is very simple and here you will learn how.

What should be considered before establishing relationships between tables?

Because databases are generally very large, many people choose to sort them individually based on certain criteria.

That is why when a relationship is to be established, it is possible to unify two or more tables, so that the user (s) can achieve study informative aspects comfortably that it owns.

before creating relationships between tables access

Said databases can come from within the same program, even be combined and imported from other software that works the same way Access does. This does not affect the relationships between tables in any way, so loss of information or data out of sync should not be a cause for concern.

Creating a relationship between databases through the «Relationships» tab in Access

To make the example much more understandable, we must work with the idea that, for example, it is proposed to design and relate the database of a music store.

Based on this, the variables in the table will begin to vary with what the store conforms, which will define the compatible values ​​later.

Within Access, relationships work with the junction point of data from various tables, following the previous example, where each instrument will correspond to its appropriate price and its stored quantity, represented in the following bases.

To establish relationships between tables, Access has a «Database tools«Where you can find the» Relationships «section.

With the group of «Relations» open, you will find a button that bears the name of «Design», where the option of «Add tables”That you must select.

relationship between access databases

So that after being added, they must be dragged to the common field of the one already existing within the Access sheet, which will be subject to the modification of relationships, based on the criteria that they belong to.

When the user has finished modifying the relationships that he wishes to unify between the tables, he must click on «Create» and he will be able to see how join lines appear between data they have criteria in common.

Design the relationships between tables through the «List of fields»

During the creation and manipulation of a database, the option of “Field list”Allows you to find the compatibility within imported tables, facilitating the procedures mentioned in the previous point.

Since the main desire is to establish a relationship between tables, what must be done is drag the desired field to the sheet or table where the base with which you are working is located.

Once this has been done, the system will automatically establish a relationship between both aspects Through the «Search Wizard», so if you want to change a criterion, you only need to modify the relationships established between them.

Once the whole procedure of the relationships between tables has been completed, and the relationships between tables necessary to work have been established, it is recommended to back up the design in case you need it later or prevent a significant loss from any computer error.

How useful did you find this content?

Click on a star to rate!

Average score 0 / 5. Counting of votes: 0

So far, no votes. Be the first to rate this content.

I'm sorry this content was not useful for you!

Let me improve this content!

Tell me, how can I improve this content?

You may also be interested in:

Deja un comentario