Programming Making table queries in MS Access Excel Project

Instructions: Feel Better Now Physical Therapy Center has recently had its grand opening. The center offers variety of different therapies. Patients sign up for a session and they are assigned to a therapist for that session. The therapist determines the session length based on the patient’s needs at the time of the appointment. Most therapies can be done by any available therapist.

The center is using Excel for data keeping but they realized that the approach may become troublesome and inefficient in the near future. Therefore, they decided to use an intern to migrate their data from Excel to Access before it is too late.

Task 1. Import the Excel worksheet into Access as a table. Name the table as tblPhysicalTherapy.

Task 2. Using Make Table queries, normalize the tblPhysicalTherapy table. Make sure that each resulting table is in the third normal form.

Task 3. Assign a primary key to each table and create one-to-many relationships between the tables.

Task 4. Create a form with a sub-form that the center can utilize. Make sure that the form is professionally designed.

Task 5 (Bonus): Using a Make Table query, re-create the original tblPhysicalTherapy table from the normalized tables. Name this table as tblPhysicalTherapy2. Name your Make Table query as qryReCreate.

TherapyCode Description
40901 Biofeedback training by any modality
42240 Shoulder strapping
42507 Treatment of speech
42530 Knee strapping
42540 Ankle and/or foot strapping
45831 Extremity or trunk muscle testing
47010 Hot or cold pack application
47012 Mechanical traction
47014 Electrical stimulation
47014 Electrical stimulation
47016 Vasopneumatic devices
47018 Paraffin bath
47022 Massage
47022 Massage
47022 Massage
47022 Massage
47022 Massage
47026 Infrared
47032 Electrical stimulation
47033 Iontophoresis
47035 Ultrasound
47039 Unlisted modality
47039 Unlisted modality
47110 Therapeutic exercises
47112 Neuromuscular re-education
47113 Aquatic therapy with therapeutic exercises
47116 Gait training
47124 Whirlpool
47139 Unlisted therapeutic procedure
47140 Manual therapy techniques
47150 Group therapeutic procedure
47530 Dynamic activities to improve functional performance
47535 Self-care/home management training
47750 Physical performance test or measurement
47799 Unlisted physical medicine/rehabilitation service or procedure
48941 CMT of the spine
48960 Education and training for patient self-management
SessionNum SessionDate
50000
27 10/10/2022
28 10/11/2022
40 11/1/2022
29 10/11/2022
44
43
42
41
45
11/4/2022
11/1/2022
11/3/2022
11/1/2022
11/3/2022
30 10/12/2022
32 10/16/2022
39 10/21/2022
33 10/17/2022
34 10/17/2022
35 10/18/2022
36 10/18/2022
37 10/19/2022
38 10/19/2022
31 10/15/2022
PatientNum LastName
FirstName Address
City
State ZipCode
Stephen
941 Treemont
Oak Hills
TX
74081
$212.80
1016 Ehrmantraut Mike
2691 Westgrove St.
Delbert
TX
72381
$714.25
1020 Marino
1014 Odepaul
Andre
Ben
919 Horton Ave.
546 WCR 150 South
Georgetown TX
Munster
TX
72379
74093
$688.95
$525.00
1019 Culling
1018 Ziegler
1017 Short
1012 Houghland
1021 Wilson
Latisha
Werner
Tobey
Susan
Tammy
4238 East 71st St.
300 Erin Dr.
1928 10th Ave.
7841 Lake Side Dr.
424 October Blvd.
San Vista
Waterville
Munster
Munster
Waterville
TX
TX
TX
TX
TX
74071 $1,988.50
76658 $1,846.75
72512 $967.60
72380 $1,955.40
76658 $2,015.30
1013 Falls
Tierra
1018 Ziegler
Werner
1016 Ehrmantraut Mike
1017 Short
Tobey
44 Applewood Ave.
300 Erin Dr.
2691 Westgrove St.
1928 10th Ave.
Palm Rivers
Waterville
Delbert
Munster
TX
TX
TX
TX
72511 $1,000.35
76658 $1,846.75
72381 $714.25
72512 $967.60
1015 Venable
1010 Koehler
1019 Culling
1020 Marino
Isaiah
Robbie
Latisha
Andre
37 High School Road
119 West Bay Dr.
4238 East 71st St.
919 Horton Ave.
Waterville
TX
San Vista
TX
San Vista
TX
Georgetown TX
74183 $432.30
72510 $1,535.15
74071 $1,988.50
72379 $688.95
1021 Wilson
Tammy
424 October Blvd.
Waterville
TX
76658 $2,015.30
2691 Westgrove St.
Delbert
TX
72381
1011 King
1016 Ehrmantraut Mike
Balance
$714.25
LengthOfSession TherapistID TherapistLastName TherapistFirstName
45 JR085
Risk
Jonathan
30 AS648
Shields
Anthony
30 JR085
60 SW124
Risk
Wilder
Jonathan
Steven
45 BM273
45 BM273
60 AS648
30 AS648
60 SW124
McClain
McClain
Shields
Shields
Wilder
Bridgette
Bridgette
Anthony
Anthony
Steven
30 BM273
15 JR085
60 BM273
60 SN852
McClain
Risk
McClain
Nair
Bridgette
Jonathan
Bridgette
Saritha
45 BM273
30 SW124
75 SN852
30 BM273
McClain
Wilder
Nair
McClain
Bridgette
Steven
Saritha
Bridgette
60 AS648
Shields
Anthony
90 AS648
Shields
Anthony