In Access, what is the purpose of the 'Index' property? MCQ with Answer and Explanation

In Access, what is the purpose of the 'Index' property?
A. To enforce uniqueness
B. To speed up searching and sorting on that field
C. To create a primary key
D. To set a default value
Answer: Option B
Solution (By JKExamLibrary)
An index improves performance for searches and sorts. Primary key automatically creates an index, but Index property can be set for any field.

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 default font and size in MS Word 2016?
A. Times New Roman, 12 pt
B. Calibri, 11 pt
C. Calibri, 12 pt
D. Arial, 10 pt

Correct Answer: Option B


Explanation:
Default font is Calibri 11 pt since Word 2007.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
What will be the output of the MS Excel formula =CEILING.MATH(22.1, 5)?
A. 20
B. 22
C. 25
D. 30

Correct Answer: Option C


Explanation:
The CEILING.MATH function rounds a specified number upward to the nearest integer multiple of significance. The nearest multiple of 5 greater than or equal to 22.1 is 25.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
What is the shortcut key used to display the traditional 'Save As' file dialog window directly in MS Word and Excel?
A. F12
B. Shift + F12
C. Alt + F2
D. Ctrl + S

Correct Answer: Option A


Explanation:
The F12 function key opens the 'Save As' dialog box directly, allowing users to save files under alternative names, extensions, or file directories.

This question belongs to: Computer Microsoft Office