Office 2016 – myitlab:grader – Instructions Your Office - Access Chapter 1: Homework Project 1 YO16_AC_CH01_GRADER_PS1_HW - Rakes Event Management Project Description: Beth Rakes runs an event planning service. She is moving toward using Access to manage her business more effectively. In one database, she tracks clients, events, and menus that each client has booked. In another database, she has many decorations reserved for events. She has hired you to consolidate the databases and make some additional changes that will improve the database’s functionality. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Access. Open the downloaded file named a01ch01_grader_H1_Planner.accdb. Save the file with the name a01ch01_grader_H1_Planner_LastFirst, replacing LastFirst with your name. If necessary, enable the content. 0 2 Import the tblEventItems and tblDecorations tables from the a01ch01_grader_h1_PlanItems Access database. 10 3 Open tblClients. In record 8, change Colorado Rojas's street address to 725 Second Avenue. Close the table. 5 4 Create a form to enter decorations into the tblDecorations table, naming the form frmDecorations. 10 5 Change the title of the form to Decorations. 10 Enter the following products as new records. Notice that you do not have to enter the DecorID or the Extended Price because Access automatically fills them in: 6 7 8 DecorItem Balloons Balloons Color Category Red Miscellaneous White Miscellaneous Quantity Price 12 1.99 12 1.99 Close the form. 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 DecorID, DecorItem, Color, Quantity, and Price from tblDecorations. Save your query as qryBalloonDecorations. In Design view, type Balloons in the Criteria row for the DecorItem 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, CostPerPerson, and ServiceType from tblMenuChoice. Save your query as qryBuffetMeals. Updated: 02/26/2016 1 10 10 10 YO16_AC_CH01_GRADER_PS1_HW_Instructions.docx Office 2016 – myitlab:grader – Instructions Step 9 10 Your Office - Access Chapter 1: Homework Project 1 Points Possible Instructions In Design view, type Buffet in the Criteria row for the ServiceType field. Sort the results by CostPerPerson in ascending order. Run the query to observe the results. Save and close the query. Create a report showing EventDate, EventName, StartTime, 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 rptEvents. 10 15 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 Updated: 02/26/2016 2 100 YO16_AC_CH01_GRADER_PS1_HW_Instructions.docx
Purchase answer to see full attachment