Import the hotel rooms from the downloaded text file a01 grader_a1_Rooms.csv, appending it to tblRooms. Ensure that Delimited, Comma, and First Row Contains Field Names are selected. Do not save the import steps. Open the Relationships window. Add tblGuests, tblReservations, and tblRooms. Create a one- to-many relationship between GuestID in tblGuests and GuestID in tblReservations. Enforce referential integrity. Do not cascade update or cascade delete. Create a one-to-many relationship between RoomNumber in tblRooms and RoomNumber in tblReservations. Enforce referential integrity. Do not cascade update or cascade delete. Save the changes. Create a relationship report. Save the report as Relationships for a01_grader_al and then close the report and the Relationships window. Use the Simple Query Wizard to create a query. The query results should list GuestID, GuestFirstName, GuestMiddleInital, GuestLastName, CheckInDate, NightsStay, and RoomType (in that order). Save your query as qryMyReservations and then run the query. In Design view, enter criteria to select the guest with GuestID = 25. Sort in ascending order by CheckInDate. Run and then save the query. Close the query. Create a report using the Report Wizard. Add ReservationID, CheckInDate, NightsStay, and RoomType (in that order). View by tblRooms. Sort by CheckInDate and Reservation ID in ascending order (in that order). Accept all other defaults. Name your report rptReservations and then finish the wizard. View the report in Layout view. Modify the report title to be Reservations Report. Save and then close the report. I Close the database, and submit as directed. ansan 12-201 ESTAMTHI FORDENS MEN ENIKMA BE380T 267 760 5-10-2 SAMME 100002 FUN EP 152 POPOSRE PARINTE GERONNE amea SERIOUS PERSEREND DENISE BATEGE PEN 97167 (CRPO) CORONARDO (OP! EEROONI. SHE APPARICHE AGREEM HIPHPRERNOS MIMPINGE VARENNER! PARAMAY HEPHINE TOMBOANSION ANCIARE SOMMER HEARICING MEKA IMPLURDISH PURBARSIZE FAUBOCH INTOHISAGRA REMITIRANA ENDRADED TYPOG PORUCEND TURENESS P EDENSUS HANORE 69644 RECONN CAPAVER GELENEREK NESPONS UERE HINCHANTE SOME wor DEN BODERlyit APLETEN SUCCH 2010 5428-2907 2016 ME MET EVENEN QUELLE FORE JELENT RE FREKUND SERNA DE LEONARD 2014 LEOPARD preparer ESHIRE Galaceat EXPERIEN
Import the hotel rooms from the downloaded text file a01 grader_a1_Rooms.csv, appending it to tblRooms. Ensure that Delimited, Comma, and First Row Contains Field Names are selected. Do not save the import steps. Open the Relationships window. Add tblGuests, tblReservations, and tblRooms. Create a one- to-many relationship between GuestID in tblGuests and GuestID in tblReservations. Enforce referential integrity. Do not cascade update or cascade delete. Create a one-to-many relationship between RoomNumber in tblRooms and RoomNumber in tblReservations. Enforce referential integrity. Do not cascade update or cascade delete. Save the changes. Create a relationship report. Save the report as Relationships for a01_grader_al and then close the report and the Relationships window. Use the Simple Query Wizard to create a query. The query results should list GuestID, GuestFirstName, GuestMiddleInital, GuestLastName, CheckInDate, NightsStay, and RoomType (in that order). Save your query as qryMyReservations and then run the query. In Design view, enter criteria to select the guest with GuestID = 25. Sort in ascending order by CheckInDate. Run and then save the query. Close the query. Create a report using the Report Wizard. Add ReservationID, CheckInDate, NightsStay, and RoomType (in that order). View by tblRooms. Sort by CheckInDate and Reservation ID in ascending order (in that order). Accept all other defaults. Name your report rptReservations and then finish the wizard. View the report in Layout view. Modify the report title to be Reservations Report. Save and then close the report. I Close the database, and submit as directed. ansan 12-201 ESTAMTHI FORDENS MEN ENIKMA BE380T 267 760 5-10-2 SAMME 100002 FUN EP 152 POPOSRE PARINTE GERONNE amea SERIOUS PERSEREND DENISE BATEGE PEN 97167 (CRPO) CORONARDO (OP! EEROONI. SHE APPARICHE AGREEM HIPHPRERNOS MIMPINGE VARENNER! PARAMAY HEPHINE TOMBOANSION ANCIARE SOMMER HEARICING MEKA IMPLURDISH PURBARSIZE FAUBOCH INTOHISAGRA REMITIRANA ENDRADED TYPOG PORUCEND TURENESS P EDENSUS HANORE 69644 RECONN CAPAVER GELENEREK NESPONS UERE HINCHANTE SOME wor DEN BODERlyit APLETEN SUCCH 2010 5428-2907 2016 ME MET EVENEN QUELLE FORE JELENT RE FREKUND SERNA DE LEONARD 2014 LEOPARD preparer ESHIRE Galaceat EXPERIEN
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.