Many of the problems you see here in the newsgroup originate from the incorrect
design of the tables. Find and study all the resources you can on constructing
tables. Look for the topic "Normalization". Go to the MS knowledgebase - there's
a paper on the topic there. Do a google search on the topic. Go to
groups.google.com and look at threads on the topic. You will find success in
learning Access in being able to design good table structures for your database.
It will be tedious to spend time doing this but later you will thank your lucky
stars for every moment you spent at it. Once you feel comfortable that you have
the knowledge and confidence to design good table structures, get your self a
copy of Alison Balter's Mastering Access XXX Development. It will walk you
through the process of building a database. It is a very easy but very competent
read.
--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com
· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel
