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.

Computer Science & Information Technology

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

Computer Science & Information Technology

Queries in Access can be exported as a web page

Indicate whether the statement is true or false

Computer Science & Information Technology