How do you open the relationship table in Access?

Question

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.

How do you view table relationships in Access?

View table relationships1Click File, click Open, and then select and open the database.2On the Database Tools tab, in the Relationships group, click Relationships.3On the Design tab, in the Relationships group, click All Relationships. This displays all of the defined relationships in your database.

Where is the relationship button located?

The Relationships button is found on this tab on the ribbon. Add a table to the Relationships window using this dialog box. At the Edit Relationships dialog box, the two cascade options do not become active until this option is activated.

What is a relationship table?

In a relational database, a relationship is formed by correlating rows belonging to different tables. A table relationship is established when a child table defines a Foreign Key column that references the Primary Key column of its parent table.

Expert · Answer