Reference no: EM133979174

Healthcare Database Development using MS Access 

For this assignment, you will create a database that includes a table, form, report, and queries using MS Access.

Scenario: 
A small healthcare facility still using the paper-based medical record, needs an MS Access database to collect, maintain, and search providers' and patients' information.     
Create MS Access database with the following information.
1. Create a New blank database
2. Name the Access file as your last name in all lowercase letters. (For example, Janet Learner would save her file as "learner.accdb") (Be sure to "name" the database before hitting the "Create" button)
3. In Design View, create a table using the structure shown below:
a. Name the table: Patient Table
b. Set the Patient # field as the Primary Key
5. Modify the column width as necessary
6. Create a Form using the Form Wizard based on the Patient table with these specifications:
                a. Use All Fields
              b. Layout: Columnar
                c. From Name: Patient From
 
7. Add the following records to the Patient Table using the From.

8. When finished adding the records, save the Form as Patient From.
9. Using the Report Wizard, create a report based on Patient Table with the following specifications.
                a. Use All Fields
                b. Group by: First Visit
                c. Layout: Stepped
                d. Orientations: Landscape
                e. Title the report: Patient Report
                f. Adjust column width in Design View as necessary.
10. Create Queries
 a. Query 1: Create a query from the Patient Table using the Simple Query Wizard.
Generate a report with names and patient numbers of the patients who visited in 2019
Select the appropriate fields and the appropriate criteria.
 Run this query
Explain how these results can be used by the management. 
Query 2: Create a query from the Patient Table using the Simple Query Wizard
Generate a billing statement of patients who owe more than $300
Select the appropriate fields and the appropriate criteria.
Run this query.
Explain how these results can be used by the non-clinical management. 
 
11. Save your completed Access file and upload to the week 5 assignment folder.
12. Reflect on the process, its challenges and potential pitfalls in the database utilization by the clinic. Would you offer an alternative? Why? Get Exceptional Assignment Help for all forms of Assignments.