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

Question

Share Report Error

In Access, what is the purpose of the 'Index' property?

A. To create a primary key

B. To enforce uniqueness

C. To speed up searching and sorting on that field

D. To set a default value

Answer: Option C

Solution (By JKSSB Mock Tests)

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

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

In MS PowerPoint, which option is used to hide a slide during a presentation?

A. Hide Slide

B. Skip Slide

C. Ignore Slide

D. Mute Slide

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
You can right-click a slide in the thumbnail pane and select 'Hide Slide' to skip it during the slideshow. It remains in the file but not shown.

This question belongs to: Computer Microsoft Office

Question #2

Which action query type in MS Access copies selected data rows from one or more existing source tables and creates a brand-new table with those records?

A. Make-Table Query

B. Crosstab Query

C. Append Query

D. Update Query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A Make-Table Query extracts specific records from existing source fields and uses them to create a brand-new table in the database file.

This question belongs to: Computer Microsoft Office

Question #3

Which of the following database tools in MS Access provides a user-friendly layout or digital form explicitly designed to view, input, or navigate individual data records?

A. Form

B. Query matrix

C. Macro routine

D. Report

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Forms serve as user interface layouts that simplify data entry, record modification, and database navigation tasks for end-users.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs