Access Project

SC_AC19_3a_TheresaCobb_11.accdb

Home >Computer Science homework help >Java homework help >Access Project

IfSuccessful_Status	GA_Status_Icon	SAM_Logo
true
false

ID	FirstName	LastName	AssignmentGUID	UserID
false	Theresa	Cobb	{6C8CE23C-756B-4159-A186-F7DFC15FFE7A}	{6C8CE23C-756B-4159-A186-F7DFC15FFE7A}

ID	FirstName	LastName	ProjectName	SubmissionNum	MaxScore	Score	EngineVersion

ID	StepNumber	Description	IfSuccessful	StepScore	StepMaxScore	ErrorText	ActionName	StepActionOrder

ClaimID	CustomerID	PolicyNumber	ClaimAmount	ClaimApproved	Paid
C0001	11018	R12902	20000	true	¤ 0.00
C0002	11020	H10234	15000	true	¤ 450.00
C0003	11023	H10566	35000	false	¤ 1,200.00
C0004	11031	H12000	12500	false	¤ 1,452.00

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

PolicyNumber	CustomerID	Liability	PropertyDamage	Premium	Deductible
H10222	11018	¤ 100,000.00	¤ 300,000.00	¤ 1,655.00	¤ 2,000.00
H10234	11020	¤ 300,000.00	¤ 500,000.00	¤ 1,427.00	¤ 2,500.00
H10455	11021	¤ 100,000.00	¤ 400,000.00	¤ 1,190.00	¤ 1,500.00
H10566	11023	¤ 100,000.00	¤ 200,000.00	¤ 1,149.00	¤ 1,500.00
H11223	11008	¤ 500,000.00	¤ 600,000.00	¤ 2,301.00	¤ 1,000.00
H11233	11002	¤ 500,000.00	¤ 500,000.00	¤ 1,937.00	¤ 2,500.00
H11455	11014	¤ 300,000.00	¤ 600,000.00	¤ 2,139.00	¤ 5,000.00
H11789	11024	¤ 100,000.00	¤ 300,000.00	¤ 1,214.00	¤ 2,000.00
H11889	11003	¤ 300,000.00	¤ 550,000.00	¤ 1,424.00	¤ 5,000.00
H12000	11031	¤ 100,000.00	¤ 200,000.00	¤ 978.00	¤ 2,500.00
H12334	11009	¤ 10,000.00	¤ 400,000.00	¤ 1,700.00	¤ 2,500.00
H12345	11006	¤ 300,000.00	¤ 500,000.00	¤ 1,865.00	¤ 1,000.00
H12445	11011	¤ 300,000.00	¤ 600,000.00	¤ 2,714.00	¤ 5,000.00
H12456	11001	¤ 300,000.00	¤ 600,000.00	¤ 3,205.00	¤ 1,000.00
H13245	11013	¤ 300,000.00	¤ 400,000.00	¤ 1,863.00	¤ 1,000.00
H13456	11025	¤ 300,000.00	¤ 750,000.00	¤ 2,829.00	¤ 1,000.00
H13567	11026	¤ 500,000.00	¤ 1,000,000.00	¤ 3,305.00	¤ 5,000.00
H13567A	11026	¤ 100,000.00	¤ 250,000.00	¤ 1,905.00	¤ 2,500.00
H13678	11028	¤ 150,000.00	¤ 395,000.00	¤ 975.00	¤ 5,000.00
H13789	11030	¤ 350,000.00	¤ 650,000.00	¤ 1,299.00	¤ 2,500.00
H14001	11034	¤ 75,000.00	¤ 150,000.00	¤ 1,834.00	¤ 1,000.00
H14011	11035	¤ 500,000.00	¤ 950,000.00	¤ 1,534.00	¤ 2,500.00
H14011A	11035	¤ 100,000.00	¤ 275,000.00	¤ 1,125.00	¤ 2,500.00
H14123	11037	¤ 250,000.00	¤ 600,000.00	¤ 2,139.00	¤ 1,000.00
H14123A	11037	¤ 100,000.00	¤ 3,000,000.00	¤ 1,145.00	¤ 1,000.00
H14354	11039	¤ 100,000.00	¤ 275,000.00	¤ 983.00	¤ 1,000.00
H14454	11040	¤ 100,000.00	¤ 350,000.00	¤ 914.00	¤ 1,000.00
H14789	11043	¤ 300,000.00	¤ 675,000.00	¤ 946.00	¤ 2,500.00
H15012	11044	¤ 300,000.00	¤ 495,000.00	¤ 3,003.00	¤ 5,000.00
H15023	11046	¤ 100,000.00	¤ 295,000.00	¤ 1,413.00	¤ 1,500.00
H15234	11047	¤ 500,000.00	¤ 875,000.00	¤ 1,053.00	¤ 5,000.00
H15234A	11047	¤ 100,000.00	¤ 150,000.00	¤ 895.00	¤ 1,000.00
H15345	11050	¤ 200,000.00	¤ 450,000.00	¤ 819.00	¤ 5,000.00

