Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

! Required information Problem 4-8 and Problem 4-9 [LO 4-2] [The following information applies to the questions displayed below.) Use the Access_Practice.accdb database to complete

image text in transcribedimage text in transcribed

image text in transcribed

! Required information Problem 4-8 and Problem 4-9 [LO 4-2] [The following information applies to the questions displayed below.) Use the Access_Practice.accdb database to complete the following tasks in Access. Microsoft Access is required for this problem. Use the database to complete tasks a through g in Access. Answer the questions below after completing tasks d, e, and g, respectively. Problem 4-8 (LO 4-2] a. The database contains three tables containing information about this company's sales process: Inventory, Sales, and Salesltems. 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, and UnitPrice in the query. Name the query Item_Extension_Calculation. c. Calculate the total dollar amount of each sale. Include InvoicelD, InvoiceDate, Customerld, 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 Invoice 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. Required: d. What are the values for sales that were calculated for the following inventory items? e. What is the value of total sales from the query? g. Which month had the highest sum of sales? What specifically was the sales amount? Complete this question by entering your answers in the tabs below. Required D Required E Required G d. What are the values for sales that were calculated for the following inventory items? (Input your answers exactly as they appear in Access, with 2 decimals when required.) New Guinea Chamomile Blossom Tanzania Moshi Chocolate Raspberry (Inventory ID 1127) Required: d. What are the values for sales that were calculated for the following inventory items? e. What is the value of total sales from the query? g. Which month had the highest sum of sales? What specifically was the sales amount? Complete this question by entering your answers in the tabs below. Required D Required E Required G e. What is the value of total sales from the query? (Input your answers exactly as they appear in Access, with 2 decimals when required.) Total sales Required: d. What are the values for sales that were calculated for the following inventory items? e. What is the value of total sales from the query? g. Which month had the highest sum of sales? What specifically was the sales amount? Complete this question by entering your answers in the tabs below. Required D Required E Required G g. Which month had the highest sum of sales? What specifically was the sales amount? (Input your answers exactly as they appear in Access, with 2 decimals when required.) had the highest sum of sales, which was Required: d. What are the values for sales that were calculated for the following inventory items? e. What is the value of total sales from the query? g. Which month had the highest sum of sales? What specifically was the sales amount? Complete this question by entering your answers in the tabs below. Required D Required E Required G e. What is the value of total sales from the query? (Input your answers exactly as they appear in Access, with 2 decimals when required.) Total sales Required: d. What are the values for sales that were calculated for the following inventory items? e. What is the value of total sales from the query? g. Which month had the highest sum of sales? What specifically was the sales amount? Complete this question by entering your answers in the tabs below. Required D Required E Required G g. Which month had the highest sum of sales? What specifically was the sales amount? (Input your answers exactly as they appear in Access, with 2 decimals when required.) had the highest sum of sales, which was

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_2

Step: 3

blur-text-image_3

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

Cost Accounting For Managerial Planning Decision Making And Control

Authors: Woody Liao, Andrew Schiff, Stacy Kline

6th Edition

1516551702, 9781516551705

More Books

Students also viewed these Accounting questions

Question

Present main arguments for and against the computer metaphor.

Answered: 1 week ago

Question

How does nonverbal communication express cultural values?

Answered: 1 week ago