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.

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,...

Concord Inc. incurred the following infrequent losses during 2023: A $134500 write down of equipment leased to others (net of tax) A $60000 adjustment of accruals on long-term contracts (net of tax)...

1. Calculate the April 30 inventory and the April cost of goods sold using the weighted average cost formula April 30 Invenotry $ April cost of goods sold $ 2. Calculate the April 30 inventory and...

Here is the capital structure of Microsoft. What part of the $ 1 1 7 . 6 7 share price ( to the nearest dollar ) is represented by cash? $ 2 1 $ 1 1 $ 1 7

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Imagine that the U.S. Congress, recognizing the importance of being well dressed, started giving preferential tax treatment to clothing insurance. Under this new type of insurance, you would pay the...

Find some information on an index fund (such as the Vanguard Total Stock Market Index, ticker symbol VTSMX). How has this fund performed compared with other stock mutual funds over the past 5 or 10...

According to an old myth, Native Americans sold the island of Manhattan about 400 years ago for $24. If they had invested this amount at an interest rate of 7 percent per year, how much would they...