New to Access 2007

[Pamela]

I am in school and I have an assignment that wants me to show the keys and relationships in the sales contact database system that I did from the previous week assignment. I had to make a table with the information listed below:
Customer Name
Address

City

State

Zip code

Name of their company

Business Phone

Business Fax

Home phone

Mobile phone

Journal

Categories

Invoice Order

How many ordered

What was bought

Employee ID number

I have no problem inputting all this into Access but I do not know and do not understand anything about keys and relationships for the table. Any help would be appreciated

Pamela Kneeland

 

[John W. Vinson]

I have no problem inputting all this into Access but I do not know and do not understand anything about keys and relationships for the table. Any help would be appreciated

Study your course material, and/or some of the references at these sites.
Crystal's tutorial and Jeff's "Database Design 101" links may be a good start.

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

John W. Vinson [MVP]