Task:Create queries in Design View in ACCESS to answer the following questions. Name and SAVE the queries as Query 1, 2, 3 etc in your ACCESS database (Datafile:Hotel database in the ACCESS).

Query 1: List all room information, in the ascending order of room price .

Query 2: Find rooms costing more than $90, and list the hotel number, room number, room type , and room price in the ascending order of room price.

Query 3: Find the average room price and minimum room price of each hotel. List the hotel number, the average price, and the minimum price.

Query 4: Find and list the total count of rooms by hotel. List the hotel number, hotel name , and the total count of rooms.  

Query 5: Find the average price of double rooms for each hotel. List the hotel number, hotel name and the average price.

• 1500650088-Hotel_database.accdb

APlusGrades

Not Rated (0)

Status NEW Posted 21 Jul 2017 03:07 PM My Price 12.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â-----------  -----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m Â----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I

Not Rated(0)

• Buy Answer