databases use the Primary Key to create relationships between
Tables. The relationship can be ad hoc, such as creating a Join
between two Tables in a Query, or it can be explicit as part of the
Access defines relationships with the Database Tools.
Try it: Create the Table Relationships
Database Tools ->Relationships.