Beginning MS Access 97

Unit 2: Answers to Additional Exercises

1. Define Primary Key.
   A Primary Key is a unique record identifier in each table.
   
2. Define Foreign Key.
   Foreign Key refers to the Primary Key of another table. The Foreign Key must be the same field type (Number) as the Primary Key.
   
3. Define a "relationship" between two or more tables.
   The data in each table must be related in some way - they have to need each other to be complete. In our Student & Advisor example that we have been using, there is related data in the pieces of information because each advisor has students to advise and every student has an advisor.

© 1998 - May not modify or copy without the consent of the authors.

Top of Page	LGTA HomePage