Question

QB) Which of the following property defines a criteria for a
field?
a Validation Rule
b Validation Text
c Caption​

Answer 1

Explanation:

Restrict data input by using validation rules

Access for Microsoft 365 Access 2019 More...

You can vet or validate data in Access desktop databases as you enter it by using validation rules. You can use the expression builder to help you format the rule correctly. Validation rules can be set in either table design or table datasheet view. There are three types of validation rules in Access:

1. Field Validation Rule You can use a field validation rule to specify a criterion that all valid field values must meet. You should not have to specify the current field as a part of the rule unless you are using the field in a function. Restrictions on types of characters to be entered in a field may be easier to do with an Input Mask. For example, a date field might have a validation rule that disallows values in the past.

Quick examples:

Disallow date values in the past: >=Date()

Generally accepted email format: Is Null OR ((Like "*?@?*.?*") AND (Not Like "*[ ,;]*"))

Number less than or qual to five: <=5

Currency field can't be negative: >=0

Answer 2

Answer:

option a validation rule