Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » Primary key data
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Primary key data
Resolved · Medium Priority · Version 2007
Reply
Primary key data
Hi,What is the purpose of identifying some data as "primary key"?
Thanks,
Gerardo
For upcoming training course dates see: Pricing & availability
RE: Primary key data
Hi GerardoThe primary key of a relational table uniquely identifies each record in the table. It has to be unique such as employee number or Product code.
A good example would be a table containing all the names of students in a school.
You cannot use the students names as an identifyer because there will certainly be students with the same names but by making the Student ID as the primary key the system will warn you if you try and create a new student with an existing ID number.
The ID number can then be used in other tables to refer to the students
Hope this helps
Carlos
Tue 12 May 2009: Automatically marked as resolved.
|
 |
|
» Forum post: Excel 2007 - Addition of formatted cells |
Hi, after i have formatted cells, how do then add up only some of the proceeds... i.e. if i have inserted a formula to turn them yellow... how do i only add the yellow cells? 
