Question

Write the steps to set relationship between
two tables.​

Answer 1

Explanation:

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. After you have finished adding tables and queries to the Relationships document tab, click Close.

Drag a field (typically the primary key) from one table to the common field (the foreign key) in the other table. To drag multiple fields, press the CTRL key, click each field, and then drag them.