In MS Access, which field property ensures that each record has a unique identifier? MCQ with Answer and Explanation

In MS Access, which field property ensures that each record has a unique identifier?

A. Indexed

B. Validation Rule

C. Required

D. Primary Key

Answer: Option D

Solution (By JKExamLibrary)

A Primary Key uniquely identifies each record and does not allow nulls. Indexed improves search, Required forces data entry, Validation Rule checks input.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error

What is the keyboard shortcut to extend a cell selection block from the active cursor position down to the very last populated cell in that column in MS Excel?

A. Ctrl + Shift + Down Arrow

B. Shift + Page Down

C. Ctrl + Shift + End

D. Alt + Shift + Down Arrow

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
Ctrl + Shift + Down Arrow extends the selection range down to the last non-blank cell in that column. Pressing Ctrl + Down Arrow jumps to that cell without selecting the range.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In MS Excel, what does the error message '#NULL!' typically indicate?

A. A cell contains an invalid division calculation

B. A required parameter in a formula is missing

C. A formula specifies an intersection of two cell ranges that do not intersect

D. A numeric value is outside of the expected bounds

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
The #NULL! error appears when a space operator is used between two ranges that do not actually cross paths or intersect (e.g., =SUM(A1:A2 B1:B2)).

This question belongs to: Computer Microsoft Office

Question #3 Report Error

What will be the output of the MS Excel formula =NETWORKDAYS(DATE(2026,6,15), DATE(2026,6,19)) if there are no holidays during this period?

A. #VALUE!

B. 3

C. 5

D. 4

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
The NETWORKDAYS function calculates the number of working days (Monday through Friday) between two dates, inclusive of both start and end dates. June 15, 2026 (Monday) to June 19, 2026 (Friday) is exactly 5 business days.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs