Description
need help with hw
Office 2016 – myitlab:grader – Instructions
Your Office – Access Chapter 3: Homework Project 1
YO16_AC_CH03_GRADER_PS1_HW – Rakes Event Management
Project Description:
Beth Rakes runs an event planning service. She has a database with clients, events, menus, and decorations. She
has hired you to add queries to make the database more useful. You have been given a small database with
representative data.
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 Access file named a02ch03_grader_a1.accdb. Save the file
with the name a02ch03_grader_a1_LastFirst, replacing LastFirst with your name. In the
Security Warning bar, click Enable Content.
0
2
Open tblClients. In the last record, change the First Name to Access and the Last Name to
Student.
4
3
Modify tblEvents to have a font size of 14. Autofit all fields. Change to an Alternate Row Color
of Gold, Accent 4, Lighter 80%. Save and close the table.
5
4
Using the Find Duplicates Query Wizard, create a query that will show events on the same
dates. Show all the available fields in the query. Name the query qryDupDates_aStudent.
Save and close the query.
7
5
Using the Find Unmatched Query Wizard, create a query that will show anyone who is listed
as a client in tblClient but does not have an event booked. Return the fields LastName,
FirstName, City, State, and Phone (in that order). Name the query
qryClientNoEvent_aStudent. Sort in ascending order by LastName and then FirstName.
Save and close the query.
10
6
Using Query Design, create a query that returns clients’ LastName, FirstName, EventName,
EventDate, and Rate (in that order). Sort in ascending order by LastName and then
FirstName. Switch to Datasheet View and add a total row to show the sum of rate amounts.
Name the query qryRates_aStudent. Save and close the query.
12
7
Using Query Design, create a query that returns EventDate, EventName, Location,
TotalAttendees, and Rate (in that order). Select only those that have 100 or more attendees.
Sort the results by Rate (highest to lowest) but do not show Rate in the results. Name the
query qryLargeEvents_aStudent. Save and close the query.
15
8
Using Query Design, create a query that selects EventDate, EventName, and TotalAttendees
from tblEvents, and MenuType and CostPerPerson from tblMenuChoice (in that order.) Also
include tblMenuItems to avoid the multiplier effect. Name the query
qryMenuCosts_aStudent.
18
9
Add a new field MenuCost, which is calculated as TotalAttendees * CostPerPerson. Sort
the results by EventDate (ascending) and MenuCost (descending). Autofit all fields. Save and
close the query.
5
Updated: 02/25/2016
1
YO16_AC_CH03_GRADER_PS2_AS_Instructions.docx
Office 2016 – myitlab:grader – Instructions
Step
Your Office – Access Chapter 3: Homework Project 1
Points
Possible
Instructions
10
Using Query Design, create a query that returns the count, sum, average, minimum, and
maximum of all event rates (in that order.) Name the fields Event Count, Total Rates,
Average Rate, Minimum Rate, and Maximum Rate (in that order.) Autofit the column
widths. Name the query qryEventRateStats_aStudent. Save and close the query.
12
11
Using Query Design, create a query that returns the client’s LastName, FirstName,
EventName, EventDate, and TotalAttendees for any event in April 2018 that has 200 or more
attendees. Sort in ascending order by client LastName and FirstName. Name the query
qryAprilBigEvents_aStudent. Save and close the query.
12
12
Close all database objects. Close the database and then exit Access. Submit the database as
directed.
0
Total Points
Updated: 02/25/2016
2
100
YO16_AC_CH03_GRADER_PS2_AS_Instructions.docx
Purchase answer to see full
attachment