Determining the Historical Sales of Each Product 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 Salestable provides sales (in number of units sold) by date and retail outlet — you should estimate sales volume using this data ?

Answer rating: 100% (QA)

Solution To determine the historical sales of each product you need to join the Products table and t... View the full answer