Expert answer:Microsoft access

  

Solved by verified expert:YO16_AC_BU02_GRADER_PS1_HW – Hotel Reservations
Project Description:
A database has been started to keep track of the hotel reservations with guest information, reservation information, and additional room charge information. There are no reports, forms, or queries built yet, so the staff feels like the database is not easy to use. You will create reports, forms, and queries to help the staff better manage the data in the 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 file named a02_grader_h1_start.accdb. Save the file with the name a02_grader_h1_start_LastFirst, replacing LastFirst with your name. In the Security Warning bar, click Enable Content. 0
2 Open tblGuests. Add a new record with Last Name Student, First Name Access, Address 101 Main Street, City Santa Fe, State NM, ZipCode 87594, and Phone (505) 555-1010. Close the table. 5
3 Using Query Design, create a query from tblReservations that returns the average room rate, the minimum rate, and the maximum rate (in that order) for each DiscountType for the rooms that are currently reserved. The DiscountType should be displayed in the first column. Rename the rate fields Average Rate, Minimum Rate, and Maximum Rate. Sort the query in Descending order by DiscountType. In Datasheet view, autofit the column widths. Save the query as qryDiscountTypeStatistics_aStudent. Close the query. 8
4 Use the Form Wizard to create a form to enter guest information as well as reservation information, with guest information added first. Add all fields (in the existing order) from both tables EXCEPT GuestID (from either table) and ReservationID. Accept all other default options and name the form frmGuestReservations_aStudent and the subform frmGuestSubform_aStudent. 8
5 In Layout view, change the form title to Guest Reservations. Make the title font size 28 and bold. Apply the theme a02_grader_h1_Paradise.thmx to all objects in your database. 5
6 Insert a02_grader_h1_Paradise.jpg into the main form. In the Property Sheet, on the Format tab, change the Width to 2.5″ and the Height to 1.1″. Move the image to the right of the guest fields, keeping the top edge aligned with the top edge of the GuestLastName control. 5
7 Remove the subform label. Move the subform to immediately below the Phone label and align the left edges of the two controls. Autofit the columns in the subform. 6
8 In Design view, add Created by a Student to the main form Form Footer. Save the form. 3
9 Change to Form view. Find the record for Elaine Foley. Add a new reservation with the information below:
CheckInDate 1/25/2018
RoomType Double (1 king bed)
Nights Stay 3
RoomRate $289.00
# Of Guests 2
Discount Type None
Crib No
Handicapped No
Save and close the form. 5
10 Using the Query Wizard, create a query to find all guests who do not have matching reservations. Include the fields GuestLastName, GuestFirstName, Address, City, State, and ZipCode. Name the query qryGuestsWithoutReservations_aStudent. In the Design grid, sort the query by GuestLastName and GuestFirstName in Ascending order. Change the Font size of the query results to 14. Change the Alternate Row Color to theme color Red, Accent 4, Lighter 60%, and AutoFit all the columns. Close the query and save the changes. 12
11 Use Query Design to create a query from tblGuests and tblReservations. The results should include the GuestFirstName, GuestLastName, NightsStay, RoomRate, and CheckInDate, in that order. Select only guests who checked in between December 1, 2017 and December 31, 2017, but do not show CheckInDate in your results. Save the query as qryDecemberRoomCharges_aStudent. Add a new field that calculates the total due for each guest based on the number of nights they have stayed and the room rate for each guest. Name the new field TotalRoomCharge. Run the query. AutoFit the new column in Datasheet view. Close the query and save the changes. 17
12 Use the Report Wizard to create a report to show all room charges incurred for each guest (not including the charge for their room) using tblGuests and tblRoomCharges. Add the GuestFirstName, GuestLastName, ChargeCategory, and ChargeAmount to the report. View the report by tblGuests. Sort by ChargeAmount in ascending order. Accept all other default options and name the report rptRoomCharges_aStudent. 8
13 Add a subtotal to the Amount field, set a caption for the new control, and type Total Charges. Add conditional formatting to the subtotal control to highlight in Red and Bold all subtotals that are over $200. Add a caption for the grand total in the report footer to Grand Total. Change the report title to Room Charges by Guest. Add Created by a Student to the report footer. Export the report as a PDF file and name it a02ps1PdfCharges_LastFirst. Save and close the report. 12
14 Create a split form to show all the reservation information from tblReservations. Save the form as frmReservationSplit_aStudent. Add Created by a Student to the Form Footer. Save and close the form. 6
15 Close all database objects. Close the database and then exit Access. Submit only the database as directed. 0
Total Points 100
a02_grader_h1_paradise.jpg

yo16_ac_bu02_grader_ps1_hw_instructions.docx

Don't use plagiarized sources. Get Your Custom Essay on
Expert answer:Microsoft access
Just from $10/Page
Order Essay

Unformatted Attachment Preview

