Defining a Primary Key

Every table in a relational database should have a primary key. Telling Access 2007 how to define the primary key is quite simple. Open the table in Design view and click the row selector to the left of the field you want to use as the primary key. If you need to select multiple fields for your primary key, hold down the Ctrl key and click the row selector of each additional field you need.

Note

For details about designing primary keys for your tables, see Article 1, “Designing Your Database Application,” on the companion CD.

After you select all the fields you want for the primary key, click the Primary Key button in the Tools group of the Design contextual tab on the Ribbon. Access 2007 displays a key symbol to the left of ...

Get Microsoft Office® Access 2007 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.