Question: This is in Microsoft Access Use the data in tblReservations and tblGuests to create a query that calculates the guests total room charges. Your query

This is in Microsoft Access

Use the data in tblReservations and tblGuests to create a query that calculates the guests

total room charges. Your query results should display GuestFirstName, GuestLastName,

ReservationID, CheckInDate, NightsStay, RoomRate, DiscountType, and a calculated field

named TotalRoomCharges in that order. Subtract any discount from the total charges. In

addition to the discount data in the database, AARP and AAA members receive a 10%

discount. Military personnel receive a 20% discount. Guests without a discount should still

have their total room charges calculated.

This is in Microsoft Access Use the data in tblReservations and

? ?Insert Columns Property Sheet ?Insert Rows Delete Columns Through Totals Parametors Builder Return: A Query Setup Show/Hide qryTotalRoom/Charges Guest? GuestlastName GurstsirstNiame Guestib ChecklnDte RoomType Value DiscountType tbkiuests

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

This is in Microsoft Access Use the data in tblReservations and tblGuests to create a query that calculates the guests total room charges. Your query results should display GuestFirstName,...

In MS Access: Use the data in tblReservations and tblGuests to create a query to see what months discounts were given for AAA. Management is curious if there is a seasonal pattern. Your query results...

This is one of my questions in Microsoft Access Use the data in tblReservations and tblRoomCharges to create a query that calculates the attendants gratuity on a room service order (18%) or spa...

This is from one of my assignments in Microsoft Access Use the data in tblReservations and tblRoomCharges to create a query that calculates the attendants gratuity on a room service order (18%) or...

6 Open the Relationships window and add the table tblPayments. Create a one - to - many relationship between GuestID in the tblGuest and GuestID in the tblPayments. Enforce referential integrity . 3...

\begin{tabular}{|c|c|c|} \hline Step & Instructions & \begin{tabular}{l} Points \\ Possible \end{tabular} \\ \hline 6 & \begin{tabular}{l} Open the Relationships window and add the table tblPayments....

Use the data in tblReservations and tblGuests to create a Top Values query that displays the 11 highest room rates being charged to guests who have made a reservation. The query results should...

This is in Microsoft Access. Use the data in tblReservations, tblPayments, and qryTotalRoomCharges to create a query to see what the total charges will be for each guest. Your query results should...

ACCESS 2013 need help completing assignment step by step YO16_AC_BU02_GRADER_PS1_HW - Hotel Reservations Project Description: A database has been started to keep track of the hotel reservations with...

Use the data in tblReservations, tblPayments, and qryTotalRoomCharges to create a query to see what the total charges will be for each guest. Your query results should display ReservationID,...

how do you believe a project manager should decided that one estimate is better than another when scheduling project work if you were the project manager in this case study, which estimate would you...

Each of these items must be considered in preparing a statement of cash flows for Kiner Co. for the year ended December 31, 2011. For each item, state how it should be shown in the statement of cash...

Assume EvcoEvco , Inc . , has a current stock price of $ 4 0 . 2 4 4 0 . 2 4 and will pay a $ 2 . 2 5 2 . 2 5 dividend in one year; its equity cost of capital is 1 4 % 1 4 % . What price must you...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

In Visual Studio 2017 with an open OLAP Cube, what is the connection to an advanced OLAP viewer?

What is the main benefit of the multidimensional framework of OLAP Cubes?

Provide an example of how the sort level Unspecified can be excluded from the Gender Dimension in a Pivot Table worksheet genderwaggap01.