ensight healthcare consultants

SC_AC19_1a_SarahGodwin_2.accdb

Home >Computer Science homework help >ensight healthcare consultants

IfSuccessful_Status	GA_Status_Icon	SAM_Logo
true
false

ID	FirstName	LastName	AssignmentGUID	UserID
false	Sarah	Godwin	{8CC619F6-9A55-4BCE-8D6D-1C1862359B59}	{8CC619F6-9A55-4BCE-8D6D-1C1862359B59}

ID	FirstName	LastName	ProjectName	SubmissionNum	MaxScore	Score	EngineVersion

ID	StepNumber	Description	IfSuccessful	StepScore	StepMaxScore	ErrorText	ActionName	StepActionOrder

CustomerID	First	Last	Address	City	State	PostalCode
11001	Elian	Velasquez	88 Pin Oak Ave.	Chester	PA	19013
11002	Joaquin	Howe	598 West Ramblewood Dr.	Harrison	MI	48045
11003	Heaven	Barton	31 Gartner Court	North Olmstead	OH	44070
11004	Elias	Stone	350 Vermont Ave.	Egg Harbor	NJ	08234
11005	Melany	Harrison	8388 Sherman Court	Somerset	NJ	08873
11006	Anne	Rich	84 Beechwood St.	Windsor	CT	06095
11007	Gabrielle	Drake	99 S. Windsor Ave.	Lansdale	PA	19446
11008	Malik	Kelley	7409 W. Glendale St.	Bristol	CT	06010
11009	Darren	Savage	883 Rockland Dr.	Romeoville	IL	60446
11010	Xavier	Wilcox	50 Oak Meadow St.	Lebanon	PA	17042
11011	Caiden	Vega	21 Riverside Dr.	Warminster	PA	18974
11012	Julia	Ellison	8730 Swanson Court	Jacksonville Beach	FL	32250
11013	Beckett	Valencia	68 Orange St.	Flowery Branch	GA	30542
11014	Cadence	Pittmas	7199 Locust Court	Rochester	NY	14606
11015	Nevaeh	Huber	811 North Winding Way	West Lafayette	IN	47906
11016	Karma	Wood	512 Sleepy Hollow Ave.	Eastpointe	MI	48021
11017	Remington	Wilkerson	9169 Ramblewood Dr.	Alabaster	AL	35007
11018	Madalyn	Rush	7038 North Lane	Lincoln Park	MI	48146
11019	Jazlyn	Brennan	9 Studebaker St.	Waxhaw	NC	28173
11020	Sherlyn	Cowan	74 East Primrose Lane	Kunkletown	PA	18056
11021	Derick	Clarke	78 Old York St.	Kearny	NJ	07032
11022	Kamila	Juarez	281 Iriquois St.	Shrewsbury	MA	01545
11023	Edith	Kelly	348 South Foxrun St.	Bluffton	SC	29910
11024	Shelby	Hancock	35 South Canal St.	Niles	MI	49120
11025	Iyana	Joseph	345 Magee Ave.	Media	PA	19063
11026	Mareli	Brooks	9949 Madison Ave	Forest Hills	NY	11375
11027	Taylor	Shea	8824 North Thomas Ave.	Bridgewater	NJ	08807
11028	Natasha	Mcdonald	668 Charles Street	Muskegon	MI	49441
11029	Selena	Francis	9607 Charles Ave.	Romulus	MI	48174
11030	Clayton	Chavez	537 E. Young St.	Allentown	PA	18102
11031	Asia	Walters	7394 Proctor Dr.	Andover	MA	01810
11032	Jax	Levy	33 E. Elmwood Ave.	Deltona	FL	32725
11033	Arjun	Andersen	599 Homestead St.	Seldon	NY	11784
11034	Trevin	Zavala	7176 Atlantic Rd.	Key West	FL	33040
11035	Aniya	Hester	164 Cottage Ave.	Kingston	NY	12401
11036	Jazlene	Clarke	3 Fairway Ave.	Augusta	GA	30906
11037	Jovanny	Thomas	892 Wrangler St.	Seldon	NY	11784
11038	Chloe	Morrison	9540 Airport Rd.	Maspeth	NY	11378
11039	Izayah	Olson	6 Wentworth Dr.	Lafayette	IN	47905
11040	Talia	Rodgers	845 Hudson Ave.	St. Joseph	MI	49085
11041	Graham	Preston	8526 Amherst Dr.	Hackensack	NJ	07601
11042	Leah	Stuart	435 Westport Ave.	Middleburg	FL	32068
11043	Oliver	Garrison	7932 N. Primrose Dr.	Manassas	VA	20109
11044	Micah	Huffman	7859 Lees Creek Dr.	Panama City	FL	32404
11045	Rachael	Floyd	14 1st Ave.	Lorain	OH	44052
11046	Mario	Ponce	84 Pennsylvania Dr.	New Castle	PA	16101
11047	Mollie	Bowen	24 3rd Lane	Hopewell	VA	23860
11048	Jayleen	Mccormick	8862 S. Poplar Ave.	Winter Garden	FL	34787
11049	Meadow	Levey	521 Second Street	Boca Raton	FL	33428
11050	Willard	Wright	561 Nickerson Street	Hudson	OH	44236

