Utility for Table Schemas

[Neil]

Thanks for the feedback. I can see the usefulness of that approach. I just
have an aversion to sketching things out manually, and prefer to do
everything on the PC. In the past, I've always just gone in and created
tables in Access, using it as a design tool of sorts. But this project I'm
starting is somewhat complex, and I wanted to lay it out first before going
to table design.

 

[Paul Ibison]

Here's a nice list of such tools:
http://www.databaseanswers.com/modelling_tools.htm
Can't vouch for any of the free ones, but can recommend Erwin, Visio and
Enterprise Architect, all of which I've used.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

 

[Roger Carlson]

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 here: http://www.rogersaccesslibrary.com/TutorialsDesign.html

 

[Tim Marshall]

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)

 

[Neil]

Thanks!

 

[Neil]

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

 

[Neil]

Thanks.

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 here: http://www.rogersaccesslibrary.com/TutorialsDesign.html