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

Question
In Access, what is the purpose of the 'Validation Rule' property?
A. To define a relationship
B. To format the field display
C. To set a default value
D. To restrict the values that can be entered in a field
Answer: Option D
Solution (By JKSSB Mock Tests)
Validation Rule limits the data that can be entered, e.g., >0. Default Value sets initial value, Format controls display, Relationship links tables.
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
What does Ctrl + Shift + End do in MS Word?
A. Selects from the cursor position to the end of the document
B. Moves cursor to the end of the document
C. Selects the last page
D. Deletes to the end of the line
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl+Shift+End selects from the insertion point to the end of the document.
This question belongs to: Computer Microsoft Office
Question #2
What is the default orientation of a page in MS Word?
A. Letter
B. Landscape
C. Portrait
D. A4
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Default orientation is portrait. Landscape is wider.
This question belongs to: Computer Microsoft Office
Question #3
In MS Access, what does the 'Indexed' property do to a field?
A. Prevents the field from being left blank
B. Speeds up searches and sorting on that field
C. Automatically enters a default value
D. Ensures the field value is unique
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Indexing improves query performance. To enforce uniqueness, set Indexed to 'Yes (No Duplicates)'.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Hardware 430 Operating Systems 510 Programming Languages 0 Cyber Security 269 Database Management System (DBMS) 278
Explore Subjects
Reasoning 2064 Science 4430 Accountancy and Statistics 3179 Economy GK 2220 Computer 5279
Practice Mix
Which national park in Himachal Pradesh is known for its high-altitude grasslands and is a key habitat for the Himalayan Tahr?
Who was the first Indian to be the Coordination Secretary?
Which of the following is an example of an animal cell that lacks a nucleus in its mature form?
What is the primary limitation of configuring a network using a point-to-point Full Mesh Topology as the number of nodes scales high?
Double fertilization in angiosperms was discovered by: