Discuss how the Validation Rule field property helps to control data entry and why that is important.
What will be an ideal response?
The Validation Rule property restricts data entry in a field to ensure that correct data are entered. The validation rule checks the data entered when the user exits the field. If the value entered violates the validation rule, an error message displays and prevents the invalid data from being entered into the field. For example, you can set a validation rule that prevents users from entering invalid dates or values outside of a specific range.
You might also like to view...
Which of the following describes an IP address?
a. It is referred to as a dotted quad. b. It identifies any computer connecting to the Internet. c. It identifies a website. d. all of the above
Queries in Access can be exported as a web page
Indicate whether the statement is true or false