Open the overdue reviews query in design view. add a new column to determine if an employee's performance review is overdue. if the employee's dateoflastreview is null, it should display overdue. if not, it should display nothing. name the column reviewstatus. add criteria of overdue to the column you just created, so only the employees who are overdue display. run the query. ensure only employees with null dateoflastreview display. save and close the query.

Circuittown commenced a gift card program in january 2018 and sold $12,150 of gift cards in january, $19,150 in february, and $18,100 in march of 2018 before discontinuing further gift card sales. during 2018, gift card redemptions were $7,850 for the january gift cards sold, $4,350 for the february cards, and $4,250 for the march cards. circuittown considers gift cards to be “broken” (not redeemable) 10 months after sale. required: 1. how much revenue will circuittown recognize with respect to january gift card sales during 2018? 2. prepare journal entries to record the sale of january gift cards, redemption of gift cards (ignore sales tax), and breakage (expiration) of gift cards. 3. how much revenue will circuittown recognize with respect to march gift card sales during 2018? 4. what liability for deferred revenue associated with gift card sales would circuittown show as of december 31, 2018?