Question
Access 2016 I have these tables I wnat to make QUERIES: Query 2: Based on the Inventory table, what is the gross profit per pound
Access 2016
I have these tables
I wnat to make QUERIES:
Query 2: Based on the Inventory table, what is the gross profit per pound per product?
Query 3: How many customers does the company have per state.
Query 4: Count the number of sales and total dollar sales for every salesperson.
Query 5: Which two Employees have generated the most sales for February?
Query 6: What is the total Quantity sold in pounds for every product and what is the remaining inventory balance on hand also in in pounds
Query 7. What are the total sales per state for the month of February?
---
what are the steps?
Customer Employee Inventory Sales Customer Number Customer_Name Address Employee Number Last_Name First Name Hire Date Status Invoice Number description Unit Cost Unit Price Quantity on Hand SDate Employee Number Customer Number Amount State Credit Limit Sales_Inventory Invoice Number Item Number QuantityStep 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