access_assignment_3_homework.accdb
| ID | FirstName | LastName | AssignmentGUID | UserID |
| false | Yuchi | Yim | {BE3D3B75-CA3D-4AC7-A0BA-1BE75EBCF6D8} | {BE3D3B75-CA3D-4AC7-A0BA-1BE75EBCF6D8} |
| ID | FirstName | LastName | ProjectName | SubmissionNum | MaxScore | Score |
| ID | StepNumber | Description | IfSuccessful | StepScore | StepMaxScore | ErrorText | ActionName | StepActionOrder |
| BillingID | PatientID | TherapistID | StartDate | EndDate | Sessions | Amount |
| A80342 | A10486 | 605 | 3/7/16 | 3/28/16 | 10 | ¤ 1,000.00 |
| A80399 | A12565 | 302 | 3/16/16 | 4/27/16 | 6 | ¤ 600.00 |
| A80400 | A12565 | 542 | 5/3/16 | 5/31/16 | 9 | ¤ 950.00 |
| A80401 | A12565 | 542 | 6/1/16 | 6/3/16 | 2 | ¤ 50.00 |
| A80565 | A10526 | 122 | 2/1/16 | 2/17/16 | 6 | ¤ 600.00 |
| A80610 | A15671 | 409 | 4/1/16 | 5/17/16 | 12 | ¤ 1,200.00 |
| A80643 | A10235 | 501 | 2/2/16 | 2/18/16 | 6 | ¤ 800.00 |
| A80675 | A10845 | 508 | 3/3/16 | 5/19/16 | 12 | ¤ 1,550.00 |
| A84575 | A12865 | 409 | 3/9/16 | 3/21/16 | 6 | ¤ 750.00 |
| A84975 | A12465 | 699 | 3/22/16 | 3/24/16 | 2 | ¤ 150.00 |
| B80345 | B15678 | 605 | 3/28/16 | 4/18/16 | 10 | ¤ 1,000.00 |
| B80671 | B18536 | 700 | 3/1/16 | 3/2/16 | 2 | ¤ 250.00 |
| B80699 | B19356 | 701 | 3/8/16 | 3/29/16 | 4 | ¤ 450.00 |
| B85654 | B15264 | 122 | 3/2/16 | 3/17/16 | 12 | ¤ 1,550.00 |
| LocationID | Address | City | State | ZipCode | Phone |
| A | 59029 E. Market St | Akron | OH | 44308 | 330-555-1001 |
| B | 809 Medina Rd South | Akron | OH | 44310 | 330-555-0824 |
| C | 65830 Leland Ave | Akron | OH | 44301 | 330-555-4014 |
| PatientID | FirstName | LastName | Address | City | State | Zip | Phone | BirthDate | Gender |
| A10026 | Al | Pandola | 45 South Main St | Akron | OH | 44307 | 330-555-4815 | 12/15/61 | M |
| A10235 | Robert | Layna | 48 Mettle Cove | Akron | OH | 44308 | 330-555-1400 | 6/15/82 | M |
| A10486 | Richard | Farmer | 550 Riverside Dr | Akron | OH | 44308 | 330-555-0425 | 10/31/86 | M |
| A10526 | Jenny | Champion | 34 Duck Lake | Akron | OH | 44305 | 330-555-8744 | 2/25/75 | F |
| A10845 | Angel | Ramirez | 583 South 1st St | Akron | OH | 44305 | 330-555-1982 | 9/1/70 | M |
| A12465 | Helen | Quincy | 1907 Montalba Rd | Akron | OH | 44308 | 330-555-8765 | 6/14/68 | F |
| A12565 | Glenda | Campbell | 3 River Road | Akron | OH | 44308 | 330-555-0100 | 4/15/68 | F |
| A12865 | Simone | Quinn | 98 South Hwy 8 | Akron | OH | 44305 | 330-555-0816 | 5/4/76 | F |
| A15671 | Kelly | Balarbar | 568 Hwy 5 | Akron | OH | 44308 | 330-555-8761 | 1/5/69 | F |
| B10585 | Maria | Green | 12 Malabar | Akron | OH | 44306 | 330-555-9855 | 2/25/65 | F |
| B15264 | Lexie | Garcia | 4 Lakeside Dr | Akron | OH | 44305 | 330-555-7498 | 8/4/55 | F |
| B15678 | James | Quincy | 1907 Montalba Rd | Akron | OH | 44308 | 330-555-8765 | 7/8/65 | M |
| B18536 | Montgomery | Stewart | 5 Ladle Lane | Akron | OH | 44302 | 330-555-9763 | 10/28/82 | M |
| B19356 | Linda | Francis | 235 Hwy 5 | Akron | OH | 44308 | 330-555-6246 | 7/4/85 | F |
| TherapistID | LocationID | FirstName | LastName | Specialty | Certfication | HireDate | Minors |
| 122 | A | Richard | Martinez | Spinal disorders | MPT | 5/31/09 | false |
| 302 | A | Shelley | Lachare | Low-back pain | DPT | 6/8/10 | false |
| 409 | A | David | Reese | Spinal deformities | MPT | 4/25/14 | true |
| 501 | A | Jacob | Steinley | Post-surgical rehab | DPT | 5/2/16 | false |
| 508 | A | Belinda | Roberts | Running-related | DPT | 1/5/15 | false |
| 542 | A | Laura | McHarg | Headaches | MPT | 9/2/10 | true |
| 605 | A | Missy | Schmidt | Low-back pain | DPT | 3/1/11 | false |
| 699 | A | Michael | Lazari | Sports injuries | MPT | 6/8/10 | false |
| 700 | B | Fred | Zachry | Sports injuries | PT | 9/1/11 | true |
| 701 | B | Jennifer | Christie | Strength and conditioning | PT | 5/1/09 | false |
| 702 | A | James | Gratin | Running-related | PT | 6/1/12 | false |
SELECT [FirstName] & " " & [LastName] AS StudentName, [_GradingReport].ProjectName, "Submission #" & [SubmissionNum] AS SubmissionCt, "Score is " & [Score] & " out of " & [MaxScore] AS Grade, [_GradingReportSteps].[StepNumber] & ". " & [Description] AS Step, GradingSummaryReportGrade.AllowPartialGrading, GradingSummaryReportGrade.Action_CT, GradingSummaryReportGrade.ActionCorrect, roundScore([AllowPartialGrading],[GradingSummaryReportGrade].[StepMaxScore],[ActionCorrect],[Action_CT]) & "/" & [GradingSummaryReportGrade].[StepMaxScore] AS StepGrade, [_GradingReportSteps].ActionName, IIf([ifsuccessful]=True,Null,[ErrorText]) AS Feedback, [_GradingReportSteps].IfSuccessful, [_GradingReportSteps].StepNumber, [_GradingReportSteps].StepActionOrder, [_GradingReportSteps].ID, [_GradingReportSteps].Description
FROM _GradingReport, _GradingReportSteps INNER JOIN GradingSummaryReportGrade ON [_GradingReportSteps].StepNumber = GradingSummaryReportGrade.StepNumber;
SELECT [_GradingReportSteps].StepNumber, [_GradingReportSteps].StepScore AS AllowPartialGrading, [_GradingReportSteps].StepMaxScore, Count([_GradingReportSteps].ID) AS Action_CT, Sum(IIf([IfSuccessful]=-1,1,0)) AS ActionCorrect, Sum(IIf([IfSuccessful]=0,1,0)) AS ActionWrong
FROM _GradingReportSteps
GROUP BY [_GradingReportSteps].StepNumber, [_GradingReportSteps].StepScore, [_GradingReportSteps].StepMaxScore;
d9f2v6d7v1
