Home > Articles > Home & Office Computing > Microsoft Applications

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

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_1.jpg Click the Database Tools tab.
  • yellow_2.jpg Click the Relationships button.

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

  • yellow_3.jpg 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_4.jpg Click the Relationship Report button.

    The report appears in Print Preview.

  • yellow_5.jpg To print the report, click the Print button, specify the settings you want, and then click OK.
  • yellow_6.jpg Click the Close Print Preview button.

    The relationship report appears in Design view.

  • yellow_7.jpg Click the Save button on the Quick Access Toolbar.
  • yellow_8.jpg Type a name for the relationship report.
  • yellow_9.jpg Click OK.
  • + Share This
  • 🔖 Save To Your Account