access database courses - Relationships between tables

Hi Rachel

Thanks for the question.

The key to relationships is a common field in two tables, i.e. the primary key. Access uses a system of rules called referential integrity to make sure relationships between records in related tables are valid, and that you also don't accidentally delete or change related data.

It will also depend on the type of relationship you choose one-to-one, one-to-many or many to many. Using the primary key and referential integrity Access can combine the results of two tables and return the answers to your query

Tracy