Computer and Software Support


Test existing data against a new validation rule 

Microsoft Access

If you add a validation rule to an existing table, you might want to test the rule to see whether any existing data is not valid.

Note:  The following procedure works only with desktop database tables.

  1. Open the table that you want to test in Design View.

    On the Design tab, in the Tools group, click Test Validation Rules.

  2. Click Yes to close the alert message and start the test.

  3. If prompted to save your table, Click Yes.

  4. You might see a variety of other alert messages as you proceed. Read the instructions in each message, and then click Yes or No, as appropriate, to complete or stop the testing.

 

Go Back

OR

Next Page

You can also

Return to Validation Rule