Question: 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

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

Use the query feature in Microsoft Access to join the tables and calculate aggregate sales for each product. Do not worry about the location

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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...

Scenario: You are an associate manager at Kalmar , a large Scandinavian retail store specializing in products for the workplace. Kalmar is going to put all of the items in the store on sale. You have...

Scenario: You are an associate manager at Vensel, a large Scandinavian retail store specializing in products for the workplace. Vensel is going to put all of the items in the store on sale. You have...

The Sales table provides the sales quantity ( in number of units sold ) by date and retail outlet you should estimate sales volume using this data. Use the query feature in Access to join the tables...

database management system, pdf is attached COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI...

database management system COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI AHMI DR. MOHD...

Database Management System - Require use of Word, Powerpoint and Access C. After the presentation about the functionalities and advantages of using DBMS to manage customer information data in the...

QUESTIDN 1 (3n MAKES.) A. The following diagram shows a table structure for a Project Management data. _u _u _u Iaa- Iaa- m m - - REQUIRED: (a) Discuss TWO [2) types of anomalies exhibited in the...

Aylmer Inc has a December 31, 2022 year end. Aylmer does not perform monthly adjusting entries. The following items relate to transactions that occurred during the year. 1 On August 1, Aylmer paid...

To find the future value of an annuity due, you multiply the future value of an ordinary annuity by the sum of 1 + the period interest rate. Explain why this is the same as adding the simple interest...

6. A sound wave has a frequency of 1020 Hz. The speed of sound in air is 340 m/s. What is the wavelength of the sound wave in metres? (a) 0.33 (b) 3.0 (c) 1 360 (d) 347 000

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

5. To determine the financial benefits and costs of the program.

7. To compare the costs and benefits of different training programs to choose the best program.

4. To assist in marketing programs through the collection of information from participants about whether they would recommend the program to others, why they attended the program, and their level of...