I NEED HELP WITH THESE DIRECTIONS CAN SOMEONE WALK ME THREW HOW TO DO THIS OR DO IT FOR ME PLEASE AND THANK YOU :banghead:
THE ATTACHED FILE IS THE ONE YOU HAVE TO USE FOR THE INSTRUCTIONS
Step 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 query.
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.
THE ATTACHED FILE IS THE ONE YOU HAVE TO USE FOR THE INSTRUCTIONS
Step 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 query.
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.
