What is the primary function of the built-in field property 'Validation Text' in an MS Access table designer screen? MCQ with Answer and Explanation

What is the primary function of the built-in field property 'Validation Text' in an MS Access table designer screen?
A. It functions as a placeholder pattern to guide manual typists.
B. It defines the calculation rule used to verify alphanumeric formats.
C. It sets the default value displayed inside the datasheet cell field.
D. It specifies the custom error message displayed to users when data violates a Validation Rule.
Answer: Option D
Solution (By JKExamLibrary)
Validation Text contains the custom error message that alerts users when an invalid entry violates the data constraints specified in the Validation Rule property.

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 MS PowerPoint, which feature can be used to copy all standard formatting, animations, colors, and styling from one object and apply it to another?
A. Style Manager
B. Format Painter
C. Animation Painter
D. Design Template

Correct Answer: Option B


Explanation:
The Format Painter tool copies style formatting from one item (text, shapes, backgrounds) and applies it directly to another target item.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In MS Word, which feature allows you to create a document by combining a main document with a data source?
A. Macro
B. Template
C. Style
D. Mail Merge

Correct Answer: Option D


Explanation:
Mail Merge is used to produce multiple documents from a single template and a data source, such as form letters, labels, and envelopes.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
In Excel, the formula =A1>B1 returns:
A. 1 or 0
B. TRUE or FALSE
C. Yes or No
D. Both A and B

Correct Answer: Option B


Explanation:
Logical comparison returns TRUE or FALSE. However, TRUE/FALSE can be coerced to 1/0, but direct result is boolean.

This question belongs to: Computer Microsoft Office