MS Access - Building Relationships
Ms access tutorial
MS Access - Creating Relationships
In this chapter, we will understand the need to create relationships between tables. One of the goals of good database design is to eliminate data redundancy.
To achieve this goal, you
To do this, all the common fields that are related to each other are 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 create a Relations table?
MS Access uses table relationships to join tables when you need to use them in a database object. There are several reasons why you should createtable relationships before creating other database objects, such as forms, queries, macros, and reports.
To work with records from more than one table, you often need to create a query that joins the tables.
The query works by matching the values of the primary key field in the first table with a foreign key field in the second table.
When you design a form or report, MS Access uses the information it gathers from the table relationships you have already defined to present you informed choices and to prepopulate the property settings with the appropriate default values.
When you design a database, you
These foreign primary key-key pairs form the basis of table relationships and multi-table queries.
Now let's add another table in your database and name it tblHRData using the table design as shown in the capture of next screen.
Click on the Save icon as in the screenshot above.
Enter tblHRData as the table name and click Ok .
tblHRData is now created with data .