I need an Access DB that can:
1. Import a csv file containing a client name, dental procedures performed, date of service, insurance portion paid, patient portion paid, and remaining balance.
2. Create a billing statement form that allows:
a. A specific client to be selected from the imported file.
b. Entry of insurance information such as patient deductible and the percentage of the procedures the insurance will pay for (such as 80%, 50%, etc).
3. Then print out a billing statement where all of this information is displayed. Also, math should be performed to calculate how much the insurance should pay and how much the patient should pay. For example, if the insurance company should pay 80% of a procedure that costs $100, then the insurance will pay $80 and the patient pays $20.