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

Question

Share Report Error

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

A. Required

B. Validation Rule

C. Indexed

D. Primary Key

Answer: Option D

Solution (By JKSSB Mock Tests)

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

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

Share Report

In Excel, the VLOOKUP function's fourth argument (range_lookup) set to FALSE indicates:

A. Closest match

B. Exact match

C. Descending order

D. Approximate match

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
FALSE requires an exact match. TRUE or omitted allows approximate match.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

Which tab in MS Word would you use to add a table of contents?

A. References

B. Review

C. Insert

D. Layout

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Table of Contents is inserted from the References tab.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Excel, to copy a formula without changing relative references, you can:

A. Use Ctrl + ' to copy formula from above

B. Use Ctrl + R

C. Use Ctrl + D

D. Paste exact formula by editing in formula bar, copy, or use absolute references

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
To copy exact formula text, edit cell, select all text, copy. Or use absolute references.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs