Purchase Solution

Queries in Access

Not what you're looking for?

Ask Custom Question

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

Purchase this Solution

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.

Solution Preview

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

Purchase this Solution

Free BrainMass Quizzes
Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.


This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.