CustomerID	FirstName	LastName	Address	City	State	PostalCode	DateOfBirth
11001	Elian	Velasquez	88 Pin Oak Ave.	Chester	PA	19013	12/31/48
11004	Elias	Stone	350 Vermont Ave.	Egg Harbor	NJ	08234	9/17/47
11005	Melany	Harrison	8388 Sherman Court	Egg Harbor	NJ	08873	4/10/72
11007	Gabrielle	Drake	99 S. Windsor Ave.	Lebanon	PA	19446	2/13/96
11010	Xavier	Wilcox	50 Oak Meadow St.	Lebanon	PA	17042	7/13/95
11011	Caiden	Vega	21 Riverside Dr.	Allentown	PA	18974	9/8/54
11014	Cadence	Pittmas	7199 Locust Court	Rochester	NY	14606	4/11/73
11020	Sherlyn	Cowan	74 East Primrose Lane	Kunkletown	PA	18056	2/5/66
11021	Derick	Clarke	78 Old York St.	Kearny	NJ	07032	2/14/81
11025	Iyana	Joseph	345 Magee Ave.	Media	PA	19063	10/21/65
11026	Mareli	Brooks	9949 Madison Ave	Kingston	NY	11375	1/15/69
11027	Taylor	Shea	8824 North Thomas Ave.	Bridgewater	NJ	08807	9/15/46
11030	Clayton	Chavez	537 E. Young St.	Allentown	PA	18102	5/28/76
11033	Arjun	Andersen	599 Homestead St.	Seldon	NY	11784	4/4/91
11035	Aniya	Hester	164 Cottage Ave.	Kingston	NY	12401	1/31/79
11037	Jovanny	Thomas	892 Wrangler St.	Seldon	NY	11784	11/12/55
11038	Chloe	Morrison	9540 Airport Rd.	Maspeth	NY	11378	10/12/94
11041	Graham	Preston	8526 Amherst Dr.	Hackensack	NJ	07601	8/2/62
11043	Oliver	Garrison	7932 N. Primrose Dr.	Manassas	VA	20109	12/2/88
11046	Mario	Ponce	84 Pennsylvania Dr.	New Castle	PA	16101	5/6/78
11047	Mollie	Bowen	24 3rd Lane	Manassas	VA	23860	4/1/66

CustomerID	PersonalProperty	PolicyNumber
11004	¤ 75,000.00	R10223

PolicyNumber	CustomerID	Premium	Coverage
U10001	11008	¤ 474.00	¤ 2,000,000.00
U11011	11014	¤ 383.00	¤ 1,000,000.00
U12045	11011	¤ 396.00	¤ 1,000,000.00
U12137	11026	¤ 1,578.00	¤ 10,000,000.00
U12265	11030	¤ 999.00	¤ 10,000,000.00
U13575	11035	¤ 762.00	¤ 5,000,000.00
U13668	11043	¤ 375.00	¤ 1,000,000.00
U13770	11037	¤ 674.00	¤ 1,000,000.00
U14111	11047	¤ 705.00	¤ 1,000,000.00

SELECT DISTINCTROW * FROM Umbrella;

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;