FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Open the table for which you want to validate records. On the Fields tab, in the Field Validation group, click Validation, and then click Record Validation Rule. Use the Expression Builder to create the rule.

Detailed explanation-2: -Data validation makes Access test data to make sure that it conforms to what you want to appear in the table. Data validation works best in number, currency, and date/time fields. You can create a validation rule for text entries, but doing so can be complicated-especially if you want to test a lot of text variables.