Access recreate assignment

profilewaterdawg77
NP_AC16_2b_MirielleWhite_1.accdb
Home>Business & Finance homework help>Operations Management homework help>Access recreate assignment
IfSuccessful_Status GA_Status_Icon SAM_Logo
true
false
ID FirstName LastName AssignmentGUID UserID
false Mirielle White {23B9B709-361D-4386-9CE0-A2E746BDA2A9} {23B9B709-361D-4386-9CE0-A2E746BDA2A9}
ID FirstName LastName ProjectName SubmissionNum MaxScore Score EngineVersion
ID StepNumber Description IfSuccessful StepScore StepMaxScore ErrorText ActionName StepActionOrder
BillingID MemberID TrainerID StartDate EndDate Amount Sessions
LocationID LocationName LocationOpened Address City State ZipCode Phone
301 Lake 5/2/14 1005 Lake Dr. Grand Rapids MI 49504 616-555-1212
302 Riverfront 6/8/15 270 Ann St. NW Grand Rapids MI 49504 616-555-8315
308 Fulton 1/5/15 35 Fulton St. W. Grand Rapids MI 49503 616-555-7621
TrainerID FirstName LastName Specialty Certification College HireDate Interests
146 Joshua Bakker Personal Trainer ACE University of Nebraska 3/19/14 nutrition, strength training, motivation
312 Tom Fowler Strength Training NSCA-CSCS SUNY Buffalo 9/27/13 yoga, nutrition
454 Sarah Collings Sports Medicine NATA Saint Francis University 11/9/15 martial arts, strength training
585 Chris Manz Sports Medicine NASM SUNY Albany 6/10/14 nutrition, martial arts
612 Andrea Hayward Personal Trainer NSCA-CPT Florida State University 1/4/11 yoga, dance fit, nutrition
693 Jay Patel Personal Trainer PTA Global Northwestern University 2/11/15 martial arts, nutrition, yoga
704 Dawn Purcell Strength Training NSCA-CSCS Cornell University 6/15/15 sports medicine, yoga
708 Kathy Pearce Personal Trainer NSCA-CPT San Diego State University 2/25/13 nutrition, yoga, swimming
709 Art Walters Sports Medicine NASM University of Tennessee 6/1/12 strength training, swimming
774 Angela Stevens 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;