Microsoft Access: Creating Tables, Relations Ships and Queries

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.