|
The
Primary Key creates unique numbers that are indexed (no duplicates).
The Primary Key should have a unique name. By default, Microsoft
Access just enters "ID" for the Field Name. We can do better.
5.
Try it: Rename the Primary Key Select the
Field: ID Edit the
Field Name: CustomerID Try
this, Too: Save the Table Go to
File->Save. Done and
done. Keep
going...
Memo to Self: Naming should
conform to rules. The Primary Key Field Name should match the type
of content the little Table stores. For example, CustomerID is the
Primary Key for the customer Table, tblCustomers. Table
Tools->Design->Tools->Primary Key
Exam 77-885: Microsoft Access 2010
2. Building Tables
2.4.1. Set Relationships: Define
Primary Keys |
|
| |
