A composite attribute in Microsoft Access

Hello EE. I am taking an Access class and I am having some difficulties. I come from a hardware and networking background which doesn't help any. I am trying to design a database for a project with a few tables. The tables have some common attributes like Addresses for example. The requirement is that Addresses be a composite attribute comprised of specific fields. I am trying to figure out what that means and how to implement it. Does it mean creating another table and linking it with a key? Any advice would be greatly appreciated.
InSearchOfAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
a composite key is a combination of two or more fields that you will use as the primary key of the table.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
The term 'common attributes' isn't really an Access term.  Your instructor may be referring to Composite Key or Compound Key, however that would not likely apply to Addresses.  You should ask for a clarification.

mx
0
Hamed NasrRetired IT ProfessionalCommented:
Table: Persons (PersonID, personFirstNAme, PersonLastName, Address1, Address2, Address 3, DateOfBirth, ... - PersonID forms the primary key.)
Then You fill the table with unique record for each person. Assume you have a table of 5 Persons. The data can be anything, not in a specific order, but should be of the same format for all values in each field.
01  fName1  LName1 Add11 Add12 Add13  01/01/2000
02  fName2  LName2 Add21 Add22 Add23  02/02/2000
03  fName3  LName3 Add31 Add32 Add33  03/0132000
04  fName4  LName4 Add41 Add42 Add43  04/04/2000
05  fName5  LName5 Add51 Add52 Add53  05/05/2000
You can query this table.
Another table may be, Meals consumed,
Meals (MealID, PearsonID, MealNAme, PlaceConsumed - MealID and PersonID form the Primary Key, a composite key)
01  01  Meal1  Place1
02  01 Meall2  Place1
01  02  Meal1  Place1
02  02 Meall2  Place2
and so on..

To query the data to find out the meals consumed and places for each person, you create a query by linking the Persons, and Meals tables through the field PersonID. This will make available all the data as if it is is a wider table.
01  fName1  LName1 Add11 Add12 Add13  01/01/2000 01 01 Meal1  Place1
01  fName1  LName1 Add11 Add12 Add13  01/01/2000 02 01 Meall2  Place1
and so on.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Rey Obrero (Capricorn1)Commented:
if you need more info, google on
composite keys in access table,
how to create a composite key in access table
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Typo ...The term 'common attributes' isn't really an Access term.

s/b The term 'composite attributes' isn't really an Access term.
                      ^^^^^^^^^

mx
0
Armen Stein - Microsoft Access MVP since 2006PresidentCommented:
Maybe the instructor meant for you to build a set of custom field templates for Address fields.  Search help for "field template".

But I agree that the best approach is to just ask the instructor for clarification.
0
InSearchOfAuthor Commented:
The wording on the assignment was:
There are fiour groups and each gpoup will represent one table. Each table will have SSN#, Name, DOB, Phone, and Address. The Address attribute will be a composite consisting of street number , apt, city, and zipcode fields. Then I have to creat an E/R model. I understand table creation and the E/R model. I don't know how to show the composite Address with the addtion fields.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
OK ... ask the instructor *exactly* what they mean by 'composite Address' ?

There are so many ways you could do the address information.  Most likely if I was doing it ... depending
on what data needed to be extracted later (reports, searches, etc) ... I would probably have a separate field for each of those 'attributes' (st num, apt, city, <state>?, zipcode) ... again depending ....

mx
0
InSearchOfAuthor Commented:
Thanks for your help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.