158k views
1 vote
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?

User Sietse
by
6.9k points

1 Answer

4 votes

Answer:

Input Mask

Step-by-step explanation:

In this scenario, the best tool for Raul to use would be an Input Mask. When dealing with Microsoft Access or any other database tool, Input Masks are a great way of validating data inputs so that they always match the desired format. In this case, Raul would need to use input mask and apply the desired format while comparing it to the order date, therefore, making sure that it is always a minimum of 2 days after before it is accepted as a valid entry in the database.

User Alexander Janssen
by
6.5k points