4.14. Set DATA-VALIDATION RULES

To ensure that the data entered into your database table is of a valid type, you can set up your database table to control exactly what kinds of data are allowed in the cells This is handy if other people use your database table to enter records You can make sure that they type the right kind of data in a cell by assigning a data-validation rule

In addition to ensuring that the right types of characters are entered — for example, text or numbers — you can also set up data-validation rules to, for example, restrict entries to a certain range of dates You can also set up rules to limit data-entry choices by offering a drop-down list of options