Exam 77-424: Microsoft Access 2013 1.0 Create and Manage a Database 1.2 Manage Relationships and Keys: Set Primary Key Fields

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