Printing Report Relationships

This tip Printing Report Relationships explains how to print a report, of the relationships in your Microsoft Access database.

You may wonder where I get my tips from. No science involved - I just jot down ideas as they occur to me or by someone asking me a question or, if I am lucky enough, by someone showing me something new. The latter is where the tip comes from this week. I did not know this functionality existed in Access XP (I am not sure about earlier versions). This function is very handy as it builds a report based on your relationships.

Microsoft Access 2003 or earlier

To do this:

Open the relationships window;

On the menu bar click on ‘File’, then ‘Print Relationships’

A Microsoft Access report will be developed based on, and looking exactly like, your relationships window.

You can switch to Design view if you wish to move things around a little bit. This is great if you wish to study the design of your database or share it with somebody else.

Microsoft Access 2007 or later

In the 'Ribbon', click on the 'Database Tools' tab.

Click on the 'Relationships' button ir the 'Relationships' section of the ribbon.

The relationship window will appear, displaying all your previously established relationships.

In the 'Tools' section, click on 'Relationship report'

You can switch to Design view if you wish to move things around a little bit.This is great if you wish to study the design of your database or share it with somebody else.


Previously you had to do a screen dump to achieve this same outcome. This is one of those tips, that just makes your likfe a little bit easier when you use Microsoft Access.

Hope you got some benefit from this tip Printing Report Relationships just like I did.