CustomerID	FirstName	LastName	Address	City	State	PostalCode	DateOfBirth
11001	Elian	Velasquez	88 Pin Oak Ave.	Chester	PA	19013	1948-12-31
11004	Elias	Stone	350 Vermont Ave.	Egg Harbor	NJ	08234	1947-09-17
11005	Melany	Harrison	8388 Sherman Court	Egg Harbor	NJ	08873	1972-04-10
11007	Gabrielle	Drake	99 S. Windsor Ave.	Lebanon	PA	19446	1996-02-13
11010	Xavier	Wilcox	50 Oak Meadow St.	Lebanon	PA	17042	1995-07-13
11011	Caiden	Vega	21 Riverside Dr.	Allentown	PA	18974	1954-09-08
11014	Cadence	Pittmas	7199 Locust Court	Rochester	NY	14606	1973-04-11
11020	Sherlyn	Cowan	74 East Primrose Lane	Kunkletown	PA	18056	1966-02-05
11021	Derick	Clarke	78 Old York St.	Kearny	NJ	07032	1981-02-14
11025	Iyana	Joseph	345 Magee Ave.	Media	PA	19063	1965-10-21
11026	Mareli	Brooks	9949 Madison Ave	Kingston	NY	11375	1969-01-15
11027	Taylor	Shea	8824 North Thomas Ave.	Bridgewater	NJ	08807	1946-09-15
11030	Clayton	Chavez	537 E. Young St.	Allentown	PA	18102	1976-05-28
11033	Arjun	Andersen	599 Homestead St.	Seldon	NY	11784	1991-04-04
11035	Aniya	Hester	164 Cottage Ave.	Kingston	NY	12401	1979-01-31
11037	Jovanny	Thomas	892 Wrangler St.	Seldon	NY	11784	1955-11-12
11038	Chloe	Morrison	9540 Airport Rd.	Maspeth	NY	11378	1994-10-12
11041	Graham	Preston	8526 Amherst Dr.	Hackensack	NJ	07601	1962-08-02
11043	Oliver	Garrison	7932 N. Primrose Dr.	Manassas	VA	20109	1988-12-02
11046	Mario	Ponce	84 Pennsylvania Dr.	New Castle	PA	16101	1978-05-06
11047	Mollie	Bowen	24 3rd Lane	Manassas	VA	23860	1966-04-01

PolicyNumber	CustomerID	Liability	PersonalProperty	Deductible	Premium	TotalCoverage
R10223	11004	¤ 100,000.00	¤ 75,000.00	¤ 500.00	¤ 171.00	¤ 175,000.00
R10334	11017	¤ 100,000.00	¤ 50,000.00	¤ 500.00	¤ 242.00	¤ 150,000.00
R11234	11010	¤ 200,000.00	¤ 10,000.00	¤ 1,000.00	¤ 212.00	¤ 210,000.00
R11345	11015	¤ 75,000.00	¤ 50,000.00	¤ 0.00	¤ 183.00	¤ 125,000.00
R11999	11032	¤ 100,000.00	¤ 100,000.00	¤ 1,000.00	¤ 198.00	¤ 200,000.00
R12160	11029	¤ 200,000.00	¤ 100,000.00	¤ 1,000.00	¤ 325.00	¤ 300,000.00
R12345	11019	¤ 50,000.00	¤ 50,000.00	¤ 0.00	¤ 154.00	¤ 100,000.00
R12455	11029	¤ 100,000.00	¤ 50,000.00	¤ 500.00	¤ 207.00	¤ 150,000.00
R12666	11042	¤ 100,000.00	¤ 85,000.00	¤ 500.00	¤ 197.00	¤ 185,000.00
R12788	11033	¤ 100,000.00	¤ 75,000.00	¤ 500.00	¤ 204.00	¤ 175,000.00
R12900	11048	¤ 200,000.00	¤ 150,000.00	¤ 1,000.00	¤ 225.00	¤ 350,000.00
R12902	11018	¤ 100,000.00	¤ 50,000.00	¤ 500.00	¤ 189.00	¤ 150,000.00
R13010	11010	¤ 100,000.00	¤ 75,000.00	¤ 500.00	¤ 236.00	¤ 175,000.00
R13100	11038	¤ 100,000.00	¤ 45,000.00	¤ 0.00	¤ 213.00	¤ 145,000.00
R13111	11036	¤ 50,000.00	¤ 65,000.00	¤ 500.00	¤ 220.00	¤ 115,000.00
R13122	11015	¤ 75,000.00	¤ 50,000.00	¤ 0.00	¤ 183.00	¤ 125,000.00
R13245	11041	¤ 200,000.00	¤ 100,000.00	¤ 1,000.00	¤ 181.00	¤ 300,000.00
R13456	11022	¤ 100,000.00	¤ 100,000.00	¤ 1,000.00	¤ 196.00	¤ 200,000.00
R14111	11045	¤ 50,000.00	¤ 50,000.00	¤ 500.00	¤ 179.00	¤ 100,000.00
R14222	11049	¤ 100,000.00	¤ 60,000.00	¤ 500.00	¤ 195.00	¤ 160,000.00
R16234	11012	¤ 100,000.00	¤ 50,000.00	¤ 500.00	¤ 195.00	¤ 150,000.00
R17111	11016	¤ 100,000.00	¤ 60,000.00	¤ 500.00	¤ 203.00	¤ 160,000.00
R17888	11027	¤ 50,000.00	¤ 50,000.00	¤ 500.00	¤ 168.00	¤ 100,000.00
R17890	11005	¤ 150,000.00	¤ 100,000.00	¤ 1,000.00	¤ 184.00	¤ 250,000.00
R18765	11007	¤ 100,000.00	¤ 50,000.00	¤ 500.00	¤ 156.00	¤ 150,000.00

PolicyNumber	CustomerID	Premium	Coverage
U10001	11008	¤ 474.00	¤ 2,000,000.00
U10002	11010	¤ 190.00	¤ 1,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
U20011	11005	¤ 215.00	¤ 1,000,000.00
U20771	11048	¤ 315.00	¤ 2,000,000.00
U21145	11022	¤ 226.00	¤ 1,000,000.00
U22138	11041	¤ 278.00	¤ 2,000,000.00
U22269	11042	¤ 301.00	¤ 2,000,000.00

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;

SELECT Homeowners.PolicyNumber, Homeowners.Liability, Homeowners.PropertyDamage FROM Homeowners;