Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you answer through 9B please? Database problem. 8. Use the Access_Practice.accdb database to complete the following tasks in Access. LO 4-2 a. The database
Can you answer through 9B please? Database problem.
8. Use the Access_Practice.accdb database to complete the following tasks in Access. LO 4-2 a. The database contains three tables containing information about this company's link sales process: Inventory, Sales, and Salesltems. Use the Relationships window to the tables together The Salesltems table records the quantity and price of each item sold on each sale (sales it Amt) for each item (Quantity UnitPrice). Include InvoicelD, InventorylD, Quantity. and UnitPrice in the query. Name the query Item Extension Calculation may include more than one item). Calculate the extended amount of sale (call 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 func- tion in the expression builder.) g. Calculate the sum of sales for each month. 9. This problem continues Problem 8. Use the Access Practice.accdb database that you have been working on to complete the following tasks. LO 4-2 a. Go to the Relationships screen and connect the five tables, enforcing referential integrity b. Calculate the total sales for each customer. Include CustomerlD and CompanyName i the calculated sale amount from the Sale_Amount 8. Use the Access_Practice.accdb database to complete the following tasks in Access. LO 4-2 a. The database contains three tables containing information about this company's link sales process: Inventory, Sales, and Salesltems. Use the Relationships window to the tables together The Salesltems table records the quantity and price of each item sold on each sale (sales it Amt) for each item (Quantity UnitPrice). Include InvoicelD, InventorylD, Quantity. and UnitPrice in the query. Name the query Item Extension Calculation may include more than one item). Calculate the extended amount of sale (call 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 func- tion in the expression builder.) g. Calculate the sum of sales for each month. 9. This problem continues Problem 8. Use the Access Practice.accdb database that you have been working on to complete the following tasks. LO 4-2 a. Go to the Relationships screen and connect the five tables, enforcing referential integrity b. Calculate the total sales for each customer. Include CustomerlD and CompanyName i the calculated sale amount from the Sale_Amount
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started