The following table is part of the database of a small town hotel. Use VBA to fi

Question

The following table is part of the database of a small town hotel. Use VBA to find
the following:
a. The InDate and OutDate of customer Regina Murphy using the VLOOKUP
function.
b. Name the table as Reservations.
c. Highlight the third row of the table using the Rows property.
d. Highlight the information about the fines paid using the Columns property.

BookingId FirstName LastName InDate OutDate RoomType RoomNo Fines TotalAmt 1 Shelley Burke 2/5/2003 2/15/2003 1 101 $1.00 $301.00 2 Regina Murphy 4/5/2003 4/10/2003 3 301 $2.00 $602.00 3 Laul Roundhead 4/14/2003 4/17/2003 4 401 $3.00 $1,128.00 4 Cheryl Saylor 4/20/2003 4/25/2003 3 303 $4.00 $604.00 5 Robb Merchant 5/5/2003 5/8/2003 2 202 $0.00 $450.00 6 Renet Leverling 5/10/2003 5/13/2003 2 203 $0.00 $450.00 7 Laura Callahan 6/7/2003 6/17/2003 1 103 $25.00 $325.00 8 Chantal Goulet 6/7/2003 6/18/2003 2 203 $5.00 $455.00 9 Irma Nertia 7/3/2003 7/13/2003 2 205 $6.00 $456.00

Explanation / Answer

The InDate and OutDate of customer Regina Murphy using the VLOOKUP
function.

Regina 4/14/2003 4/17/2003

3 303 $4.00 $604.00

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---