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
rhk6446Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

kirenievsCommented:
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.
jerryb30Commented:
rhk6446:
Select Tools, Analyze, Documenter.
Select the tables you want documentation on.
Then, select Options.
Select the amount of detail you want on table and field and index properties.  You will want to play with this,to determine the level of detail, as the actual report can be large.
OK to options.
OK to run documenter.
You will get a report which can be saved as an RTF file.  Click on the Word icon, and save your report with desired name.
If you are using Access 97, I believe you can output the information to a table, which you can then use to crete reports tailored to your requirements.
Hope this helps.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rhk6446Author Commented:
Jerryb30:
Thanks!
Will this work for the relationship diagram also?

rhk6446
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

jerryb30Commented:
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.
kirenievsCommented:
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.
jerryb30Commented:
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.
jerryb30Commented:
kirenievs:
Thanks.  Haven't worked with Visio, but makes sense.  As to microsoft adding functionality...............well, who knws.
dannywarehamCommented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.