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

Question

Share Report Error

In Access, what is the purpose of the 'Validation Rule' property?

A. To define a relationship

B. To set a default value

C. To restrict the values that can be entered in a field

D. To format the field display

Answer: Option C

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

Share Report

In Excel, which formula will correctly return the text 'Hello' from cell A1 if A1 contains 'Hello World'?

A. =RIGHT(A1,5)

B. =LEFT(A1,5)

C. =MID(A1,1,6)

D. =TRIM(A1)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
LEFT(A1,5) extracts first 5 characters ('Hello'). RIGHT gets from right, MID from any position, TRIM removes extra spaces.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS PowerPoint, which tool allows you to select customized layout options to output 2, 3, 6, or 9 small presentation slides onto a single paper sheet for distribution?

A. Slide Sorter Setup

B. Outline Print Setup

C. Handout Master

D. Notes Page Layout

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Handout Master edits layouts for physical paper prints meant for audiences, containing custom configurations for multiple slides per sheet.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

Which data type field property option in MS Access lets you create a drop-down choice list that pulls options either from an existing table source or a hardcoded value set?

A. Attachment properties

B. Hyperlink Field Type

C. Lookup Wizard

D. Calculated Field choice

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Lookup Wizard establishes a lookup field that displays a clean dropdown list of choices derived dynamically from another database table reference or static list parameter.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs