A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Utility for Table Schemas



 
 
Thread Tools Display Modes
  #21  
Old November 9th, 2006, 05:58 PM posted to comp.databases.ms-access,microsoft.public.access,microsoft.public.access.tablesdbdesign,microsoft.public.sqlserver.tools
Neil
external usenet poster
 
Posts: 311
Default Utility for Table Schemas

Well, there is that! :-)

I've recently come up with a method for house/office cleaning. It's called
the "One Bag At A Time" method. What you do is you take a large plastic
garbage bag, walk around, and fill it up with trash, unneeded mail, other
miscellaneous unneeded things, and you keep going until the bag is full.
Then you take the bag out and stop. Then another time, you do another bag.
And you keep doing this until things are clean. This way, it's not too much
at once. And once you have the bag in your hand, you're motivated to find
stuff to put in it! :-)

N

"Tim Marshall" wrote in message
...
Neil wrote:
With me, if it's not on my PC, it gets lost. The only way I find mail is
by knowing which part of the floor it was left on.... My computer files,
on the other hand, are very organized. :-)


8) Re the stickies, the good thing about this stage of development means
I take a day (or three) to clear the myriads of paper, empty pop bottles,
sandwich crusts to clear off my desk and organize myself. 8)


--
Tim http://www.ucs.mun.ca/~tmarshal/
^o
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me



  #22  
Old November 9th, 2006, 05:58 PM posted to comp.databases.ms-access,microsoft.public.access,microsoft.public.access.tablesdbdesign,microsoft.public.sqlserver.tools
Neil
external usenet poster
 
Posts: 311
Default Utility for Table Schemas

Thanks.

"Roger Carlson" wrote in message
...
Actually, you can use the graphic tools in Excel to draw boxes and lines
to
create a simple ER diagrams.

In my classes, I give the students a PowerPoint template that has all the
objects created that they can just copy and paste into a new PowerPoint
document to draw their ER diagrams. It actually works pretty well. You can
find it he http://www.rogersaccesslibrary.com/TutorialsDesign.html

--
--Roger Carlson
MS Access MVP
www.rogersaccesslibrary.com

"Neil" wrote in message
ink.net...
Yes, I can list tables and fields in Excel; but I'd like to visually
display table relationships and joins. Surely there must be a tool out

there
that does this.

"Karl" wrote in message
t...
You can do this in Excel.

"Neil" wrote in message
nk.net...
I meant just a tool for playing with table designs and providing a
graphical interface/printing utility, not one that would do the

designing
work for me. I want to be able to design the tables manually, set up
relationships, and print the schemas, without creating the tables, and
then create the tables once I'm done with all the design work. Seems

that
such a utility exists.


"Allen Browne" wrote in message
...
A utility to develop table schemas?

If ou are looking for suggestions on how to design schemas for a

variety
of needs, this might be useful:
http://www.databaseanswers.com/data_models/index.htm

In general, though, you only go go the trouble of creating a custom
database if there is no off-the-shelf solution. Therefore the bespoke
Access databases you create all have unique needs, and cannot be
designed by a utility.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Neil" wrote in message
nk.net...
Anyone have a recommendation for a good inexpensive or free utility

for
developing table schemas.












 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:42 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.