Use the query feature in Microsoft Access to join the tables and calculate aggregate sales for each product. Do not worry about the location of the salesyou are interested in total sales only. You are running the sale from the start of January to the end of March. Given the seasonality of some of the products, you should look only at sales in the same time frame. Moreover, since decorating trends come and go, you should consider only the last two most recent years sales only for the selected season (January to March). The query should join the necessary tables and apply criteria to limit the results to those required for subsequent contribution analysis. Hint: Create the required relationships first

PRODUCTS PRODUCTS PRODUCT_ID ITEM HEIGHT WIDTH DEPTH PRICE GROSS MARGIN- SALES 42 $313.99 41 $107.99 62 $107.99 68 $374.99 82 $86.99 39 $86.99 115 $400.99 41 $183.99 43 $172.99 63 $248.99 58 $10.99 46 $215.99 76 $139.99 38 $96.99 100-10 100-15 100-20 100-25 100-30 100-35 100-40 100-45 100-50 100-55 100-60 100-65 100-70 100-75 200-10 200-15 200-20 200-25 200-30 200-35 200-40 200-45 200-50 200-55 200-60 200-65 200-70 200-75 LINGO sideboard CIRKEL sideboard GUSTAV coffee table GOLIAT desk with shelf unit SIGURD coffee table ISALA cabinet LIATORP conference table FREDRIK sofa table HEMNES occational table SMYCKA desk with shelf unit LACK side table MURBO cabinet BISLEV desk KLINGSBO laptop table MICKE visitor chair JONAS bench YVRSNO chair REKTANGEL swivel chair EXPEDIT swivel chair FLORERA chair LYCKHEM armchair KILBY armchair CARMONA visitor chair SKUARE swivel chair DOKUMANT bench VOLMAR chair MOSES stool GRONO visitor chair 61.00% 39.00% 61.00% 49.00% 22.00% 59.00% 44.00% 63.00% 45.00% 66.00% 48.00% 70.00% 46.00% 59.00% 36.00% 61.00% 53.00% 21.00% 37.00% 58.00% 63.00% 52.00% 63.00% 35.00% 72.00% 32.00% 70.00% 26.00% 156 158 192 137 127 108 60 127 137 $97.99 52 $75.99 78 $324.99 58 $107.99 73 $107.99 89 $64.99 58 $215.99 84 148 37 $107.99 99 $172.99 Record: 1 of 74 No Filter