Executive Solution Overview
submitted the wrong assignment **files (1)** – ## HIMS645ASS5.docx **## HIMS645ASS5.docx** **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 fa…
Instant Solution Download
$6.99Immediate access to the full model answer, formatted citations, and rubric breakdown.
Need a Fresh Custom Paper?
Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →Assignment Prompt & Instructions
submitted the wrong assignment
**files (1)**
– ## HIMS645ASS5.docx
**## HIMS645ASS5.docx**
**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?
Your APA formatted assignment comprising 2-4, double-spaced, typed in 12-point Times New Roman (or 11- point Calibri) excluding the Cover and Reference pages should be submitted by Tuesday mid-night. 2 credible sources should support your conclusions on queries. Follow APA 7
**## HIMS645ASS5.docx**
**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?
Your APA formatted assignment comprising 2-4, double-spaced, typed in 12-point Times New Roman (or 11- point Calibri) excluding the Cover and Reference pages should be submitted by Tuesday mid-night. 2 credible sources should support your conclusions on queries. Follow APA 7
Leave a Reply