Step Possible 1 0 Start Access. Open the downloaded file named alichoi_grade_HI_Planner.accob Save the file with the name a01ch01 grader_H1_Planner_LastFirst, replacing LastErst with your name. If necessary, enable the content. 2 10 Import the tblEventltems and thIDecorations tables from the alchor_grade_hl_Planitems Access database. 3 3 5 4 10 Open tblClients. In record 8, change Colorado Rojas's street address to 725 Second Avenue. Close the table. Create a form to enter decorations into the thIDecorations table, narning the form fonDecorations Change the title of the form to Decorations. Enter the following products as new records. Notice that you do not have to enter the Decor ID or the Extended Price because Access automatically fills them in: 5 10 6 10 Decoritem Color Category Quantity Price Balloons Red Miscellaneous 12 1.99 Balloons White Miscellaneous 12 1.99 Close the form 7 10 8 Create a query for Beth to use to retrieve information on all the different balloon decorations available for events. Use the Query Wizard to create a query listing Decodd. Decacitem, Color, Quantity, and Price from thiDecorations. Save your query as gryBalloon Decorations. In Design view, type Balloons in the Criteria row for the Decorttem field. Run the query to observe the results. Save and close the query. Create a query that will return the various types of buffet meals offered for events. Using the Query Wizard, create a query that selects Menutype. CostPer Person, and Service Type from tulMenuchoice. Save your query as gey Bufet Meals In Design view, type Buffet in the Criteria row for the ServiceType field. Sort the results by CostPer Person in ascending order. Run the query to observe the results. Save and close the query. 10 9 10 10 Create a report showing ExentDate. Exentrame, Start Time EndTime, Location. and TotalAttendees from tblEvents. Do not add any grouping levels. Sort by EventDate and then EventName in ascending order. Change to Landscape orientation. Name your report totEvents 15 Greated On 07/05/2015 1 YO16 AC CHO1_GRADER PS1 HW-Erent Management w Ccbd AaBbCcDc AaBbCcDc AaBbCcDc AaBbCcDe I No Spac... Subtle Em... Intense E... Quote Intense Q... ng Subtitle 1 Title # Find sac Replace Is Select Editing Styles Color M Brader - Instructions Access 2016 Project Step Instructions Points Possible 11 View the report in Layout view. Modify the report title to be Event Report. Save and close the report. 10 12 Close all database objects. Close the database and exit Access. Submit the database as directed. 0 Total Points 100 HOME LABE TOOLS FIELDS TABLE -cholander Plan Batube CAMRZNU-AppData local Templar6112 OB FILE CREATE X Pe Copy Vie Parte Format Views Cloud All Access Obje... EXTERNAL DATA DATALASE TOOLS 91 Ascending Selection Il Deceding Advanced Remover Toggle Set New Speling Con Rees Art X Olete More Replace Geta Select Find BTUA. Find Test Tomo 10 Tables But Click to Add- Chat then Kodd Furst Name Last Name 10001 Susan Wenn C0002 lona Ellis C0003 Kona Mcconti 0004 lane Foley Mecall COOL Aldan IK CO007 Los English COD Colorado Rojas COO9 Gaiden C0010 Sheta Broch Cook Adam 00012 Adrian Finch C001 Farah Mcmahon C0014 Casa Cochan C0015 Moen Hays C0016 Tate Myers C9012 cote Co Marshall Wone COO Adrian Woodward C020 wides C0021 Mar ott 6022 Sharp C0023 Maco Could C0034 Mar C0025 NA Address City State Zip Code phone Red Rose Avenue Las Vegas NY 1702555-6022 505 Lleifend Road Lebanon OK 0532 (191) 555-7647 5034 Sed Avenue Fontana CA 65735 (560) 555-2542 2018 med Street Louisville WA (764)555-7221 7131 Odio Avenue Portland MI 57794 (25) 555-1535 SE Street Jeannette 78621 (OKJ 555-9030 8907 Tempor Street Valdosta PA 25665 (531) 555-6230 Seed Street Wahoo (795) 555-9673 5547 Matt Road Lake Charles IN (450) 555-5000 0712 Mauris Street Bethany NY 01731 1959555-3790 262 Accumsan Road Stockton ON (889) 555-1966 101 Tactive Cary MN 75 (87) 535-3753 577 Amet Avenue Solwater SMS 105555.9907 56 Vivamus Hutchinson 68371 (1751555-1012 19 Non Avenue Mark's Point NE 5579 (352) 555 5:37 Solene Street C St. Louis KY 17166 (723) 555215 3215 Phasellus Road Brockton 2110 (3.10) 555-1345 95 Sodales Street The Dalles LA Mon 17355-615 065 Avenue Concord CA 10273 2971 este (670) 565-7930 Citrus OH 07110 10 Nato (113) 555-60 Shreveport (852) 565-1967 17 Semper Aven AK 256 2017 Elementum ad (515) 55-0546 Commerce AK 050 (104) 558-8506 Marette MT 3597 Die (214) 555-5613 VA 22001 (2031535-100 28.935 020 Type to search O FILE WTOOS HOVE CHIATE XG EXTUAL DA DAWASIL 9. Accending leading to View C ca ng F MEX Dard Tund M. T- Sed Find Sert BIA All Access Obje... P This Event Name Date Martin Time 1 Weston 1 PM FM Downtown 2 Conde 1/11/2015 BODAM 2:00 PM City Conference Center training Semina 9/7/2059 AM M City Conference Center Wedding Reception 3/14/20 BPM 10:30 PM Vital Sconto 9/4/2015 8.00 AM KIM City Conference Center Wedding reception Won 7.10 PU AM Fool (New) BB CVT Globur I SS.. GUA 25,000.00 Lt 10.000.00 200 000 100 St Mall ber AB ALE HOME CREATE XC Copy Pasta View 2 Vio Card All Access Obje. Tables TOOLS 0100g Hanne Das MZIWAppDat local organic EXTSIAL DATA DIRARASI TDS FILLOS TABLE 9. Arcang Ylection M Replace Cab Il Descending Adword. Bewe peling Go Refresh emeresort M Select BIWA." Sort Het Find testoming the Menu Servicetype MeType - Costerperson wide to Add 5 Down Tonal SHAALLA 1 st Down Italian $14.95 UEWAALLA Down Mexican $12.95 UPALUA Sit Down Cincie SIS VALOA 6 Down Chef's Choice $20.95 UwAALUA 7 Buffet Traditional $24.50 UEWALA buttet Italian $13.5 VW PALMA 5 Buffet Mesin $11. WAALUA 18 fet Chinese $14.95 ALLA in tuttet Cherche SI ALLA New WO OH TABLE TOOLS - 01_grad_H Pane Database CAMRUWU-RAOrlocal Top SOUTCHES FLE HOME CREATE EXTERNAL DATA DATABASE TOOLS FIELDS TABLE Xcut Ascending T Selection New Total M Replace Calon Det Pa Copy Descending Ya Advanced Sve Spelling Go To View Path Fiter Refresh Find Format Painter Remove Sort Toggle A Delete. More Select- WAAR View Clipboard Sart A Record Int Formatting Menuch wenu All Access Obje...@ Client Menu millowidCi Add Bennett Tables 2 Goud 7 4 Cochran 2 ton Slast lm vi Event Step Possible 1 0 Start Access. Open the downloaded file named alichoi_grade_HI_Planner.accob Save the file with the name a01ch01 grader_H1_Planner_LastFirst, replacing LastErst with your name. If necessary, enable the content. 2 10 Import the tblEventltems and thIDecorations tables from the alchor_grade_hl_Planitems Access database. 3 3 5 4 10 Open tblClients. In record 8, change Colorado Rojas's street address to 725 Second Avenue. Close the table. Create a form to enter decorations into the thIDecorations table, narning the form fonDecorations Change the title of the form to Decorations. Enter the following products as new records. Notice that you do not have to enter the Decor ID or the Extended Price because Access automatically fills them in: 5 10 6 10 Decoritem Color Category Quantity Price Balloons Red Miscellaneous 12 1.99 Balloons White Miscellaneous 12 1.99 Close the form 7 10 8 Create a query for Beth to use to retrieve information on all the different balloon decorations available for events. Use the Query Wizard to create a query listing Decodd. Decacitem, Color, Quantity, and Price from thiDecorations. Save your query as gryBalloon Decorations. In Design view, type Balloons in the Criteria row for the Decorttem field. Run the query to observe the results. Save and close the query. Create a query that will return the various types of buffet meals offered for events. Using the Query Wizard, create a query that selects Menutype. CostPer Person, and Service Type from tulMenuchoice. Save your query as gey Bufet Meals In Design view, type Buffet in the Criteria row for the ServiceType field. Sort the results by CostPer Person in ascending order. Run the query to observe the results. Save and close the query. 10 9 10 10 Create a report showing ExentDate. Exentrame, Start Time EndTime, Location. and TotalAttendees from tblEvents. Do not add any grouping levels. Sort by EventDate and then EventName in ascending order. Change to Landscape orientation. Name your report totEvents 15 Greated On 07/05/2015 1 YO16 AC CHO1_GRADER PS1 HW-Erent Management w Ccbd AaBbCcDc AaBbCcDc AaBbCcDc AaBbCcDe I No Spac... Subtle Em... Intense E... Quote Intense Q... ng Subtitle 1 Title # Find sac Replace Is Select Editing Styles Color M Brader - Instructions Access 2016 Project Step Instructions Points Possible 11 View the report in Layout view. Modify the report title to be Event Report. Save and close the report. 10 12 Close all database objects. Close the database and exit Access. Submit the database as directed. 0 Total Points 100 HOME LABE TOOLS FIELDS TABLE -cholander Plan Batube CAMRZNU-AppData local Templar6112 OB FILE CREATE X Pe Copy Vie Parte Format Views Cloud All Access Obje... EXTERNAL DATA DATALASE TOOLS 91 Ascending Selection Il Deceding Advanced Remover Toggle Set New Speling Con Rees Art X Olete More Replace Geta Select Find BTUA. Find Test Tomo 10 Tables But Click to Add- Chat then Kodd Furst Name Last Name 10001 Susan Wenn C0002 lona Ellis C0003 Kona Mcconti 0004 lane Foley Mecall COOL Aldan IK CO007 Los English COD Colorado Rojas COO9 Gaiden C0010 Sheta Broch Cook Adam 00012 Adrian Finch C001 Farah Mcmahon C0014 Casa Cochan C0015 Moen Hays C0016 Tate Myers C9012 cote Co Marshall Wone COO Adrian Woodward C020 wides C0021 Mar ott 6022 Sharp C0023 Maco Could C0034 Mar C0025 NA Address City State Zip Code phone Red Rose Avenue Las Vegas NY 1702555-6022 505 Lleifend Road Lebanon OK 0532 (191) 555-7647 5034 Sed Avenue Fontana CA 65735 (560) 555-2542 2018 med Street Louisville WA (764)555-7221 7131 Odio Avenue Portland MI 57794 (25) 555-1535 SE Street Jeannette 78621 (OKJ 555-9030 8907 Tempor Street Valdosta PA 25665 (531) 555-6230 Seed Street Wahoo (795) 555-9673 5547 Matt Road Lake Charles IN (450) 555-5000 0712 Mauris Street Bethany NY 01731 1959555-3790 262 Accumsan Road Stockton ON (889) 555-1966 101 Tactive Cary MN 75 (87) 535-3753 577 Amet Avenue Solwater SMS 105555.9907 56 Vivamus Hutchinson 68371 (1751555-1012 19 Non Avenue Mark's Point NE 5579 (352) 555 5:37 Solene Street C St. Louis KY 17166 (723) 555215 3215 Phasellus Road Brockton 2110 (3.10) 555-1345 95 Sodales Street The Dalles LA Mon 17355-615 065 Avenue Concord CA 10273 2971 este (670) 565-7930 Citrus OH 07110 10 Nato (113) 555-60 Shreveport (852) 565-1967 17 Semper Aven AK 256 2017 Elementum ad (515) 55-0546 Commerce AK 050 (104) 558-8506 Marette MT 3597 Die (214) 555-5613 VA 22001 (2031535-100 28.935 020 Type to search O FILE WTOOS HOVE CHIATE XG EXTUAL DA DAWASIL 9. Accending leading to View C ca ng F MEX Dard Tund M. T- Sed Find Sert BIA All Access Obje... P This Event Name Date Martin Time 1 Weston 1 PM FM Downtown 2 Conde 1/11/2015 BODAM 2:00 PM City Conference Center training Semina 9/7/2059 AM M City Conference Center Wedding Reception 3/14/20 BPM 10:30 PM Vital Sconto 9/4/2015 8.00 AM KIM City Conference Center Wedding reception Won 7.10 PU AM Fool (New) BB CVT Globur I SS.. GUA 25,000.00 Lt 10.000.00 200 000 100 St Mall ber AB ALE HOME CREATE XC Copy Pasta View 2 Vio Card All Access Obje. Tables TOOLS 0100g Hanne Das MZIWAppDat local organic EXTSIAL DATA DIRARASI TDS FILLOS TABLE 9. Arcang Ylection M Replace Cab Il Descending Adword. Bewe peling Go Refresh emeresort M Select BIWA." Sort Het Find testoming the Menu Servicetype MeType - Costerperson wide to Add 5 Down Tonal SHAALLA 1 st Down Italian $14.95 UEWAALLA Down Mexican $12.95 UPALUA Sit Down Cincie SIS VALOA 6 Down Chef's Choice $20.95 UwAALUA 7 Buffet Traditional $24.50 UEWALA buttet Italian $13.5 VW PALMA 5 Buffet Mesin $11. WAALUA 18 fet Chinese $14.95 ALLA in tuttet Cherche SI ALLA New WO OH TABLE TOOLS - 01_grad_H Pane Database CAMRUWU-RAOrlocal Top SOUTCHES FLE HOME CREATE EXTERNAL DATA DATABASE TOOLS FIELDS TABLE Xcut Ascending T Selection New Total M Replace Calon Det Pa Copy Descending Ya Advanced Sve Spelling Go To View Path Fiter Refresh Find Format Painter Remove Sort Toggle A Delete. More Select- WAAR View Clipboard Sart A Record Int Formatting Menuch wenu All Access Obje...@ Client Menu millowidCi Add Bennett Tables 2 Goud 7 4 Cochran 2 ton Slast lm vi Event