How do I keep notes & Dates on same page of Customer in Access

G

Guest

I have just purchased Access 2003. I want to set up a customer data base for
our sales force to be able to contact with a lookup by customer or ph or
e-mail.
I can't find the right place to do this. Need help??????????
 
G

Guest

Your initial challenge is to estimate with fair accuracy your future
reporting needs so that you can do proper design now. For example, it seems
commonsensical that a customer can have one or more phone numbers, one or
more email addresses, etc., and that those attributes may attach to multiple
persons at the customer address. You may want several tables to accomodate
this, particularly if your dataset is already large, or you think it will
become so. From my point of view in my work, if the dataset is not large and
won't be for a long time I would not use Access but just use Excel instead.
*shrug*

Anyway, relational database design = 1st step.

Once that's done, we can start answering questions about how to, for
example, do phone number lookups in subforms (the many side of the
one-to-many relationships mentioned above).
 

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