| 1) |
A primary key uniquely identifies each record
in a table |
| |
|
| 2) |
No duplicate values will be allowed to be entered.
That will ensure uniqueness of the primary key and no data redundancy.
(i.e. You won't be able to enter two different customers with
the same customer number in your table.) |
| |
|
| 3) |
Access forces you to enter a value for the primary
key field in every record. This is known as entity integrity.
You will not be able to leave that field blank (referred as
null value) since a message will pop up to let you know that
you need to enter a value for that field. |
| |
|
| 4) |
Access stores records on disk in the same order
as you enter them but displays them in order by the field values
of the primary key. This way you can work with your data in
a more meaningful, primary key sequence. |
| |
|
| 5) |
Access responds faster to your requests for specific
records based on the primary key. |
