Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 12th, 2006, 12:47 PM
Registered User
 
Join Date: Jul 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default get a schematic of entire database

Is it possible to print out a schematic of an Access database? I am very new, and the learning curve is killing me. Everytime I do something, I forget what it's to be tied to (i.e. row source, control type, .. UUugghh!) I thougt a thorough DIAGRAM, or FLOW CHART of some sort could help me. But I am stubborn and want it all on one page so I can visualize it all.
Any ideas anyone?

PS: I just joined today on this forum, so I am a rookie!
Becky

 
Old July 12th, 2006, 12:53 PM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

Hi Becky,

Welcome to the forum, hopefully we can help you flatten out the curve a little.

You have a couple of options... If you want to be able to see all your tables and the relationships (if any), you'll find a button on your toolbar called relationships. This will let you add tables to the screen, move them around and define the relationships between them. You may need to move it around a little to get the printout you want, but this gives you a good visual schematic.

The other option is under Tools -> Analyze. I could help you more on this one if you get stuck, but it will generate printout of the fields and whatever other information you choose on each table. This may be more than you would need, but is handy at times.

Hope that helps,

Mike

Mike
EchoVue.com
 
Old July 12th, 2006, 12:58 PM
Registered User
 
Join Date: Jul 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Mike!
I will work with that. I'll keep you posted. I can't wait for the day when I say, "oh, duhh!! that all makes sense now"
Becky








Similar Threads
Thread Thread Starter Forum Replies Last Post
Entire configuration capture bissourav SQL Server 2000 1 August 29th, 2006 05:56 AM
How to backup entire solution? zoltac007 ASP.NET 2.0 Basics 0 June 13th, 2006 01:38 PM
deleting entire database x_ray Classic ASP Basics 3 April 4th, 2006 03:02 PM
spreading an entire program darthziv Pro VB.NET 2002/2003 0 December 4th, 2005 10:41 AM
How to email an entire page? gilgalbiblewheel Java GUI 0 September 16th, 2004 12:16 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.