Print the design of a database or a database object (MDB)

 Note   The information in this topic applies only to a Microsoft Access database (.mdb).

In a Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.), you can use the Print Relationships Wizard to create a report (report: An Access database object that you can print, which contains information that is formatted and organized according to your specifications. Examples of reports are sales summaries, phone lists, and mailing labels.) that displays the relationships (relationship: An association that is established between common fields (columns) in two tables. A relationship can be one-to-one, one-to-many, or many-to-many.) as they appear in the Relationships window (Relationships window: An object tab in which you view, create, and modify relationships between tables and queries.). You can also use the Documenter to print the design characteristics, such as the properties or the permissions, of a database object (database objects: An Access database contains objects such as tables, queries, forms, reports, pages, macros, and modules. An Access project contains objects such as forms, reports, pages, macros, and modules.).

ShowPrint the Relationships window

  1. Open the Access database whose relationships you want to print.
  2. On the Tools menu, click Relationships to open the Relationships window.
  3. On the File menu, click Print Relationships.

 Note   In a Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects, such as tables and views.), the Print Relationships menu command is not available. However, you can print database diagrams.


The Print Relationships Wizard generates a report with the default name and header Relationships for ; the header contains the date that you created the report. You can save this report for future reference.

ShowPrint the design characteristics of a database object

  1. On the Tools menu, point to Analyze, and then click Documenter.
  2. Do one of the following:

Click the tab that corresponds to the type of database object you want to view or print.

Click the All Object Types tab to display a complete list of objects in the database.

  1. Select the objects whose definition you want to view or print.
  2. Click Options to specify which features of the selected object you want to print, and then click OK.
  3. To generate the report that displays the definitions, click OK.
  4. Do one of the following:

To print the definitions, click Print Button image on the toolbar. You might want to check the length of your definitions before printing them, because some definitions, particularly those for forms and reports, can be many pages long.

To output the definitions to an HTML (HTML: The standard markup language used for documents on the World Wide Web. HTML uses tags to indicate how Web browsers should display page elements such as text and graphics and how to respond to user actions.) file, a Microsoft Excel worksheet, a Rich Text Format file, an MS-DOS text file, or a file in Report Snapshot (report snapshot: A file (.snp extension) that contains a high-fidelity copy of each page of an Access report. It preserves the two-dimensional layout, graphics, and other embedded objects of the report.) format, click Export on the File menu, and then complete the Export Report 'ReportName' To dialog box.

Applies to:
Access 2003