Validation Rules

Diving Line


If you need to print this page out, type your name in the box below.

Your Name : 


Information

This tutorial will show you how to use different validation rules in a database table.


Information
Presence Check

Open the table in Design View, using the View command Databases.

Databases


Click on the field you want to add the Presence Check to.  In this example, we are adding a Presence Check to the First Name field.

In the properties list, find the option for Required.

Change the required option to Yes.

Databases


Information
Length Check

To set a Length Check on a field (so you can set the maximum number of characters that can be entered), change the value in the Field Size property.  By default, the field size is 255.  You can change the field size to any value between 1 and 255.

Databases


Information
Input Mask

You can create a Input Mask for phone numbers and post codes.  To add an Input Mask, select the Input Mask property for the field and click on the Databases button.

Databases


You might be asked to save your database table.  Click Yes to save your table.

Databases

Select the type of input mask you want to apply to the field and click the Databases button.

Finally, click Finish to apply the input mask.

Databases


DoIT

Use your Employees database table to complete this task.

Add a presence check to the following fields ...

  • First Name
  • Surname
  • Address 1
  • Address 2
  • Post Code
  • Email


Add an input mask to the post code field

Add a length check to the first name and surname fields.  Make the maximum length 20 characters.

Add a length check to the Address1 field.  Make the maximum length 5 characters.


PrintIT  Print out this Page

Next  Adding Data


Last modified: Thursday, 5 November 2020, 12:24 PM