Creating tables

[German]

Good morning. Iam a new user of acces software, I do a
job in the marketing and sales section in the enterprice,
so I would like to know abaut the parameters to create
tables, for example if creating only one strong table
with all kinds of dates by enterprice or if is much
better to create differents tables each one by item like
a product, sales,contacts and etc, and why.
Sincerely
GERMAN PARRA

 

[Diane Jamail]

You are asking a common question of new Access users.
Access is a relational database management system and it
is meant to be used by people who understand relational
database theory. This "theory" was designed 40+ years ago
by an IBM engineer named E.F. Codd. Before you go jumping
into learning Access you need to either take a 2 to 3 day
course on database modeling or read a book like "Database
Design for Mere Mortals" (read about it on Amazon.com), or
hire a database consultant that specializes in database
modeling to help you create the right foundation. I don't
know what city you are in, but I am in Houston, Texas and
I have over 10 years of experience in this area with
fortune 500 companies. I am available for single days of
consulting, you can e-mail me at
(e-mail address removed), it is your choice. I teach an
Access class for the local United Way and there is a quote
from the class book that is right on: "If the tables and
table relationships in a database are not designed
properly, the data can be inaccurate and take more work to
maintain".

Good luck,

Diane