Detailed tutorial on adding validity to access field

How to add validity to fields? In fact, it is very easy to operate in access software. Today, the editor is here to provide you with a detailed tutorial on adding validity to access fields. I hope it can help friends in need.

Open the data table that needs to be modified and click View Options

Find the design view in the pop-up drop-down menu

Open the design view panel. In the design view, add a validity rule to the graduation institution. Click the field of the graduation institution to select it.

​​Click on the query option, as shown by the red arrow

In the column of validity rules, enter in("Peking University", "Tsinghua", "Capital Normal University"). The meaning of this code is that the data in this field must be from the three universities of Peking University, Tsinghua University and Capital Normal University. No other data can be entered.

Click the save button

A warning message pops up because there is already data in the data table, but the data does not comply with the validation rules just established. Click Yes to start testing the data with the new rules

Wait a few minutes and a new warning message will pop up. Click Yes to continue using this rule to constrain the data, so that the original data will be deleted.

​​​Click Datasheet View above the menu bar to return to Datasheet View.

We see that the original data has deleted those data that do not comply with the validity rules.

Try to enter the words "河大"

The prompt message says that the validity rules are not met, so your table can only input data that meets the validity rules.

      以上这里为各位分享了access为字段加上有效性的详细教程。 Friends in need should hurry up and read this article.