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

Question Report Error

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

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

B. To set a default value

C. To format the field display

D. To define a relationship

Answer: Option A

Solution (By JKExamLibrary)

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

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error

In Excel, the VLOOKUP function's fourth argument (range_lookup) set to FALSE indicates:

A. Approximate match

B. Exact match

C. Closest match

D. Descending order

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
FALSE requires an exact match. TRUE or omitted allows approximate match.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In MS Word, what is the maximum zoom level?

A. 200%

B. 500%

C. 400%

D. 1000%

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
Maximum zoom in Word is 500%.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In MS PowerPoint, what key should a presenter hold down while using the pen tool during a live show to draw rigid horizontal or vertical annotation lines?

A. Ctrl

B. Alt

C. Shift

D. Tab

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Holding the Shift key during a presentation slide delivery locks the integrated pen tool tracking into perfect horizontal or vertical lines.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs