Question: what are relationships for in access?
Answer: A relationship in Access helps you combine data from two different tables. Each relationship consists of fields in two tables with corresponding data. ... When you use related tables in a query, the relationship lets Access determine which records from each table to combine in the result set.