How Do You Set Or Change The Primary Key In A Microsoft Access Database?
Primary keys are unique record identifiers that MS Access uses when retrieving information for a query or a report. With primary keys, you can join tables in relationships so that you can query both of them at once. These instructions are for Access 97. Open a table in Design view. Click the Row Selector for each field you want to set for the primary key. The Row Selector is the small box that allows you to select an entire row. Click on the Primary Key icon in the toolbar, or select Primary Key from the Edit menu. If you’ve selected a field for a Primary Key that already contains data or returns a null value, MS Access will not allow you to create a primary key. If desired, you can edit the data so it’s no longer duplicated.
