Interactive Tutorial
How to Print and Delete Relationships in Access
4.9 out of 5 on G2
Practice live in your browser. No software required.
5 Hour Course Certificate
Free quick tips and shortcuts to use and share.
Step-by-step instructions with screenshots.
Sometimes you may want to print a hard copy of the Relationships window or you may want to delete the relationship between two tables.
The Design contextual tab appears under Relationship Tools.
A report showing the tables and relationships appears in Print Preview mode.
If you want to modify the report before printing, click the Close Print Preview button and edit the report in Design View.
The Print dialog box appears.
The Relationships report is printed.
The report appears in Design View.
Access is very restrictive about letting you modify a related table, and often you must temporarily delete the relationship between two tables, modify one of the tables, and then re-connect them.
Hereβs how to delete a table relationship.
Access asks you to confirm that you really want to delete the relationship.
Access deletes the relationship between the two tables.