Question

how do you relate the tables in access​

Answer 1

Answer:

Create a table relationship by using the Relationships window

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.