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

Question
In MS Access, what does the 'Indexed' property do to a field?
A. Speeds up searches and sorting on that field
B. Automatically enters a default value
C. Ensures the field value is unique
D. Prevents the field from being left blank
Answer: Option A
Solution (By JKSSB Mock Tests)
Indexing improves query performance. To enforce uniqueness, set Indexed to 'Yes (No Duplicates)'.
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 Access, what is a 'composite key'?
A. A primary key that consists of two or more fields
B. A key used to encrypt the database
C. An index that combines text and numbers
D. A foreign key referencing multiple tables
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A composite key is a primary key made up of multiple columns.
This question belongs to: Computer Microsoft Office
Question #2
In MS Access, what field rule dictates whether a database field can accept or store null values?
A. Default Value option
B. Allow Zero Length setting
C. Validation Rule
D. Required property
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
When 'Required' is set to 'Yes', the field cannot be left blank or contain a null value when saving records.
This question belongs to: Computer Microsoft Office
Question #3
In Excel, what does the COUNTA function count?
A. Only blank cells
B. Only text cells
C. Only numeric cells
D. All non-empty cells
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
COUNTA counts cells containing any type of data (numbers, text, errors, etc.), excluding empty cells.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Software 347 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?