First time designing a database from scratch...

[Junior1544]

I am helping a friend build an inventory control database... i have been working with access for a few months and am getting pretty good working with forms, reports, and (simple)queries... but i realy don't have much knoldge about table design... and working with relationships... any one know of a good place to get a good quick tutorial on it??

--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.

 

[Darrylles]

Hiya,

Try this - looks good at first glance.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[Darrylles]

Hiya,

Sorry - missed the link out!!!!!

http://www.cs.sfu.ca/CC/354/zaiane/material/notes/Chapter7/node1.html

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[Darrylles]

Hi again,

P.S. Please don't think that the detail on the site is unnecessary or too much like hard work - it's essential for ANY database design - the more you know about it - the less you'll have to re-design / re-develop.

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."