Home » Microsoft Access » 08 - Data Validation
8
Record Validation Rules
Now that Michael is familiar with the field level validation, George moves onto the Record Validation Rules that will allow him to compare values from more than one field.
Activity: Create a Record Validation Rule to ensure that emp_date will always come after the emp_birthdate
- Open the table in Design View. On the taskbar, select Properties.
- Type the validation rule in the rule box.
- Type the validation text in the Validation Text Box.
Note: You can specify only one validation expression for a table. For more than one rule you can combine expressions for the Validation Rule property setting with the And operator.
