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...
icon
Related questions
Question
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
Transcribed Image Text: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
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.