CSC 100 Course (Intro to Computers)A college courseAssignment is based on using "Microsoft Access"All the instructions are given in the file
Sheet1 PolicyNumberCustomerIDPremiumCoverage U20011110052151,000,000 U21145110222261,000,000 U22138110412782,000,000 U22269110423012,000,000 U20771110483152,000,000 IfSuccessful_StatusGA_Status_IconSAM_Logo true false IDFirstNameLastNameAssignmentGUIDUserID falseJe'KolbyWorthy{148B930A-6349-4AA5-A071-BC07771F77B9}{148B930A-6349-4AA5-A071-BC07771F77B9} IDFirstNameLastNameProjectNameSubmissionNumMaxScoreScoreEngineVersion IDStepNumberDescriptionIfSuccessfulStepScoreStepMaxScoreErrorTextActionNameStepActionOrder CustomerIDFirstNameLastNameAddressCityStatePostalCodeDateOfBirth 11001ElianVelasquez88 Pin Oak Ave.ChesterPA1901312/31/48 11002JoaquinHowe598 West Ramblewood Dr.HarrisonMI480458/9/45 11003HeavenBarton31 Gartner CourtNorth OlmsteadOH440703/19/65 11004EliasStone350 Vermont Ave.Egg HarborNJ082349/17/47 11005MelanyHarrison8388 Sherman CourtSomersetNJ088734/10/72 11006AnneRich84 Beechwood St.WindsorCT060951/2/74 11007GabrielleDrake99 S. Windsor Ave.LansdalePA194462/13/96 11008MalikKelley7409 W. Glendale St.BristolCT060105/27/80 11009DarrenSavage883 Rockland Dr.RomeovilleIL604465/3/76 11010XavierWilcox50 Oak Meadow St.LebanonPA170427/13/95 11011CaidenVega21 Riverside Dr.WarminsterPA189749/8/54 11012JuliaEllison8730 Swanson CourtJacksonville BeachFL3225010/31/39 11013BeckettValencia68 Orange St.Flowery BranchGA305422/26/59 11014CadencePittmas7199 Locust CourtRochesterNY146064/11/73 11015NevaehHuber811 North Winding WayWest LafayetteIN479069/9/50 11016KarmaWood512 Sleepy Hollow Ave.EastpointeMI480216/5/90 11017RemingtonWilkerson9169 Ramblewood Dr.AlabasterAL350074/29/96 11018MadalynRush7038 North LaneLincoln ParkMI481465/26/38 11019JazlynBrennan9 Studebaker St.WaxhawNC281733/30/95 11020SherlynCowan74 East Primrose LaneKunkletownPA180562/5/66 11021DerickClarke78 Old York St.KearnyNJ070322/14/81 11022KamilaJuarez281 Iriquois St.ShrewsburyMA015453/2/97 11023EdithKelly348 South Foxrun St.BlufftonSC2991011/9/41 11024ShelbyHancock35 South Canal St.NilesMI4912012/12/59 11025IyanaJoseph345 Magee Ave.MediaPA1906310/21/65 11026MareliBrooks9949 Madison AveForest HillsNY113751/15/69 11027TaylorShea8824 North Thomas Ave.BridgewaterNJ088079/15/46 11028NatashaMcdonald668 Charles StreetMuskegonMI494413/19/43 11029SelenaFrancis9607 Charles Ave.RomulusMI481744/5/94 11030ClaytonChavez537 E. Young St.AllentownPA181025/28/76 11031AsiaWalters7394 Proctor Dr.AndoverMA018106/1/68 11032JaxLevy33 E. Elmwood Ave.DeltonaFL327256/14/44 11033ArjunAndersen599 Homestead St.SeldonNY117844/4/91 11034TrevinZavala7176 Atlantic Rd.Key West FL330406/7/87 11035AniyaHester164 Cottage Ave.KingstonNY124011/31/79 11036JazleneClarke3 Fairway Ave.AugustaGA309066/21/92 11037JovannyThomas892 Wrangler St.SeldonNY1178411/12/55 11038ChloeMorrison9540 Airport Rd.MaspethNY1137810/12/94 11039IzayahOlson6 Wentworth Dr.LafayetteIN479052/11/85 11040TaliaRodgers845 Hudson Ave.St. JosephMI490854/15/78 11041GrahamPreston8526 Amherst Dr.HackensackNJ076018/2/62 11042LeahStuart435 Westport Ave.MiddleburgFL3206811/21/49 11043OliverGarrison7932 N. Primrose Dr.ManassasVA2010912/2/88 11044MicahHuffman7859 Lees Creek Dr.Panama CityFL3240412/14/51 11045RachaelFloyd14 1st Ave.LorainOH440523/25/94 11046MarioPonce84 Pennsylvania Dr.New CastlePA161015/6/78 11047MollieBowen24 3rd LaneHopewellVA238604/1/66 11048JayleenMccormick8862 S. Poplar Ave.Winter GardenFL347873/30/48 11049MeadowLevey521 Second StreetBoca RatonFL334281/21/90 11050WillardWright561 Nickerson StreetHudsonOH442363/12/59 PolicyNumberCustomerIDLiabilityPropertyDamagePremiumDeductible H1022211018¤ 100,000.00¤ 300,000.00¤ 1,655.00¤ 2,000.00 H1023411020¤ 300,000.00¤ 500,000.00¤ 1,427.00¤ 2,500.00 H1045511021¤ 100,000.00¤ 400,000.00¤ 1,190.00¤ 1,500.00 H1056611023¤ 100,000.00¤ 200,000.00¤ 1,149.00¤ 1,500.00 H1122311008¤ 500,000.00¤ 600,000.00¤ 2,301.00¤ 1,000.00 H1123311002¤ 500,000.00¤ 500,000.00¤ 1,937.00¤ 2,500.00 H1145511014¤ 300,000.00¤ 600,000.00¤ 2,139.00¤ 5,000.00 H1178911024¤ 100,000.00¤ 300,000.00¤ 1,214.00¤ 2,000.00 H1188911003¤ 300,000.00¤ 550,000.00¤ 1,424.00¤ 5,000.00 H1200011031¤ 100,000.00¤ 200,000.00¤ 978.00¤ 2,500.00 H1233411009¤ 10,000.00¤ 400,000.00¤ 1,700.00¤ 2,500.00 H1234511006¤ 300,000.00¤ 500,000.00¤ 1,865.00¤ 1,000.00 H1244511011¤ 300,000.00¤ 600,000.00¤ 2,714.00¤ 5,000.00 H1245611001¤ 300,000.00¤ 600,000.00¤ 3,205.00¤ 1,000.00 H1324511013¤ 300,000.00¤ 400,000.00¤ 1,863.00¤ 1,000.00 H1345611025¤ 300,000.00¤ 750,000.00¤ 2,829.00¤ 1,000.00 H1356711026¤ 500,000.00¤ 1,000,000.00¤ 3,305.00¤ 5,000.00 H13567A11026¤ 100,000.00¤ 250,000.00¤ 1,905.00¤ 2,500.00 H1367811028¤ 150,000.00¤ 395,000.00¤ 975.00¤ 5,000.00 H1378911030¤ 350,000.00¤ 650,000.00¤ 1,299.00¤ 2,500.00 H1400111034¤ 75,000.00¤ 150,000.00¤ 1,834.00¤ 1,000.00 H1401111035¤ 500,000.00¤ 950,000.00¤ 1,534.00¤ 2,500.00 H14011A11035¤ 100,000.00¤ 275,000.00¤ 1,125.00¤ 2,500.00 H1412311037¤ 250,000.00¤ 600,000.00¤ 2,139.00¤ 1,000.00 H14123A11037¤ 100,000.00¤ 3,000,000.00¤ 1,145.00¤ 1,000.00 H1435411039¤ 100,000.00¤ 275,000.00¤ 983.00¤ 1,000.00 H1445411040¤ 100,000.00¤ 350,000.00¤ 914.00¤ 1,000.00 H1478911043¤ 300,000.00¤ 675,000.00¤ 946.00¤ 2,500.00 H1501211044¤ 300,000.00¤ 495,000.00¤ 3,003.00¤ 5,000.00 H1502311046¤ 100,000.00¤ 295,000.00¤ 1,413.00¤ 1,500.00 H1523411047¤ 500,000.00¤ 875,000.00¤ 1,053.00¤ 5,000.00 H15234A11047¤ 100,000.00¤ 150,000.00¤ 895.00¤ 1,000.00 H1534511050¤ 200,000.00¤ 450,000.00¤ 819.00¤ 5,000.00 CustomerIDFirstNameLastNameAddressCityStatePostalCodeDateOfBirth 11001ElianVelasquez88 Pin Oak Ave.ChesterPA1901312/31/48 11004EliasStone350 Vermont Ave.Egg HarborNJ082349/17/47 11005MelanyHarrison8388 Sherman CourtEgg HarborNJ088734/10/72 11007GabrielleDrake99 S. Windsor Ave.LebanonPA194462/13/96 11010XavierWilcox50 Oak Meadow St.LebanonPA170427/13/95 11011CaidenVega21 Riverside Dr.AllentownPA189749/8/54 11014CadencePittmas7199 Locust CourtRochesterNY146064/11/73 11020SherlynCowan74 East Primrose LaneKunkletownPA180562/5/66 11021DerickClarke78 Old York St.KearnyNJ070322/14/81 11025IyanaJoseph345 Magee Ave.MediaPA1906310/21/65 11026MareliBrooks9949 Madison AveKingstonNY113751/15/69 11027TaylorShea8824 North Thomas Ave.BridgewaterNJ088079/15/46 11030ClaytonChavez537 E. Young St.AllentownPA181025/28/76 11033ArjunAndersen599 Homestead St.SeldonNY117844/4/91 11035AniyaHester164 Cottage Ave.KingstonNY124011/31/79 11037JovannyThomas892 Wrangler St.SeldonNY1178411/12/55 11038ChloeMorrison9540 Airport Rd.MaspethNY1137810/12/94 11041GrahamPreston8526 Amherst Dr.HackensackNJ076018/2/62 11043OliverGarrison7932 N. Primrose Dr.ManassasVA2010912/2/88 11046MarioPonce84 Pennsylvania Dr.New CastlePA161015/6/78 11047MollieBowen24 3rd LaneManassasVA238604/1/66 PolicyNumberCustomerIDLiabilityPersonalPropertyDeductiblePremium R1022311004¤ 100,000.00¤ 75,000.00¤ 500.00¤ 171.00 R1033411017¤ 100,000.00¤ 50,000.00¤ 500.00¤ 242.00 R1123411010¤ 200,000.00¤ 10,000.00¤ 1,000.00¤ 212.00 R1134511015¤ 75,000.00¤ 50,000.00¤ 0.00¤ 183.00 R1199911032¤ 100,000.00¤ 100,000.00¤ 1,000.00¤ 198.00 R1234511019¤ 50,000.00¤ 50,000.00¤ 0.00¤ 154.00 R1245511029¤ 100,000.00¤ 50,000.00¤ 500.00¤ 207.00 R1266611042¤ 100,000.00¤ 85,000.00¤ 500.00¤ 197.00 R1278811033¤ 100,000.00¤ 75,000.00¤ 500.00¤ 204.00 R1290011048¤ 200,000.00¤ 150,000.00¤ 1,000.00¤ 225.00 R1310011038¤ 100,000.00¤ 45,000.00¤ 0.00¤ 213.00 R1311111036¤ 50,000.00¤ 65,000.00¤ 500.00¤ 220.00 R1324511041¤ 200,000.00¤ 100,000.00¤ 1,000.00¤ 181.00 R1345611022¤ 100,000.00¤ 100,000.00¤ 1,000.00¤ 196.00 R1411111045¤ 50,000.00¤ 50,000.00¤ 500.00¤ 179.00 R1422211049¤ 100,000.00¤ 60,000.00¤ 500.00¤ 195.00 R1623411012¤ 100,000.00¤ 50,000.00¤ 500.00¤ 195.00 R1711111016¤ 100,000.00¤ 60,000.00¤ 500.00¤ 203.00 R1788811027¤ 50,000.00¤ 50,000.00¤ 500.00¤ 168.00 R1789011005¤ 150,000.00¤ 100,000.00¤ 1,000.00¤ 184.00 R1876511007¤ 100,000.00¤ 50,000.00¤ 500.00¤ 156.00 PolicyNumberCustomerIDPremiumCoverage U1000111008¤ 474.00¤ 2,000,000.00 U1101111014¤ 383.00¤ 1,000,000.00 U1204511011¤ 396.00¤ 1,000,000.00 U1213711026¤ 1,578.00¤ 10,000,000.00 U1226511030¤ 999.00¤ 10,000,000.00 U1357511035¤ 762.00¤ 5,000,000.00 U1366811043¤ 375.00¤ 1,000,000.00 U1377011037¤ 674.00¤ 1,000,000.00 U1411111047¤ 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 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;