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

In MS Access, what is a 'Primary Key'?
A. A field that allows duplicate values
B. A field used for sorting
C. A field that stores external data
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.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
Which of the following is not a valid way to start a new slide in MS PowerPoint?
A. New Slide button on Home tab
B. Right-click in the slide pane and select New Slide
C. Ctrl + N
D. Ctrl + M

Correct Answer: Option C


Explanation:
Ctrl + N opens a new presentation, not a new slide. Ctrl + M inserts a new slide. The other options insert a new slide.

This question belongs to: Computer Microsoft Office
Question #2
In MS Word, to create a table by drawing, use:
A. Home -> Table
B. Layout -> Draw Table
C. Design -> Table -> Draw
D. Insert -> Table -> Draw Table

Correct Answer: Option D


Explanation:
Insert tab -> Table -> Draw Table.

This question belongs to: Computer Microsoft Office
Question #3
In MS Access, which data type stores a calculated value that depends on other fields?
A. Calculated
B. Memo
C. Number
D. AutoNumber

Correct Answer: Option A


Explanation:
Calculated data type creates a field whose value is computed.

This question belongs to: Computer Microsoft Office