What will access do?

[Guest]

At my work we have 30 customers. I have to put 26 pieces of information in
records in 3 different places 13 pieces of which are the same. Can I use
access to put all informatin in one table, then build forms or reports from
that one table so that I only have to enter info one time and not three. If
I can do it this way, can I choose which records to put into a report or
form, bacause I don't want to use them all. Thanks for any help.

 

[Keith Wilby]

At my work we have 30 customers. I have to put 26 pieces of information
in
records in 3 different places 13 pieces of which are the same. Can I use
access to put all informatin in one table, then build forms or reports
from
that one table so that I only have to enter info one time and not three.
If
I can do it this way, can I choose which records to put into a report or
form, bacause I don't want to use them all. Thanks for any help.

That's exactly what Access is designed to help you do but it is up to you
(or the developer) to define the tables and relationships such that data is
stored efficiently. Note that you wouldn't normally have just one table
where relationships between entities exist (eg customers - products). Have
a look at the Northwind sample database that ships with Access, it's a good
starting point.

Keith.
www.keithwilby.com