The collection of items is provided in the Access inventory database (Seger_Inventory) containing two tables: Products and Sales. The Products table contains information about the small subset of Seger products considered to be top candidates for the sale, such as physical dimensions (in centimeters), selling price, and margin. The Product_ID code reflects the category of the inventory item (100 = desks & tables, 200 = chairs, 300 = storage & shelves, 400 = boxes, 500 = lamps, 600 = vases, 700 decoration, 800 = rugs, 900 = beds). The Sales table provides sales (in number of units sold) by date and retail outlet you should estimate sales volume using this data. = . Use the query feature in Microsoft Access to join the tables and calculate aggregate sales for each product. Consider the three represented Lower Mainland areas only (Burnaby, Surrey, and Vancouver) since regional sales volume is very important. The collection of items is provided in the Access inventory database (Seger_Inventory) containing two tables: Products and Sales. The Products table contains information about the small subset of Seger products considered to be top candidates for the sale, such as physical dimensions (in centimeters), selling price, and margin. The Product_ID code reflects the category of the inventory item (100 = desks & tables, 200 = chairs, 300 = storage & shelves, 400 = boxes, 500 = lamps, 600 = vases, 700 decoration, 800 = rugs, 900 = beds). The Sales table provides sales (in number of units sold) by date and retail outlet you should estimate sales volume using this data. = . Use the query feature in Microsoft Access to join the tables and calculate aggregate sales for each product. Consider the three represented Lower Mainland areas only (Burnaby, Surrey, and Vancouver) since regional sales volume is very important