XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google

Home
Whats New!
Need a database?
Tips via email
Learn VBA
Questions Answered
Access Tips Index


Printing a Report of the Relationships

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.

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.

Previously you had to do a screen dump to achieve this same outcome.

 

Do you like this tip? Subscribe to my weekly Newsletter to receive tips weekly via email. Click Here to subscribe.

footer for Microsoft Access page