Database Design (Rational Databases)

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hello I have been learning Access on my own and never been
on a course so I dont really know how to properly design a
database...

Please could someone tell me in detail how I would go
about setting up a rational database... from table design
to labeling things....

Many Thanks

James
 
First of all, get this book: "Database Design for Mere Mortals" by Michael
Hernandez and then read it.

On my website, (see sig below) are several tutorials that use an abbreviated
version of Hernandez's process. You might want to download and work through
them. This will give you a start at the table design part. It will take
years to master table design, but designing your database (tables and
relationships) is the single most important part of the process.

I also have some application design tutorials that show what I feel are
essential parts of a complete application (although they are just teaching
samples and not complete applications.)

In the Samples portion of my website is a small sample database called:
"ReallyBadDatabase.mdb" which will show you many, many things NOT to do.
Another sample: "ReallyBadDatabaseReborn.mdb" shows how I would fix them.

As for naming things, there are several naming conventions out there:
Reddick, Lyzinski, Hungarian. Most Access Developer trade press books have
one that they recommend. Find one you like and use it.
 
Back
Top