Interactive Tutorial
How to Create Relationships Between Tables in Access
4.9 out of 5 on G2
Practice live in your browser. No software required.
5 Hour Course Certificate
Free quick tips and shortcuts to use and share.
Step-by-step instructions with screenshots.
Once you begin to understand the concept of relational databases, the process of actually linking the tables in a database is rather simple.
Make sure you keep these rules in mind when you link to tables together.
You need to display the Relationships window in order to view and create relationships between tables.
Whenever you link a primary key from one table to a field from another table, you create a foreign key.
Referential integrity helps you avoid βorphanβ records and maintains database accuracy.
The two tables are now linked, indicated by the line linking the two related fields.