How to set verification rules 0-100 in access

To set the validation rules for 0-100, you need to follow the following steps: 1. Open the table design view; 2. Select the field to be validated; 3. Enter the validation rule expression: Between 0 And 100; 4. Set the validation message ( Optional); 5. Save changes. When validating, input that does not comply with the rules will trigger a validation message, preventing changes from being committed.

How to set 0-100 validation rules in Access

In Access database, validation rules are used Ensure data input meets specific standards. To set the validation rules for 0-100, please follow the steps below:

Step 1: Open the table design view

• Right click on the validation rule you want to set table, and then select Design View.

Step 2: Select the fields to validate

• In the "Field Name" column, click the field for which you want to set validation rules.

Step 3: Add Validation Rules

• In the Field Properties pane, find the Validation Rules property.
• Enter the following expression in the validation rule field:

<code>Between 0 And 100</code>

Step 4: Set validation message (optional)

• In the "Validation Message" attribute, enter a message to be displayed to the user when the input does not meet the validation rules. For example:

<code>请输入 0 到 100 之间的数字。</code>

Step 5: Save changes

• Click the Save button to save changes to the table design.

How validation works:

When a user enters data into a field that is subject to a validation rule, Access checks whether the input complies with the rule. If the input does not match, Access displays a validation message and prevents the user from committing changes.

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