Expert answer:small Access Assignment help

Solved by verified expert:The assignment consists of a few steps on the word doc. I have had trouble putting this one together and would appreciate the help, that way I can go through it and review what was done and understand it better.
a01ch01_grader_h1_planitems.zip

pack_a01ch01_grader_h1_planner.zip

yo16_ac_ch01_grader_ps1_hw_instructions.docx

Unformatted Attachment Preview

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

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades