Assignment #22

  (10 points)

  1. Watch the video Data Validation (MS Access).

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

    Option A: (Preferred)
    Add data validation to the file assignment22-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.
    • 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.

    If you do not have MS Access installed on your own computer, consider visiting any NSU computer lab or using the NSU Virtual Desktop.

    Assignment #22 Screen Capture

    Option B: (A fallback for students struggling to gain access to the software)
    Review the video above multiple times until you are confident you can replicate the results. Next, document 10 insights you gained.

  3. Save your work as "assignment22" when you are finished.

  4. 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: Added the following data validations to the database:
1. Limited Gender to either "F" or "M" on the Patient table.
2. Limited TherNumber between 0 and 50 on the Patient table.
3. Ensured that the enddate is more recent than the startdate on the Therapist table. 		10 0 5 10 __/10
Option B: Provided insights that convinced the instructor you have watched the video closely and understand the key concepts. The summary carefully selects details and examples, including only those that best illustrate the key points Contains no spelling or grammar errors. 10 0 5 10 __/10