1. Use the baseball database you created for this assignment (Note: please copy the Access file and paste, give a name like BaseballLec02). Create Access queries (each question needs a query, please save each query) (a) Display the item id, description, cost, and units on hand of all items supplied by Beverage Holders Display the item id, description, and on-hand value (units on hand*cost) of all items. (b) (c) Display the item id, description, units on hand, and current profit (selling price - cost) of all items that have a selling price greater than S15. 102 Assignment (d) Find the lowest and highest price (e) Display the average selling price of supplier BH's items (f) Find a count of different types of items grouped by suppliers