Primary Key Properties

The definition of a Primary Key can be seen in the Field Properties at the bottom of the Table Design window.

 

4. Try it: Review the Field Properties

Field Size: Long Integer, a whole number* for counting.

New Values: Increment

Index: Yes (No Duplicates)

 

So, when a record is deleted from the Table, it is deleted permanently by design and by default in an Access database. The ID number is deleted as well. It cannot be reassigned to another customer or product.

 

Keep going...

 

* The Computer Mama sez: Last time we looked, we only had whole customers, although some may be half crazy. Others may be totally crazy.

Table Tools->Design->Tools->Primary Key

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.4.1. Set Relationships: Define Primary Keys