In MS Access, what is a 'Primary Key'? MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, what is a 'Primary Key'?

A. A field used for sorting

B. A field that stores external data

C. A field that allows duplicate values

D. A field that uniquely identifies each record in a table

Answer: Option D

Solution (By JKSSB Mock Tests)

A Primary Key is a field (or combination of fields) that uniquely identifies each record in a table. It cannot contain null or duplicate values.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1

In MS Access, what is the purpose of the 'Compact and Repair' database utility?

A. Creates a backup

B. Splits the database into front-end and back-end

C. Reduces file size and fixes corruption

D. Encrypts the database

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Compact and Repair reclaims unused space and repairs minor issues.

This question belongs to: Computer Microsoft Office

Question #2

In MS Word, which tab contains the option to insert a table of contents?

A. Home

B. Insert

C. References

D. Review

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Table of Contents command is located in the References tab, in the Table of Contents group.

This question belongs to: Computer Microsoft Office

Question #3

Which of the following field properties in MS Access determines the maximum number of characters that can be stored in a 'Short Text' data type field?

A. Validation Rule

B. Format

C. Field Size

D. Input Mask

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Field Size property specifies the upper limit of character storage for a Short Text field, which defaults to 255 characters but can be set to any value between 1 and 255.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs