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.

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

4. In Data sheet View, add
the following data to the Patient Table.

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.