Assignment #23
(10 points)

  1. Watch Video #2 - "Microsoft Access: Including Data Validation" at one of the following URLs:
    http://www.billrosener.com/teaching/videos/office/2013/access/ - MS Access 2013
    http://www.billrosener.com/teaching/videos/office/2010/access/ - MS Access 2010

  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 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 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 "assignment23.aacdb" when you are finished.

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



Grading Rubric
Required Elements Points Possible Does not meet requirements Meets some requirements Meets or exceeds all requirements Your Score
1. Limited Gender to either "F" or "M" on the Patient table. 2 0 1 2 __/2
2. Disallowed the digits 5 or 6 to be entered for the state on the Patient table. 2 0 1 2 __/2
3. Limited TherNumber between 0 and 50 on the Patient table. 2 0 1 2 __/2
4. Ensured that the enddate is more recent than the startdate on the Therapist table. 2 0 1 2 __/2
5. Changed the first entry in the Patient table to your own first and last name. 2 0 1 2 __/2
Total points __/10