Need Help With HomeWork Assignment

profileSimpdawg93
NP_AC16_1a_ThomasSimpson_2.accdb
Home>Computer Science homework help>Need Help With HomeWork Assignment
IfSuccessful_Status GA_Status_Icon SAM_Logo
true
false
ID FirstName LastName AssignmentGUID UserID
false Thomas Simpson {53B7D8FD-E6B7-4D46-8C9E-4D3815AD3C14} {53B7D8FD-E6B7-4D46-8C9E-4D3815AD3C14}
ID FirstName LastName ProjectName SubmissionNum MaxScore Score EngineVersion
ID StepNumber Description IfSuccessful StepScore StepMaxScore ErrorText ActionName StepActionOrder
EquipmentID Description Category
E142 Nordic Treadmill Cardio
E497 Sirius Rower Cardio
ID LocationName LocationOpened Address City State ZipCode Phone
TrainerID FirstName LastName Specialty Certification HireDate
146 Jennifer Young Personal Trainer ACE 3/19/14
312 Randy Lee Strength Training NSCA-CSCS 9/27/13
454 Josh Martinez Sports Medicine NATA 11/9/15
585 Cam Williams Sports Medicine NASM 6/10/14
612 Raj Patel Personal Trainer NSCA-CPT 1/4/11
693 Sandy Larson Personal Trainer PTA Global 2/11/15
704 Melissa Rogers Strength Training NSCA-CSCS 6/15/15
708 Carson Garner Personal Trainer NSCA-CPT 2/25/13
709 Richard Sanderson Sports Medicine NASM 6/1/12
SELECT DISTINCTROW * FROM tblTrainer;
SELECT [FirstName] & " " & [LastName] AS StudentName, [_GradingReport].ProjectName, "Submission #" & [SubmissionNum] AS SubmissionCt, [_GradingReport].Score, [_GradingReport].MaxScore, "Score is: " & [Score] & " out of " & [MaxScore] AS Grade, [_GradingReportSteps].[StepNumber] & ". " & [Description] AS Step, [_GradingReportSteps].[StepScore] & "/" & [_GradingReportSteps].[StepMaxScore] AS StepGrade, [_GradingReportSteps].ActionName, IIf([ifsuccessful]=True,Null,[ErrorText]) AS Feedback, [_GradingReportSteps].IfSuccessful, [_GradingIcons].GA_Status_Icon, [_GradingReportSteps].StepNumber, [_GradingReportSteps].StepActionOrder, [_GradingReportSteps].ID, [_GradingIcons].SAM_Logo, [_GradingReportSteps].Description, [_GradingReport].EngineVersion FROM _GradingReport, _GradingIcons INNER JOIN _GradingReportSteps ON [_GradingIcons].[IfSuccessful_Status] = [_GradingReportSteps].IfSuccessful;