Assignment #24
(10 points)

  1. Watch Video #2 - Microsoft Access 2007: Including Data Validation at the following URL:
    http://www.techvideos.com/office/2007/access/

  2. Add data validation to the file clinic.accdb as shown and illustrated in the video.
    In particular implement the following rules.
    • Limit Gender to either "F" or "M" on the the Patient table.
    • Do not allow the digits 5 or 6 to be entered for the state on the Patient table.
    • Limit TherNumber between 0 and 50 on the the Patient table.
    • Ensure that the enddate is more recent than the startdate on the Therapist table.

  3. Change the first entry in the Patient table to your own first and last name.

  4. Save your work as "assignment24.aacdb" when you are finished.

  5. Upload this file to YOUR-CLASS-WEBSITE.