Montessori Training of Southern Nevada Work Should Be Done on Access Paper

Your Task

Panther Memorial has been please with your work and now would like you to develop a data entry forms and a report for the database.

Deliverables
A Microsoft Access database that contains your implementation of the data entry form and report that adheres to the instructions and entity relationship diagram provided.

Starter Database
When starting your project, download the Panther Memorial Starter Database from D2L and then add to this database.

Individual Work
This assignment will be completed individually without collaboration with other students.

Submission
Submit your Microsoft Access Database file to Canvas. 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.

Data Entry Form

Create the form as shown. Note that you need to create all of the form elements (boxes, buttons, etc). For example, the close button should perform as expected and closes the form.

Create dropdown (combo) boxes for any referenced table. For example, use Unit ID to link to the Unit table in order to display the Unit Name in the dropdown.

Problems and orders are contained in a subform. You may find it easier to create the subforms separately and then add them to your form.

Be sure to test your form by creating a new patient visit and entering information into each and every data field including the subforms. A form that does not successfully permit data entry is not a useful data entry form.

Report

Create a report that produces patient bills such as the example page shown. Note that you need to create all of the report elements (boxes, lines, bolding, alternate row highlighting, etc).

You may find it easier to create the query for the report first and then use that query as the data source for the report.

The report has a page header which contains the hospital name and address implemented as labels and a line. The group header contains the patient/visit information and the labels regarding the treatment. The total charges are in a group footer. The detail section simply holds the text boxes regarding treatments.

To create the sum, look at the group you created on Visit ID. In the group properties, one of the options will read “with no totals”. Change this to sum on Amount Charged at the footer level.

Note that each bill must appear on its own page in print preview (as you would expect for a real bill). Note that a bill is produced for each visit, not each patient.