microsoft access advanced training - Data validation

Data validation allows you to guide the user to enter specific information into the fields. This helps to keep your database clean. You may hear someone using the word DATA INTEGRITY which is to have the data being correctly formatted and reliable for reporting use.

Data validation can be a mixture of INPUT MASKS and VALIDATION RULES. Input masks restrict the data to a specific FORMAT, whereas validation rules check the DATA that you have entered.

Regards

Richard