1. Import a table from the downloaded Access database a01_grader_a1_Guest.accdb selecting the tblGuests table. Do not save the import steps. 2. Create a new table in Design view. This table will store reservations. Add the following fields, data types, and descriptions, in this order. Change field sizes as noted. Field Name Data Type Description Field Size/Format ReservationID AutoNumber A unique identifier for the reservation Long Integer GuestID Number The guest id from tblGuests (foreign key) Long Integer RoomNumber Short Text 30 CheckInDate Date/Time Short Date NightsStay Number Integer NumberOfGuests Number Integer 3. Assign ReservationID as primary key. Save the new table as tblReservations. Close the table. 4. Import the downloaded a01_grader_a1_Reservations.xlsx Excel file, using the tblReservations worksheet and appending it to tblReservations. The Excel column headers match the Access field names so you can use them. Do not save the import steps. 5 Use the Form tool to create a form for tblReservations, and then save the form as frmReservations. 6 6 Enter the following data into the append record in frmReservations. GuestID = 25, RoomNumber = 105, CheckInDate = 4/20/2018, NightsStay = 8, and NumberOfGuests = 1. Close the form. 7. Create a new table in Design view. This table will store information about the hotel rooms. Add the following fields, data types and field sizes in this order: Field Name Data Type Field Size RoomNumber Short Text 10 RoomType Short Text Assign RoomNumber as the primary key. Save the new table as tblRooms. Close the table. 8 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. 9 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. 10 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. 11 Create a relationship report. Save the report as Relationships for a01_grader_a1 and then close the report and the Relationships window. 12 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. 13 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. 14 Create a report using the Report Wizard. Add ReservationID, CheckInDate, NightsStay, and RoomType (in that order). View by tblRooms. Sort by CheckInDate and ReservationID in ascending order (in that order). Accept all other defaults. Name your report rptReservations and then finish the wizard. 15 View the report in Layout view. Modify the report title to be Reservations Report. Save and then close the report.