Explore BrainMass

Queries in Access

Write queries to answer the following questions. Note some questions, you may have to create two queries - one to calculate an invoice total and the second to answer the question asked.
a) How many kinds of inventory items does S & S sell?
b) How many sales were made during October?
c) What were total sales in October?
d) What was the average amount of a sales transaction?
e) Which salesperson made the largest sale?
f) How many units of each product were sold?
g) Which product was sold the most?

Please also tell me how you do the screenshots thanks


Solution Preview

Find attached, the Excel spreadsheet with screenshots of queries and the results as asked. In addition, I ...

Solution Summary

The solution does a great job of answering the question. The solution is brief and concise and very easy to follow along. All the steps are clearly shown and formulas are provided so that the student can answer similar questions in the future. It can be easily understood by anyone with a basic understanding of the topic. Overall, an excellent solution.

The attachment contains several access databases with the queries.