Access Project module 2

SC_AC19_2a_TheresaCobb_1.accdb

Home >Computer Science homework help >Access Project module 2

IfSuccessful_Status	GA_Status_Icon	SAM_Logo
true
false

ID	FirstName	LastName	AssignmentGUID	UserID
false	Theresa	Cobb	{A0CACF7A-F4B8-4F99-A144-F920D28E8AA7}	{A0CACF7A-F4B8-4F99-A144-F920D28E8AA7}

ID	FirstName	LastName	ProjectName	SubmissionNum	MaxScore	Score	EngineVersion

ID	StepNumber	Description	IfSuccessful	StepScore	StepMaxScore	ErrorText	ActionName	StepActionOrder

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

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
R10223	11004	¤ 100,000.00	¤ 75,000.00	¤ 500.00	¤ 171.00
R10334	11017	¤ 100,000.00	¤ 50,000.00	¤ 500.00	¤ 242.00
R11234	11010	¤ 200,000.00	¤ 10,000.00	¤ 1,000.00	¤ 212.00
R11345	11015	¤ 75,000.00	¤ 50,000.00	¤ 0.00	¤ 183.00
R11999	11032	¤ 100,000.00	¤ 100,000.00	¤ 1,000.00	¤ 198.00
R12345	11019	¤ 50,000.00	¤ 50,000.00	¤ 0.00	¤ 154.00
R12455	11029	¤ 100,000.00	¤ 50,000.00	¤ 500.00	¤ 207.00
R12666	11042	¤ 100,000.00	¤ 85,000.00	¤ 500.00	¤ 197.00
R12788	11033	¤ 100,000.00	¤ 75,000.00	¤ 500.00	¤ 204.00
R12900	11048	¤ 200,000.00	¤ 150,000.00	¤ 1,000.00	¤ 225.00
R13100	11038	¤ 100,000.00	¤ 45,000.00	¤ 0.00	¤ 213.00
R13111	11036	¤ 50,000.00	¤ 65,000.00	¤ 500.00	¤ 220.00
R13245	11041	¤ 200,000.00	¤ 100,000.00	¤ 1,000.00	¤ 181.00
R13456	11022	¤ 100,000.00	¤ 100,000.00	¤ 1,000.00	¤ 196.00
R14111	11045	¤ 50,000.00	¤ 50,000.00	¤ 500.00	¤ 179.00
R14222	11049	¤ 100,000.00	¤ 60,000.00	¤ 500.00	¤ 195.00
R16234	11012	¤ 100,000.00	¤ 50,000.00	¤ 500.00	¤ 195.00
R17111	11016	¤ 100,000.00	¤ 60,000.00	¤ 500.00	¤ 203.00
R17888	11027	¤ 50,000.00	¤ 50,000.00	¤ 500.00	¤ 168.00
R17890	11005	¤ 150,000.00	¤ 100,000.00	¤ 1,000.00	¤ 184.00
R18765	11007	¤ 100,000.00	¤ 50,000.00	¤ 500.00	¤ 156.00

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 Homeowners.Premium FROM Homeowners;

SELECT Customers.CustomerID, Customers.LastName, Customers.DateOfBirth FROM Customers ORDER BY Customers.LastName;

SELECT Customers.FirstName, Customers.LastName, Customers.City, Customers.State FROM Customers;

SELECT Customers.CustomerID, Customers.FirstName, Customers.LastName, Homeowners.PolicyNumber FROM Homeowners INNER JOIN Customers ON Homeowners.CustomerID = Customers.CustomerID;

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.CustomerID, Homeowners.Premium, Homeowners.PropertyDamage FROM Homeowners;

SELECT Renters.PolicyNumber, Renters.CustomerID, Renters.Liability, Renters.PersonalProperty FROM Renters;

SELECT Customers.CustomerID, Customers.FirstName, Customers.LastName, Customers.State FROM Customers;

SELECT Customers.CustomerID, Customers.FirstName, Customers.LastName, Customers.Address, Customers.City, Customers.State, Customers.PostalCode, Customers.DateOfBirth FROM Customers WHERE (((Customers.State)="PA"));

SELECT Customers.City, Customers.FirstName, Customers.LastName, Customers.State FROM Customers;

SELECT Customers.CustomerID, Customers.FirstName, Customers.LastName, Customers.State FROM Customers WHERE (((Customers.State)="FL"));

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

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

SELECT Customers.State FROM Customers ORDER BY Customers.State;