CBSE BOARD X, asked by Anonymous, 1 year ago

how to set an primary key and remove it in a tables which is created in MS Access

Answers

Answered by AJAYMAHICH
3
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.


ARiyajangra: hllo
AJAYMAHICH: hiiiiiii
ARiyajangra: hllo
AJAYMAHICH: unblock kro
ARiyajangra: kk
ARiyajangra: yrr Apki chat nhi h
ARiyajangra: maine req bheji h
Answered by NeverMind11
3
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.

Similar questions