Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a . The database contains three tables containing information about this company's sales process: Inventory, Sales, and Salesitems. Use the Relationships window to link the

a. The database contains three tables containing information about this company's sales process: Inventory, Sales, and Salesitems. Use the Relationships window to link the tables together.
b. The Salesitems table records the quantity and price of each item sold on each sale (sales may include more than one item). Calculate the extended amount of sale (call it Amt) for each item (Quantity* UnitPrice). Include InvoicelD, InventoryID, Quantity, anc UnitPrice in the query. Name the query Item_Extension_Calculation.
c. Calculate the total dollar amount of each sale. Include InvoicelD, InvoiceDate, CustomerID, and EmployeelD from the Sales table and the Amt from the Item_Extension_Calculation query. Name the query Sale_Amount_Calculation.
d. Calculate total sales for each inventory item.
e. Calculate total sales.
f. Calculate the month in which each sale occurred. Include InvoicelD and InvoiceDate from the Sales table. Name the query Sales_Months. (Hint: Look for the Month function in the expression builder.)
g. Calculate the sum of sales for each month.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Implementing Ai And Machine Learning For Business Optimization

Authors: Robert K Wiley

1st Edition

B0CPQJW72N, 979-8870675855

More Books

Students also viewed these Databases questions

Question

Prepare each of the ratios and compare them to the benchmark.

Answered: 1 week ago

Question

Describe the controversy over Skinners views of human behavior.

Answered: 1 week ago