SQLConfiguration SQLConfiguration


Table Design  «Prev  Next»

Adding Validation Rule - Exercise

Setting up validation for fields


Course project:

Adding a validation rule

Objective:

Practice using the Validation Rule property.

Exercise scoring

You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the Submit button to receive full credit.

Background/overview

Recall that you are the Access database administrator for the marketing and documentation departments of companies in the software and networking business. For one of your large clients, you need to set a database to display dates properly.

Download files

As we stated in the first module, the Consulting307.mdb database is included in the compressed download file available on the Resources page. If you've already downloaded the database, continue to work in that version.

Instructions

  1. Open the table called Hours in Design mode.
  2. Set the Validation Rule property of the field called DateWorked to ensure that the data entered is less than or equal to the system date.