Link to home
Start Free TrialLog in
Avatar of rhk6446
rhk6446Flag for United States of America

asked on

How do I copy paste and print the MS Access Relationship Diagram and Table Documentation to MS Word?

Hello Experts,

I think the caption says it all: How do I move these from reports in MS Access to a MS Word Doc?

Thanks
rhk6446
Avatar of kirenievs
kirenievs
Flag of Sweden image

You can't get the graphics from Access into Word. One option is to print to pdf. Put that requires som kind of PDF tool installed.
ASKER CERTIFIED SOLUTION
Avatar of jerryb30
jerryb30
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rhk6446

ASKER

Jerryb30:
Thanks!
Will this work for the relationship diagram also?

rhk6446
The actual diagram would have to be copied with a screen shot, and pasted into the Word document.
Don't know if there are add-ons which allow you to copy the relationships so you can move the individual elements as their own objects, so you could rearrange in a document, or powerpoint presentation.  
here, I have a hard-working colleague who copies a screenshot of each table into a powerpoint slide, adds lines in the presentation indicating the relationships, and sizes  things for large scale plotting.  So, if anybosy has an automaed way to do that, my life would be easier.
Some years ago I used Microsoft Visio to document the db. Relatinoships could be axtracted from access db's. You could also do the db design in Visio and create an Access db from that design.

Did not dig so deep unto that but it seem quite good. Since then Microsoft has taken over the devoelopment so I presume it has been even more integrated with Access/Office.
The system table msysrelationships will give you text info, but I suspect drawing things into a diagram from that in Word  or another office program would also present a challenge.
kirenievs:
Thanks.  Haven't worked with Visio, but makes sense.  As to microsoft adding functionality...............well, who knws.