What is a primary key? How do we set a primary key?

1.	What is a primary key? How do we set a primary key?
Answer» Primary key is the key which is used to uniquely identify the records into the table. To set the primary key you have to follow the steps given below: Step 1 Select the field that you want to set as a primary key. Step 2 Click Primary Key button from the Design tab. or Right click on the selected field and select Primary Key.

Answer»

Primary key is the key which is used to uniquely identify the records into the table. To set the primary key you have to follow the steps given below:

Step 1 Select the field that you want to set as a primary key.

Step 2 Click Primary Key button from the Design tab.

Right click on the selected field and select Primary Key.

Discussion

No Comment Found

Related InterviewSolutions

When Memo data type is preferred over Text type for a field?
What data type should you choose for a zipcode field in a table?(a) Text (b) Number (c) Memo (d) All of these
Write one example of each field, for which you would use1. Text data type2. Memo data type
Which field properties are used in Office Access 2007? Give the purpose of each field property.
Give any one difference between freezing a field and hiding a field.
What is a primary key? How do we set a primary key?
What is Fixed Field Length?
Write one example of data field for which you would set the Required property to Yes?
What is the purpose of Default Value field property?
The default data type for a field is(a) Number(b) AutoNumber(c) Currency(d) Text

What is a primary key? How do we set a primary key?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment