сейчас вам большое за ответы In Ms Access relationships between tables are used to:
[a] Reduce number of tables
[a] Avoid repetition of data
[a] Make copies of tables
[a] Provide integrity of data
[a] Simplify creation of queries, forms, and reports [a] Remove secondary tables