Access: Claim Status Summary Report

Please make this claim status report by following the instructions.  This is for a make believe health care provider.

Create a monthly Claim Status Summary report. Please include the insurance company number, the patient number and name, the procedure date, the procedure code and description, the fee, the date the claim was filed, the amount of the claim, the amount of reimbursement, and the amount remaining unpaid. He wants you to group the data by insurance company number, with subtotals by company and grand totals, for each numeric field. When you design the report, make sure to include printer spacing charts, a mock-up report, and a report analysis form.

See attached file for full problem description.

Attached file(s):

NCHC.mdb  View File