View Single Post
  #2  
Old October 23rd, 2009, 10:03 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Making a Database for 14,000 providers in Access 97 need resources

How is it that you've settled on a relational database (Access) as the right
tool for this job?

Are you aware that you have 3 or 4 learning curves to surmount before you
can pull this off?

You need to understand normalization to use a tool that is optimized for
normalized data (i.e., Access).

You need to understand how Access does things (hint: not the same way Excel
does).

You need to understand how to "hide" the stuff Access does, since you won't
want to force your users to learn Access too.

You need experience building applications ... you wouldn't start out
building a house without learning how to, right?

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Taking On A Big Job" Taking On A Big wrote
in message ...
Can you guys point me towards some good resources to help me make a
database.
I want it to be able to search by provider # and name. Each person will
have
name, provider #, ss # and a big comments field. I don't want anything
fancy
right now just something that works and is simple.

If you have any suggestions or things that I should look into doing; I
would
love to get some ideas. Especially any promblems to watch out for in
Access
97 and books to read.