Validating date field
A field validation rule checks input to a field, and is applied when the focus leaves the field.A record validation rule checks input to one or more fields is applied when the focus leaves the record.
To add validation rules to a table, you open the table and use commands on the Fields tab of the ribbon.
Access provides a number of ways to restrict input: You can use these methods of validating data alone or in combination with each other.
Data types are not optional, and provide the most basic type of data validation.
Validation rules can be set in either table design or table datasheet view.
There are three types of validation rules in Access: 1.
You can compare values across different fields using a record validation rule.