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.).
Print the Relationships window
Print the design characteristics of a database object
- On the Tools menu, point to Analyze, and then click Documenter.
- 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.
- Select the objects whose definition you want to view or print.
- Click Options to specify which features of the selected object you want to print, and then click OK.
- To generate the report that displays the definitions, click OK.
- Do one of the following:
To print the definitions, click Print 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.