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
Patient Table
Field Name Data Type Field Size Other Field Properties
Patient # (Primary Key) Short Text 5
Last Name Short Text Default
First Name Short Text Default
Address Short Text Default
State Short Text 2 Format: Upper case Default value: IL
Zip Code Short Text 5
First Visit Short Text 4
Balance Currency Default
4. In Data sheet View, add the following data to the Patient Table.
Patient # Last Name First Name Address State Zip Code First Visit Balance $
54783 Williams Jack 62 Smith Lane MD 21202 2019 250
64589 Metheny Alexa 125 Fairview MD 21203 2019 200
95874 Van Wegan Alison 100 Quantico MD 21204 2019 350
23895 Jackson Ryan 2320 Hills Circle VA 20147 2020 325
96312 Berstein Krista 126 South Street VA 20148 2020 290
54387 Wylliams Karen 43 Jones Ave. VA 22193 2021 200
54123 (Your name) (Your name) (Your address) VA 22191 2021 315
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.
Patient # Last Name First Name ADDRESS city state Zip Code First Visit Balance
36987 Booy Aaron 21 Fairview Lane Ashburn VA 20146 2020 250
76213 McBurney Colton 45 Trotters Drive Hagerstown MD 21522 2022 350
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.
i. Generate a report with names and patient numbers of the patients who visited in 2019
ii. Select the appropriate fields and the appropriate criteria.
iii. Run this query
iv. Explain how these results can be used by the management.
b. Query 2: Create a query from the Patient Table using the Simple Query Wizard
i. Generate a billing statement of patients who owe more than $300
ii. Select the appropriate fields and the appropriate criteria.
iii. Run this query.
iv. 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?
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
