How to set the age of verification rules in access

Steps to verify age in Microsoft Access: 1. Select the field to be verified; 2. Enter the verification rule: Between 0 And 150; 3. Set the verification text, for example: "Please enter a valid age (0 -150 years old)"; 4. Save changes. If the age entered is not in the range 0-150, a verification text message is displayed.

How to set up validation rules in Access to verify age

Set up validation rules in Microsoft Access to verify age Very simple and prevents users from entering invalid data.

Steps:

1. Open the table and select the field where you want to set the validation rules

• In the navigation window grid, right-click the table for which you want to set validation rules and select Design View.
• Select the field for which you want to set the rule.

2. Set validation rules

• In the "Field Properties" pane, find the "Validation Rules" tab.
• In the "Validation Rules" field, enter the following rules:

<code>Between 0 And 150</code>

3. Set the verification text

• in the " In the Validation Text field, enter a message to display when the user enters data that does not comply with the rules. For example:

<code>请输入有效的年龄（0-150 岁）。</code>

4. Save changes

• Click the Save button to save the validation rules.

How to Setup

The validation rule states that the age must be between 0 and 150. If the user enters an age that is not within this range, they will receive a verification text message.

Other Notes

• Validation rules are not case-sensitive.
• More complex rules can be created using the AND and OR operators.
• Validation rules are only executed when you enter data into the field. If the data is already in the field, the rule will not be applied.

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