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

Attachments
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.

IPOs

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.

View More Free Quizzes
Related BrainMass Solutions

  • Using a semicolon (;) in MS Access

    132585 Queries in Access I notice when writing queries that Access will add in a semicolon at the end of my query. Its just one of those Access things right? We don't have to remember to write the semicolon, as Access adds it in for us correct.

  • This post addresses access database and queries.

    The majority of experience I have in using queries is actually using queries through the query wizard in Access. This process greatly simplifies the task of writing queries.

  • Benefits of Views in Databases

    In the case of multiple concurrent queries, views can be used to represent overlapped queries.

  • Access Database Search Form with Queries

    568046 Access Database Search Form with Queries Create a query in Access.

  • Management Information Systems - Sequential and Direct Access Files

    360900 Sequential and Direct Access Files Describe the differences between sequential access files and direct access files. 356 words with references. The response addresses the queries posted in 356 words with references.

  • Design a problem using Microsoft Access: relationships and queries in the database

    373942 Design a problem using Microsoft Access: relationships and queries in the database I need a problem that could be solved by creating a database in Access and then creating relationships and running queries in that database.

  • Median Finding Algorithm for Joint Databases

    However, the only way you can access these values is through queries to the databases. In a single query you can specify a value k to one of the two databases and the chose database will return the k-th smallest value that it contains.

  • ACCESS 2000

    Copy it into the SQL view of a new query to run it: To get into a query's "SQL view" in Access: 1. Start at the queries TAB (as opposed to the TABLES, REPORTS, FORMS, or MACRO tabs) 2.

  • Creating a Database with Specific Queries

    The Access Db will be part of the answer 2) The queries that you wrote. a) The names of all widget managers who also work on widgets in other departments.

View More Related Solutions