How to set verification rules in access

Access validation rules are a data validation tool used to ensure that data meets specific conditions and prevent invalid data from being entered. Steps to set validation rules: 1. Select the field for which you want to set validation rules; 2. Open the "Field Properties" dialog box and switch to the "Find" tab; 3. Enter the validation rules in the "Validation Rules" field; 4. In Error message when the input in the Validation Text field does not match the rules; 5. Click OK to save the changes.

How to set validation rules in Access

Access validation rules are a data validation tool used to ensure The data in the data table meets certain conditions. Setting validation rules can help you maintain the accuracy and completeness of your data.

Steps to set validation rules:

1. Select the field for which you want to set validation rules: In datasheet view, right-click The field for which you want to add a validation rule, and then select Properties.
2. Open the "Field Properties" dialog box: In the "Field Properties" dialog box, switch to the "Find" tab.

3. Set validation rules: In the Validation Rules field, enter your validation rules. The following operators can be used:

   • is equal to (=): "="
   • is not equal to (!=): "<> "
   • Greater than (>):">"
   • Less than (<):"<"
   • Greater than or equal to (>=): ">="
   • Less than or equal to (<=): "<="
   • Between: "Between"
   • Not: "Not"
   • ##has ( Like): "Like"
   • Not Like: "Not Like"
4. Set verification text :In the Validation Text field, enter the text to be displayed when the data does not meet the validation rules. This text will be displayed as an error message.
5. Click OK to save changes: The validation rules are now set.

Example validation rule:

• Ensure that the age field can only contain integers between 18 and 65: Between 18 And 65
• Verify that the email address field contains the "@" character: Like "*@*"
• Make sure the zip code field only contains numbers: Like "##"
• Make sure the date field is no earlier than January 1, 2023 Day: >= #01/01/2023</strong></li> <li> <strong>#Prevent duplicate values ​​from being entered in the field: </strong><code>Is Unique

The above is the detailed content of How to set verification rules in access. For more information, please follow other related articles on the PHP Chinese website!