Panther Memorial Database

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: See file.

A Microsoft Access database that contains your implementation of your model

Instruction:

All fields should be of the appropriate data type.

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.

Unfortunately not much can be defaulted, but do configure the default value for the one field as specified by the Completion Instructions.

Use an input mask for any phone number, date, or zip code.

For dates, utilize the short date format.

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

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.

Implement a validation rule and an appropriate error message to ensure the Fee is greater than zero.