Sam Access 2016

NP_AC16_CS1-4a_JasonYeung_1.accdb

Home >Business & Finance homework help >Sam Access 2016

IfSuccessful_Status	GA_Status_Icon	SAM_Logo
true
false

ID	FirstName	LastName	AssignmentGUID	UserID
false	Jason	Yeung	{1E97B79B-34ED-45C0-A52A-FBBD4E835BFF}	{1E97B79B-34ED-45C0-A52A-FBBD4E835BFF}

ID	FirstName	LastName	ProjectName	SubmissionNum	MaxScore	Score	EngineVersion

ID	StepNumber	Description	IfSuccessful	StepScore	StepMaxScore	ErrorText	ActionName	StepActionOrder

AthleteID	LocationID	FirstName	LastName	Address	City	State	Zip	LevelID	Gender	BirthDate

CoachID	CoachFirst	CoachLast	BGCExp	CertificationExp	LevelID
901021	Josh	Culligan	9/30/20	12/31/19	COLL
901263	Richard	Elliot	1/31/19	12/31/20	CJR
901366	Pamela	Reynolds	11/30/19	12/31/19	BEG3
901486	David	Hamm	1/31/20	12/31/19	BEG3
901563	Ashley	Bollinger	5/31/19	12/31/20	A1
901574	Matthew	Lambert	1/31/20	12/31/19	CSR
901575	Elise	Lew	8/31/20	12/31/20	A2
901742	Jim	Gibson	11/30/20	12/31/20	BEG2
901748	Andrew	Mendola	9/30/19	12/31/20	A3
901880	Anne	Harding	10/31/19	12/31/19	CINT
901900	Angela	Pearson	12/31/20	12/31/20	BEG2
901901	Nora	Keller	12/31/20	12/31/20	BEG2

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;