Thread: Any suggestions
View Single Post
  #2  
Old March 22nd, 2010, 04:59 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Any suggestions

I'm not clear, based on your description, whether your Access tables are
merely receptacles for Excel data, or if you've taken advantage of the more
powerful, relationally-oriented features/functions in Access by normalizing
your data structure.

If you simply import data from Excel into Access, keeping the Excel
structure, you probably have NOT.

If you import (or link to) "raw" Excel data, then use queries to parse the
data into well-normalized relational tables in Access, then you definitively
HAVE.

More info, please ... ("how" depends on "what")

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 pseudocode 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.

"bs base" bs wrote in message
...
I am fairly new to Access and am designing a new database. I retreive all
of
the data from various Excel worksheets. I have 5 tables that I will update
from excel on a monthly basis then display the information in forms and
reports. And, 1 tablet that I will add information directly into the
database
in a seperate form.

All of the tables have information pertaining to the parts that we make.
So,
I have made an additional table that lists just the part numbers and use
that
in creating relationships between the other tables, but am not sure that I
need to do that. The 5 tables do not all contain the same part numbers.
One
table may have 3,000 parts and another table may have 2,500 parts and only
300 matching parts.

Am I on the right track to relate these tables or do I need to approach it
another way? We add new parts numbers on a regular basis so I am seeing
that
I might run into some major issues with the parts table.