I NEED HELP WITH THESE DIRECTIONS CAN SOMEONE WALK ME THREW HOW TO DO THIS OR DO IT FOR ME PLEASE AND THANK YOU
THE ATTACHED FILE IS THE ONE YOU HAVE TO USE FOR THE INSTRUCTIONS
1. Start Access, and then download, save, and open the database a03_ps2_Hotel2. Save the database with the name
Lastname_Firstname_a03_ps2_Hotel2, replacing Lastname_Firstname with your own name.
2. Create a query that allows you to look up a reservation by entering a customer's full name. Use the tblGuests and
tblReservations tables. Combine the GuestFirstName and GuestLastName into a calculated field named FullName from tblGuests.
The first and last names are separated by a space. The query results should list FullName, as well as ReservationID,
CheckInDate, NightsStay, and NumberOfGuests (in that order). Do not save the query yet.
3. For the current query, the query should display Enter a Guest's First and Last Name with a space in between, such as John
Smith when it runs. Sort the query in ascending order by CheckInDate. Make sure that all reservations that are displayed are
dated on or after today. Run the query and enter Susan Wenner to test it. Save the query as qryFindReservation. Close the
4. Create a query to list all reservations, the guest's room service and restaurant charges, and calculate a mandatory
gratuity. Use the tblReservations and tblRoomCharges tables. Your query results should show ReservationID, CheckInDate,
ChargeCategory, and ChargeAmount, in that order. The ChargeCategory field should display all charges made at Indigo5, Terra
Cotta Brew, Silver Moon Lounge, and Room Service. Do not save the query yet.
5. Add a calculated field to the current query named Gratuity. This field should use the ChargeAmount field and calculate a
gratuity of 18%. Format the Gratuity field as Currency. Sort the query in ascending order by CheckInDate. Run the query, save
it as qryCharges, and then close the query.
6. Create a new query using the tblReservations table that lists guests with future reservations. The query results should
list GuestID, CheckInDate, Crib, Handicapped, and RoomType, in that order. Do not save the query yet.
7. Your query should list the guests that have future reservations for a double room. Look at the data in the tblReservations
table carefully. Notice that double rooms have a room type of either Double (1 king bed) or Double (2 queen beds). Ensure
your query lists all reservations for both kinds. Sort the query in ascending order by CheckInDate. Run the query, save it as
qryDoubleRoom, and then close the query.
8. Create a query that lists the guests who reside in AK, MT, or IA. Use the tblReservations and tblGuests tables. The query
should list GuestFirstName, GuestLastName, Address, City, State, ZipCode, CheckInDate, and RoomRate, in that order. This list
should also only contain guests who will be paying between $300 and $400 for their room. Sort the query in ascending order by
CheckInDate. Do not save the query yet.
9. Create a new field in the current query that calculates the date that is 14 days before the CheckInDate so front desk
employees can call the guest and confirm the reservation 2 weeks prior to their arrival. Call the new field RSVPCallDate. Run
the query, save it as qryGuests, and then close the query.
10. Create a new query. Use the tblReservations and tblGuests tables. The query results should list GuestFirstName,
GuestLastName, ReservationID, CheckInDate, NightsStay, and NumberOfGuests. Do not save the query yet.
11. Add a new field called CheckOutDate that calculates the guests' check-out date based on when they check in and how many
nights they are staying. Sort the query in ascending order by CheckOutDate. Run the query, save it as qryCheckOutDate, and
then close the query.
12. Close all database objects. Close the database and then exit Access. Submit the database as directed.