Assignment #23

  (10 points)

  1. Watch the video Microsoft Access: Including Data Validation (CC).

  2. Complete either "Option A" or "Option B" below:

    Option A: (Preferred)
    Add data validation to the file clinic.accdb as shown and illustrated in the video. In particular perform the following.
    • 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.
    • Change the first entry in the Patient table to your own first and last name.
    • Save your work as "assignment23.aacdb" when you are finished.

    Option B:
    In at least 300 words, summarize the video you watched. Save your work as "assignment23" when you are finished.


  3. Upload your work 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
Option A:
1. Limited Gender to either "F" or "M" on the Patient table.
2. Disallowed the digits 5 or 6 to be entered for the state on the Patient table.
3. Limited TherNumber between 0 and 50 on the Patient table.
4. Ensured that the enddate is more recent than the startdate on the Therapist table.
5. Changed the first entry in the Patient table to your own first and last name. 		10 0 5 10 __/10
Option B: The summary convinces the instructor that you have watched the video closely and understand the key concepts. The summary is selective about details and examples, choosing only ones that help to illustrate a key point. Contains no spelling or grammar errors. 10 0 5 10 __/10