Home > Articles

  • Print
  • + Share This
This chapter is from the book

Creating and Printing a Table Relationship Report


After you create a table relationship, you can create and print a report. In the Relationships window, the Relationship Report button creates a report with the currently displayed relationship and switches to Print Preview, where you can print the report. When you close Print Preview, the report appears in Design view. If you want, you can make changes to the report. To complete the process, you need to save and name the report or close it without saving it. Instead of printing the report, you can also use exporting tools in Print Preview to save the report in another format, including a PDF or XPS document.

Create and Print a Table Relationship Report

yellow_circle_1.gif Click the Database Tools tab.

yellow_circle_2.gif Click the Relationships button.

If relationships are already established in your database, they appear in the Relationships window.

yellow_circle_3.gif Do any of the following to display the table relationships you want to use to create a report:

  • Hide tables. Click the table you want to hide, and then click the Hide Table button.

  • Add tables. Click the Tables tab, click the table you want, click Add, and then click Close.

yellow_circle_4.gif Click the Relationship Report button.

The report appears in Print Preview.

yellow_circle_5.gif To print the report, click the Print button, specify the settings you want, and then click OK.

yellow_circle_6.gif Click the Close Print Preview button.

The relationship report appears in Design view.

yellow_circle_7.gif Click the Save button on the Quick Access Toolbar.

yellow_circle_8.gif Type a name for the relationship report.

yellow_circle_9.gif Click OK.

  • + Share This
  • 🔖 Save To Your Account