deshoteln said:
Can anyone suggest a helpful manuel for new users? I need to create a
database to track major equipment, preventive maint., and spare parts for the
equipment. Any suggestions would be greatly appreciated.
I have messed around with the Asset Tracking Templet that is available with
Access 2000. However, I cannot seem to change the fields to suit our needs.
thanks
I would suggest Manuel Garcia Escobar Jesus Renaldo de la Sanchez, but
he's not around.
You are about to embark on a great quest. A quest of hope. A quest of
freedom. A quest of database design...
Ok seriously, if you feel like a noob at database design, as do I, I
highly suggest you browse your local bookstore (virtual or otherwise)
and try out one of innumerable good books available on the topic. One I
have personal experience with and recommend is "Database Design for Mere
Mortals."
You also can and should check out websites that discuss things like
database design, database normalization, entity-relationship modeling,
and several other terms that don't come to mind just yet.
I'm sure you are eager to get started and bravo for that! But know that
database design is a bit of art and a bit of science. As such it is not
something you are likely to master in a weekend. Should you go it alone
and take the low road be prepared to realize faults, revise assumptions,
and rework your work. More than once. Perhaps a dozen times.
I say all this with the utmost respect for your enthusiasm and goals. To
be fair it must be said you must be ready for study, critical thinking,
and plenty of work.
Best of luck!