22
QuizMultiple Choice

Unit Test — Unit test

Question 22 • FT Business and Technology B IC – 76

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?

Answer
A
input mask
B
record validation
C
form validation
D
expression builder

Explanation

Use record validation because the rule compares two fields in the same order record. A record validation rule can require the shipping date to be at least two days after the order date, such as ShippingDate >= OrderDate + 2. An input mask controls how a value is entered, not whether the dates meet this condition.

AI-written and checked against the verified answer.

Previous
Next