ASG 3C - Managing reservation through Excel

Instruction

1. On the 'Room Reservation' sheet, add the following booking information (Record #8):

    • Guest ID = 1
    • Check-in = 5 Jul 09
    • Check-out = 6 Jul 09
    • No. of adult guests = 1
    • No. of children = 0 
    • Room number = 711

2. Check if the reservation shows up correctly on the 'Availability' sheet.

3. Add yourself as the guest ID =2 on the 'Guests' sheet and make a reservation on any date(s)/room (Record #9).

4. Listen to the following dialogue and make a reservation accordingly (Record #10). Do not assign a guest number this time.

 

 

5. Save and upload the finished Excel Workbook in the .xls format (do not change the file format).