Asked by jennifer ocampo on May 07, 2024

verifed

Verified

If the Quantity field has "< 50" as its validation rule, and a user tries to enter "100" in the field, Access displays the message in the _____ property.

A) Explanatory Message
B) Validation Text
C) Violation Message
D) Error Text

Validation Rule

A criterion or set of criteria that data must satisfy before it is accepted or processed by a system.

Validation Text

A message that appears when entered data does not adhere to predefined rules or criteria in a form or database.

Access

A database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.

  • Recognize the importance of validation rules and messages to ensure data integrity.
verifed

Verified Answer

JA
Juanita Appiah GyamfiMay 10, 2024
Final Answer :
B
Explanation :
The Validation Text property is used to display a message when an invalid entry is made in a field according to its validation rule. In this case, if a user enters "100" when the Quantity field has "< 50" as its validation rule, Access would display the message specified in the Validation Text property.