In MS Access, what does the 'Indexed' property do to a field? MCQ with Answer and Explanation

Question Report Error

In MS Access, what does the 'Indexed' property do to a field?

A. Speeds up searches and sorting on that field

B. Prevents the field from being left blank

C. Automatically enters a default value

D. Ensures the field value is unique

Answer: Option A

Solution (By JKExamLibrary)

Indexing improves query performance. To enforce uniqueness, set Indexed to 'Yes (No Duplicates)'.

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

In PowerPoint, which feature automatically adjusts the size of text to fit within a placeholder?

A. Text Scaling

B. Both A and B

C. AutoFit

D. Shrink text on overflow

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
AutoFit options: Shrink text on overflow, Resize shape to fit text.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In Excel, the shortcut to select the entire column is:

A. Shift + Spacebar

B. Ctrl + Shift + Spacebar

C. Ctrl + Spacebar

D. Alt + Spacebar

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Ctrl+Space selects column; Shift+Space row.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In MS Access, which of the following is a valid data type for storing monetary values?

A. Double

B. Number

C. Currency

D. Decimal

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Currency is a specific data type designed for monetary values with fixed decimal precision to avoid rounding errors. Number can also store monetary but Currency is more appropriate.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs