Montessori Training of Southern Nevada Hospital Admission Database Worksheet

Your Task

After your work on the hospital admission database, Panther Memorial was impressed enough to engage you to design & build a claims database for a small dental practice it happens to have. You will develop an entity relationship model based upon the ADA Dental Claim Form and the related Completion Instructions. Then you will implement your design using Microsoft Access 2010 or newer.

Deliverables

• A PDF created from LucidChart that contains your model of the ADA Dental Claim form
• A Microsoft Access database that contains your implementation of your model

Background Materials
ADA Dental Claim Form Completion Instructions 2012 (PDF)

ADA Dental Claim Form 2012 (PDF)

Your Lucidchart diagram must be submitted as a PDF file generated directly from Lucidchart (no embedded screenshots, etc). Failure to do so will result in a grade of zero points.

It is your responsibility to correctly submit the entire assignment on time in Canvas and you may want to reopen your uploaded file to confirm the submission.

Instructions
Panther Memorial has reviewed the Completion Instructions and wants you to pay particular attention to the following:

1. All fields should be of the appropriate data type.
2. The Completion Instructions sometimes indicate that “This Item is always completed” or ”This section must be completed for all claims” Make sure all the fields in those sections are required fields except for Field #58.
3. Unfortunately not much can be defaulted, but do configure the default value for the one field as specified by the Completion Instructions.
4. Use an input mask for any phone number, date, or zip code.
5. For dates, utilize the short date format.
6. Create combo boxes using the values from the Completion Instructions for each of the following fields:
   • Provider Specialty
   • Place of Treatment
   • Area of Oral Cavity
   • Tooth Surface
   • Relationship to Policyholder/Subscriber
7. Implement a validation rule and an appropriate error message for Missing Teeth Information to ensure that a tooth number between 1 and 32 is provided.
8. Implement a validation rule and an appropriate error message to ensure the Fee is greater than zero.