Question: in access how do you create a relationship?
Answer: On the Database Tools tab, in the Relationships group, click Relationships.
On the Design tab, in the Relationships group, click Add Tables (or Show Table in Access 2013).
Select one or more tables or queries and then click Add.