Office 2016 – myitlab:grader – Instructions
Your Office Access BU 2 – Homework 1
YO16_AC_BU02_GRADER_PS1_HW – Hotel Reservations
Project Description:
A database has been started to keep track of the hotel reservations with guest information, reservation
information, and additional room charge information. There are no reports, forms, or queries built yet, so the
staff feels like the database is not easy to use. You will create reports, forms, and queries to help the staff better
manage the data in the 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 file named a02_grader_h1_start.accdb. Save the file with
the name a02_grader_h1_start_LastFirst, replacing LastFirst with your name. In the
Security Warning bar, click Enable Content.
0
2
Open tblGuests. Add a new record with Last Name Student, First Name Access, Address
101 Main Street, City Santa Fe, State NM, ZipCode 87594, and Phone (505) 555-1010.
Close the table.
5
3
4
Using Query Design, create a query from tblReservations that returns the average room rate,
the minimum rate, and the maximum rate (in that order) for each DiscountType for the rooms
that are currently reserved. The DiscountType should be displayed in the first column. Rename
the rate fields Average Rate, Minimum Rate, and Maximum Rate. Sort the query in
Descending order by DiscountType. In Datasheet view, autofit the column widths. Save the
query as qryDiscountTypeStatistics_aStudent. Close the query.
Use the Form Wizard to create a form to enter guest information as well as reservation
information, with guest information added first. Add all fields (in the existing order) from both
tables EXCEPT GuestID (from either table) and ReservationID. Accept all other default options
and name the form frmGuestReservations_aStudent and the subform
frmGuestSubform_aStudent.
8
8
5
In Layout view, change the form title to Guest Reservations. Make the title font size 28 and
bold. Apply the theme a02_grader_h1_Paradise.thmx to all objects in your database.
5
6
Insert a02_grader_h1_Paradise.jpg into the main form. In the Property Sheet, on the Format
tab, change the Width to 2.5″ and the Height to 1.1″. Move the image to the right of the
guest fields, keeping the top edge aligned with the top edge of the GuestLastName control.
5
7
Remove the subform label. Move the subform to immediately below the Phone label and align
the left edges of the two controls. Autofit the columns in the subform.
6
8
In Design view, add Created by a Student to the main form Form Footer. Save the form.
3
9
Change to Form view. Find the record for Elaine Foley. Add a new reservation with the
information below:
CheckInDate 1/25/2018
RoomType Double (1 king bed)
5
Updated: 5/5/2016
1
YO16_AC_BU02_GRADER_PS1_HW_Instructions.docx
Office 2016 – myitlab:grader – Instructions
Step
Your Office Access BU 2 – Homework 1
Points
Possible
Instructions
Nights Stay 3
RoomRate $289.00
# Of Guests 2
Discount Type None
Crib No
Handicapped No
10
11
12
13
Save and close the form.
Using the Query Wizard, create a query to find all guests who do not have matching
reservations. Include the fields GuestLastName, GuestFirstName, Address, City, State, and
ZipCode. Name the query qryGuestsWithoutReservations_aStudent. In the Design grid,
sort the query by GuestLastName and GuestFirstName in Ascending order. Change the Font
size of the query results to 14. Change the Alternate Row Color to theme color Red, Accent 4,
Lighter 60%, and AutoFit all the columns. Close the query and save the changes.
Use Query Design to create a query from tblGuests and tblReservations. The results should
include the GuestFirstName, GuestLastName, NightsStay, RoomRate, and CheckInDate, in that
order. Select only guests who checked in between December 1, 2017 and December 31, 2017,
but do not show CheckInDate in your results. Save the query as
qryDecemberRoomCharges_aStudent. Add a new field that calculates the total due for
each guest based on the number of nights they have stayed and the room rate for each guest.
Name the new field TotalRoomCharge. Run the query. AutoFit the new column in Datasheet
view. Close the query and save the changes.
Use the Report Wizard to create a report to show all room charges incurred for each guest
(not including the charge for their room) using tblGuests and tblRoomCharges. Add the
GuestFirstName, GuestLastName, ChargeCategory, and ChargeAmount to the report. View the
report by tblGuests. Sort by ChargeAmount in ascending order. Accept all other default
options and name the report rptRoomCharges_aStudent.
Add a subtotal to the Amount field, set a caption for the new control, and type Total
Charges. Add conditional formatting to the subtotal control to highlight in Red and Bold all
subtotals that are over $200. Add a caption for the grand total in the report footer to Grand
Total. Change the report title to Room Charges by Guest. Add Created by a Student to
the report footer. Export the report as a PDF file and name it
a02ps1PdfCharges_LastFirst. Save and close the report.
12
17
8
12
14
Create a split form to show all the reservation information from tblReservations. Save the form
as frmReservationSplit_aStudent. Add Created by a Student to the Form Footer. Save
and close the form.
6
15
Close all database objects. Close the database and then exit Access. Submit only the database
as directed.
0
Total Points
Updated: 5/5/2016
2
100
YO16_AC_BU02_GRADER_PS1_HW_Instructions.docx

Purchase answer to see full
attachment

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 30% with the discount code ESSAYSHELP