Expert answer:help on Chapter 6 assignment

Expert answer:Need some help with these questions for access assignment. I was able to do the past 2 fairly easily, but am stuck on this one.
yo16_ac_ch06_grader_pc_hw_instructions.docx

pack_a03ch06_grader_pc_golf1.zip

Unformatted Attachment Preview

Office 2016 – myitlab:grader – Instructions
Your Office Access Chapter 6 Prepare Case
YO16_AC_CH06_GRADER_PC_HW – Red Bluff Golf Club Database
Project Description:
The Red Bluff Golf Club needs useful information in order to run its business efficiently. Barry Cheney, the
manager, has asked you to create queries to track the golfers who have scheduled tee times and private lessons.
Additionally, you need to create queries for decision making, such as scheduling golf pros for private lessons or
determining how many golf caddies are needed on a busy day. To keep the file small while you work with the
database, Barry removed most of the data and left only some sample data for you to manipulate. Once Barry has
accepted your changes, he will load all the data and implement the new database.
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 a03ch06_grader_pc_Golf1.accdb. Save
the file with the name a03ch06_grader_pc_Golf1_LastFirst, replacing LastFirst with your
name. Enable the content, if necessary.
0
2
Create a query based on the tblMember table that will display FirstName, LastName, Address,
City, State, and ZipCode in that order. In the LastName field, use a wildcard and the Like
function to include customers whose last names begin with letters A through E.
12
3
Sort the results in Ascending order by LastName. Run the query, and then save as
qryMemberAE. Close the query.
4
4
5
Create a parameter query based on tblEmployee, tblMember, and tblMemberLessons so that
when an employee’s last name is entered, it will determine what members have lessons
scheduled with the employee. The query results should display FirstName and LastName from
tblEmployee, FirstName and LastName from tblMember, and ScheduledDate and Fee from
tblMemberLessons, in that order. The prompt should read [Enter the Employee’s Last
Name]. Run the query, enter a LastName when prompted, and then save as qryParameter.
Close the query.
Create a query based on the tblEmployee and tblPosition tables that will concatenate the
employee’s first and last names (separated by a space) and concatenate the employee’s
position type and position field (separated by a space) in that order. Name the concatenated
field with the employee’s first and last name Employee. Name the concatenated field with
the position type and position field Job Title. Run the query, and then save as
qryConcatenate. Close the query.
18
18
6
Create a query based on the tblEmployee table that will determine employees with salaries
between 50000 and 75000. Display FirstName, LastName, and Salary in that order. Run the
query, and then save as qryBetween. Close the query.
15
7
Use the data in tblEmployee to create a query that will display whether the employee has a
photo on file or not. The query results should list FirstName, LastName, and PhotoStatus in
that order, where PhotoStatus is a new field that displays whether a photo has been taken
or not. If the Photo field in tblEmployee is empty, the PhotoStatus field should display Needs
Photo. If the Photo field contains a value, the PhotoStatus field should display Has Photo.
Run the query, and then save it as qryIsNullFunction. Close the query.
18
Updated: 12/03/2016
1
YO16_AC_CH06_GRADER_PC_HW_Instructions.docx
Office 2016 – myitlab:grader – Instructions
Step
Your Office Access Chapter 6 Prepare Case
Points
Possible
Instructions
8
Create a query based on the tblEmployee table that will determine the year of employee’s
five-year anniversary (and therefore is eligible for a bonus). The query results should show
LastName, FirstName, and HireDate.
5
9
Add a calculated field named 5 Year Anniversary that displays the year that the employee
reaches five years of employment. Your calculated field should use the DatePart function. Run
the query, and then save it as qryDatePart. Close the query.
10
Close all database objects. Close the database and then exit Access. Submit the database as
directed.
0
10
Total Points
Updated: 12/03/2016
2
100
YO16_AC_CH06_GRADER_PC_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