Creating a new Database

D

deshoteln

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
 
J

John Vinson

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

There are extensive lists of resources at:

Jeff Conrad's resources page:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

I can really recommend my friend John Viescas' book _Access <version>
Inside Out_, but there are quite a few good books out there; you may
want to go to a good bookstore, pull eight or twelve off the shelf,
and see which fits your learning style and level of prior knowledge. I
can't recommend the Dummies (and analogous) books for this purpose -
they're actually very good for what they do, but they're targeted
toward *USING* existing databases, not creating new ones.

John W. Vinson[MVP]
 
S

Smartin

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top