CIS2510Written Assignment 5Points: 60Part A-Dr. Jones has asked you to create a monthly Claim Status detail report. He wants you to include theinsurance company number, the patient number and name, the procedure date, the procedure code anddescription, the fee, the date the claim was filed, the amount of the claim, the amount ofreimbursement, and the amount remaining unpaid. He wants you to group the data by insurancecompany number, with subtotals by company and grand totals for each numeric field.1.Design amock-up report (not a print chart!)according to these specifications. MS Word or Excelformat would be appropriate.2.Submit your final document to M5 Written Assignment submission link.You will be graded on completeness and neatness.
You've reached the end of your free preview.
Want to read both pages?
Comparison of relational database management systems,insurance company number