Access Module SAM Training

NP_AC16_2a_ThomasSimpson_2.accdb

Home >Computer Science homework help >Access Module SAM Training

IfSuccessful_Status	GA_Status_Icon	SAM_Logo
true
false

ID	FirstName	LastName	AssignmentGUID	UserID
false	Thomas	Simpson	{7C30865E-5C17-4DCC-A541-A98C96A3D113}	{7C30865E-5C17-4DCC-A541-A98C96A3D113}

ID	FirstName	LastName	ProjectName	SubmissionNum	MaxScore	Score	EngineVersion

ID	StepNumber	Description	IfSuccessful	StepScore	StepMaxScore	ErrorText	ActionName	StepActionOrder

BillingID	ClientID	TrainerID	StartDate	EndDate	Amount	Sessions

LocationID	LocationName	LocationOpened	Address	City	State	ZipCode	Phone
301	Elmwood	5/2/14	1400 Elmwood Ave.	Buffalo	NY	14216	716-555-1212
302	Riverside	6/8/15	733 Hertel Ave.	Buffalo	NY	14207	716-555-8315
308	Sheridan	1/5/15	5200 Sheridan Dr.	Buffalo	NY	14221	716-555-7621

TrainerID	FirstName	LastName	Specialty	Certification	College	HireDate	Interests
146	Jennifer	Young	Personal Trainer	ACE	University of Nebraska	3/19/14	nutrition, strength training, motivation
312	Randy	Lee	Strength Training	NSCA-CSCS	SUNY Buffalo	9/27/13	yoga, nutrition
454	Josh	Martinez	Sports Medicine	NATA	Saint Francis University	11/9/15	martial arts, strength training
585	Cam	Williams	Sports Medicine	NASM	SUNY Albany	6/10/14	nutrition, martial arts
612	Raj	Patel	Personal Trainer	NSCA-CPT	Florida State University	1/4/11	yoga, dance fit, nutrition
693	Sandy	Larson	Personal Trainer	PTA Global	Northwestern University	2/11/15	martial arts, nutrition, yoga
704	Melissa	Rogers	Strength Training	NSCA-CSCS	Cornell University	6/15/15	sports medicine, yoga
708	Carson	Garner	Personal Trainer	NSCA-CPT	San Diego State University	2/25/13	nutrition, yoga, swimming
709	Richard	Sanderson	Sports Medicine	NASM	University of Tennessee	6/1/12	strength training, swimming
774	Sally	Andrews	Personal Trainer	NSCA-CPT	SUNY Buffalo	4/12/14	nutrition, sports medicine, strength training

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;