How much were sold by each product in year 2001

Assignment Help Operation Management

Reference no: EM131950085

1. On the table, SalesOrderHeader, provide the grand total of SubTotal at the bottom row of the records. You may need to convert the Short Text into Numeric data attribute for the SubTotal.

2. Set a validation rule on the table SalesOrderHeader such that OrderDate should be earlier than ShipDate and provide an error message when the rule is not kept during the data entry on the OrderDate and ShipDate.

3. Set up a table-based Lookup table for the data field ProductCategoryID of the table ProductSubcategory, that displays the names for the product categories in the table ProductCategory, instead of the numbers.

4. Using the table SalesOrderHeader, set up a query, SalesQ4_query, that displays SalesOrderID, OrderDate, TotalDue, for the orders made in the fourth quarter of year 2001, that is, from Octerber 1st till December 31st, 2001.

5. We want to know how much were sold by each product in year 2001. Set up a query, SalesByProduct_query, that displays ProductID, Name of the Product, and sum of LineTotal of SalesOrderDetail in the year 2001.

6. Close the SalesByProduct_query from the right side window. In the All Access Objects window, create a new query, SalesByProductWithNoSale_query, by Right-clicking on the SalesByProduct_query, copying, pasting, and renaming. Using Left Join or Right Join, modify the SalesByProductWithNoSale_query, that displays all the products that includes the not-sold products too.

7. Table SalesOrderHeader is set in an inconvenient way because it requires to enter SubTotal, TaxAmt, Freight, and TotalDue individually. These data fields can be readily calculated if we set up a query. Create a query, SalesOrderHeader_extension that displays SalesOrderID, SubTotal (sum of LineTotal of SalesOrderDetail), TaxAmt (8% of LineTotal), Freght (3% of LineTotal), and TotalDue (111% of LineTotal) in Currency format.

8. Using OrderedItems query, set up a crosstab, SaleByCustomerAndProductCategory_crosstab that displays sum of sale amount ([UnitPrice]*[OrderQty]) by each customer and each product category, with the SaleTotal (SaleTotal: [UnitPrice]*[OrderQty]) per customer.

Reference no: EM131950085

Questions Cloud

Discuss why genre works for the type of story being told : Identify genre for each film and discuss why this genre works for the type of story being told. Could some other genre worked better?

Select areal estate-related career and do research on it : Select areal estate-related career and do research on it.If you are currently in the real estate industry, select a career that is different from your own job.

Write the paper on a racial or ethnic group of choice : Demonstrate the mastery of appropriate concepts and sociological perspectives as articulated in Martin Margers textbook

What is the price of the stock today : A stock is expected to pay a dividend of 0.50 in one quarter, and stock's expected price in one quarter is 15.00. The equity cost of capital is 6 percent per

How much were sold by each product in year 2001 : On the table, SalesOrderHeader, provide the grand total of SubTotal at the bottom row of the records.

Should the fda regulate prescription drug importation : Should the FDA regulate prescription drug importation? Why or Why not? Take a side and remember to be specific in supporting your position.

What is the leadership paradox : Present a discussion of the strategies for encouraging participative management in the workforce, and how to implement each of these strategies.

What have you found to support your hypothesis : Analyze your data. Concisely discuss and analyze your data. What have you found to support (or refute) your hypothesis?

How did administration turn so thoroughly evil : How did administration turn so thoroughly evil? How could administrators deal with these questions so calmly?

User Account

All Pages