HCA DATABASE homework

HCA 542: Health Care Database Design and Management Assignment IV 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 provided. Starter Database When starting your project, download the Panther Memorial Starter Database from D2L and then add to this database. Start with a brand new database download. DO NOT use your Assignment III database. Individual work This assignment will be completed individually without collaboration with other students. Submission Submit your assignment to the D2L dropbox by 11:55 on the due date in the course schedule on D2L. The deliverable will be submitted via the D2L dropbox. It is your responsibility to correctly submit the entire assignment on time in D2L. To ensure that your items are correctly uploaded, reopen your files from the D2L dropbox to test it. Note that checking your submission is especially important with an Access database to ensure that you uploaded the actual database file (*.aacdb) file and not the security file (*.laccdb). Grading This project is worth 100 points. Data entry form (55 points total) 10 pts Fields and Labels 2 pts Form Title 6 pts Aesthetics 5 pts Ability to successfully enter a complete record 12 pts Dropdowns 16 pts Sub-forms 4 pts Navigation Button Report (45 points total) 10 pts Fields and Labels 5 pts Aesthetics 10 pts Grouping 5 pts Alternate Row Highlighting 5 pts Total Field 5 pts Page Breaks 5 pts Date and Time in Footer 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. Reports 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. Patient Bill (Page 3 of the Print Preview)