Question

how to create a primary key

Answer 1

Add or change a table’s primary key in Access

Applies To: Access for Office 365 More...

A primary key is a field or set of fields with values that are unique throughout a table. Values of the key can be used to refer to entire records, because each record has a different value for the key. Each table can only have one primary key. Access can automatically create a primary key field for you when you create a table, or you can specify the fields that you want to use as the primary key. This article explains how and why to use primary keys.

To set a table’s primary key, open the table in Design view. Select the field (or fields) that you want to use, and then on the ribbon, click Primary Key.

Note:  This article is intended for use only with Access desktop databases. Access automatically manages primary keys for new tables in Access web apps and web databases. Although it is possible to override these automated primary keys, we don’t recommend that you do.

Answer 2

hyy dear....

here ur answer is....

To set the primary key:

Open the database that you want to modify.

In the Navigation Pane, right click the table in which you want to set the primary key and, on the shortcut menu, click Design View.

Select the field or fields that you want to use as the primary key.

To select one field, click the row selector for the field you want.

To select more than one field to create a composite key, hold down CTRL and then click the row selector for each field.

On the Design tab, in the Tools group, click Primary Key.

HOPE THIS WILL HELP U ✌️✌️