microsoft access assignments

access_assignment_2_homework.accdb

Home >Computer Science homework help >microsoft access assignments

ID	FirstName	LastName	AssignmentGUID	UserID
false			{BEF4798F-FE94-4690-94B1-2B2EE8B14885}	{BEF4798F-FE94-4690-94B1-2B2EE8B14885}

ID	FirstName	LastName	ProjectName	SubmissionNum	MaxScore	Score

ID	StepNumber	Description	IfSuccessful	StepScore	StepMaxScore	ErrorText	ActionName	StepActionOrder

BillingID	PatientID	TherapistID	StartDate	EndDate	Amount	Sessions

TherapistID	LastName	FirstName	Specialty	Certification	College	HireDate
122	Martinez	Richard	Spinal disorders	MPT	University of Texas	5/31/09
302	Lachare	Shelley	Low-back pain	DPT	University of Florida	6/8/10
409	Reese	David	Spinal deformities	MPT	Saint Francis University	4/25/14
501	Steinley	Jacob	Post-surgical rehab	DPT	SUNY Albany	5/2/16
508	Roberts	Belinda	Running-related	DPT	Florida State University	1/5/15
542	McHarg	Laura	Headaches	MPT	Northwestern University	9/2/10
605	Schmidt	Missy	Low-back pain	DPT	University of California Berkeley	3/1/11
699	Lazari	Michael	Sports injuries	MPT	San Diego State University	6/8/10
700	Zachry	Fred	Sports injuries	PT	University of Tennessee	9/1/11
701	Christie	Jennifer	Strength and conditioning	PT	Florida State University	5/1/09
702	Gratin	James	Running-related	PT	University of Nebraska	6/1/12

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;

SELECT Therapist.FirstName, Therapist.LastName, Therapist.Specialty FROM Therapist;