You will modify the Rounded Item Prices query to round retail values for items in the inventory. Open the Rounded Item Prices query in Design view. Create a new column to round the Retail price of each item to the nearest dollar. Name the field Rounded Retail, Save the query. Create a new column to display Premium for all items that have a Rounded Retail value of $35 or more and Standard for items that are less than $35. Name the field Class. Run the query. Save and close the query. 

You will also create a query to display employees who are in line for a performance review Open the Overdue Employee Reviews query in Design View. Add a new column to determine If an employee's performance review is overdue. If the employee's Date of last Review is null, it should display Overdue. If not, it should display nothing. Name the column Review status. 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 Date of last Review display. Save and close the query.

You will modify an existing query displaying daily totals to instead display monthly totals. Open the Order Totals By Month query in Design View Change the first column so that instead of grouping by the order date, you group by the month. use the Date Part function to extract the month from the date. Name the column Month number Run the query. The first line should read 5 (as the month, representing May with a total of $658.72 Save and close.

 

1 SKU ItemNam: ItemTypelD InventoryQty Retail RoundedRetail: Roun Premium: [Premium] Field: Retail Table: Inventory Sort: Show: Criteria: or