Question

Raul needs to ensure that when users enter an order into the tblOrders, the shipping date is at least two days after the order date on the data entry. Which option should he use?

input mask
record validation
form validation
expression builder

Answer 1

Use a record-level validation rule (record validation).

Reason: this compares two fields in the same record (ShipDate vs OrderDate). In the table's Record Validation Rule property enter an expression such as:

[ShipDate] >= DateAdd("d",2,[OrderDate])

and set Record Validation Text to a friendly error message. Input masks format input, form validation would only work for that form, and the Expression Builder is just the tool to create the rule.