Forum home » Delegate support and help forum » Microsoft Access Training and help » access database courses - Relationships between tables
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access database courses - Relationships between tables
Resolved · Low Priority · Version Standard
Reply Mon 4 Jun 2007, 14:21Delegate Rachel said...
Rachel has attended:
Access Introduction course
Relationships between tables
How do the relationships created between tables relate to the queries that we may then run on the tables?
For upcoming training course dates see: Pricing & availability
RE: 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
|