B
butterfly90
I am building a new Access database. Can someone give me the first step? I
only want the first step right now. Thank you.
only want the first step right now. Thank you.
J
Jeff Boyce
Turn off the computer and use paper/pencil to normalize your data.
Regards
Jeff Boyce
Microsoft Office/Access MVP
(you DID say "only ... the first step")
Regards
Jeff Boyce
Microsoft Office/Access MVP
(you DID say "only ... the first step")
B
butterfly90
What do you mean by "normalize" data? I somewhat understand the tables.
K
Klatuu
If you don't know what normalize is, you need to learn and understand that
first.
Go to this web site and start reading:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101
A well designed database is absolutely necessary before you start building
an application. If your database is correctly designed, a lot of things
become very easy. If your database is poorly designed almost everything
become very difficult.
Good Luck
first.
Go to this web site and start reading:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101
A well designed database is absolutely necessary before you start building
an application. If your database is correctly designed, a lot of things
become very easy. If your database is poorly designed almost everything
become very difficult.
Good Luck
J
Jeff Boyce
A table (in Access) is a "bucket o' data". You can try to throw everything
you want to know into the same bucket, but if you do that, you might as well
be using a spreadsheet instead.
As Klatuu points out (and Jeff Conrad's website elucidates), to get the best
out of Access' features and functions, you need to understand something of
relational database structure and normalization.
Good luck!
Jeff Boyce
Microsoft Office/Access MVP
you want to know into the same bucket, but if you do that, you might as well
be using a spreadsheet instead.
As Klatuu points out (and Jeff Conrad's website elucidates), to get the best
out of Access' features and functions, you need to understand something of
relational database structure and normalization.
Good luck!
Jeff Boyce
Microsoft Office/Access MVP
K
Klatuu
A "bucket o' data" is like a "bucket o' chicken"
If all the parts are in the same bucket, you will get your fingers all
greasy trying to find a drumstick
If all the parts are in the same bucket, you will get your fingers all
greasy trying to find a drumstick
J
Jeff Boyce
?!? there's a drumstick in there?!
Jeff
Jeff
Klatuu said:A "bucket o' data" is like a "bucket o' chicken"
If all the parts are in the same bucket, you will get your fingers all
greasy trying to find a drumstick
K
Klatuu
LOL
A real chicken lover goes to bed with a leg in one hand, a thigh in the
other and still wants another piece
A real chicken lover goes to bed with a leg in one hand, a thigh in the
other and still wants another piece
B
butterfly90
Thanks for all of your help guys!!! Hopefully this website will be all I
need. If not, I will be back. Now I'm hungry for fried chicken...
need. If not, I will be back. Now I'm hungry for fried chicken...