Sheet1 PolicyNumberCustomerIDPremiumCoverage U20011110052151,000,000 U21145110222261,000,000 U22138110412782,000,000 U22269110423012,000,000 U20771110483152,000,000...

1 answer below »
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;
Answered Same DayMay 04, 2021

Answer To: Sheet1 PolicyNumberCustomerIDPremiumCoverage U20011110052151,000,000...

Neha answered on May 04 2021
122 Votes
56657/Renters.xlsx
Renters
        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        11
029        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
1
2
3
4
5
6
7
8
9
A
B
C
D
E
56657/scac192ajekolbyworthy_2.accdb
        IfSuccessful_Status        GA_Status_Icon        SAM_Logo
        true                
        false                
        ID        FirstName        LastName        AssignmentGUID        UserID
        false        Je'Kolby        Worthy        {148B930A-6349-4AA5-A071-BC07771F77B9}        {148B930A-6349-4AA5-A071-BC07771F77B9}
        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        12/31/48
        11002        Joaquin        Howe        598 West Ramblewood Dr.        Harrison        MI        48045        8/9/45
        11003        Heaven        Barton        31 Gartner Court        North Olmstead        OH        44070        3/19/65
        11004        Elias        Stone        350 Vermont Ave.        Egg Harbor        NJ        08234        9/17/47
        11005        Melany        Harrison        8388 Sherman Court        Somerset        NJ        08873        4/10/72
        11006        Anne        Rich        84 Beechwood St.        Windsor        CT        06095        1/2/74
        11007        Gabrielle        Drake        99 S. Windsor Ave.        Lansdale        PA        19446        2/13/96
        11008        Malik        Kelley        7409 W. Glendale St.        Bristol        CT        06010        5/27/80
        11009        Darren        Savage        883 Rockland Dr.        Romeoville        IL        60446        5/3/76
        11010        Xavier        Wilcox        50 Oak Meadow St.        Lebanon        PA        17042        7/13/95
        11011        Caiden        Vega        21 Riverside Dr.        Warminster        PA        18974        9/8/54
        11012        Julia        Ellison        8730 Swanson Court        Jacksonville Beach        FL        32250        10/31/39
        11013        Beckett        Valencia        68 Orange St.        Flowery Branch        GA        30542        2/26/59
        11014        Cadence        Pittmas        7199 Locust Court        Rochester        NY        14606        4/11/73
        11015        Nevaeh        Huber        811 North Winding Way        West Lafayette        IN        47906        9/9/50
        11016        Karma        Wood        512 Sleepy Hollow Ave.        Eastpointe        MI        48021        6/5/90
        11017        Remington        Wilkerson        9169 Ramblewood Dr.        Alabaster        AL        35007        4/29/96
        11018        Madalyn        Rush        7038 North Lane        Lincoln Park        MI        48146        5/26/38
        11019        Jazlyn        Brennan        9 Studebaker St.        Waxhaw        NC        28173        3/30/95
        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
        11022        Kamila        Juarez        281 Iriquois St.        Shrewsbury        MA        01545        3/2/97
        11023        Edith        Kelly        348 South Foxrun St.        Bluffton        SC        29910        11/9/41
        11024        Shelby        Hancock        35 South Canal St.        Niles        MI        49120        12/12/59
        11025        Iyana        Joseph        345 Magee Ave.        Media        PA        19063        10/21/65
        11026        Mareli        Brooks        9949 Madison Ave        Forest Hills        NY        11375        1/15/69
        11027        Taylor        Shea        8824 North Thomas Ave.        Bridgewater        NJ        08807        9/15/46
        11028        Natasha        Mcdonald        668 Charles Street        Muskegon        MI        49441        3/19/43
        11029        Selena        Francis        9607 Charles Ave.        Romulus        MI        48174        4/5/94
        11030        Clayton        Chavez        537 E. Young St.        Allentown        PA        18102        5/28/76
        11031        Asia        Walters        7394 Proctor Dr.        Andover        MA        01810        6/1/68
        11032        Jax        Levy        33 E. Elmwood Ave.        Deltona        FL        32725        6/14/44
        11033        Arjun        Andersen        599 Homestead St.        Seldon        NY        11784        4/4/91
        11034        Trevin        Zavala        7176 Atlantic Rd.        Key West         FL        33040        6/7/87
        11035        Aniya        Hester        164 Cottage Ave.        Kingston        NY        12401        1/31/79
        11036        Jazlene        Clarke        3 Fairway...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here