Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Query
Query Result…
…
e. Which salesperson made the largest sale?
Make Table Query
Accounting Information Systems
…..
f. How many units of each product were sold?
Query
4-2
©2018 Pearson Education, Inc.
Accounting Information Systems
Query Result
. Which product was sold most frequently?
Query
4-3
©2018 Pearson Education, Inc.
.Query Result
…
4.5 Enter the tables in Table 4-15 into a relational DBMS package. Write queries to answer the
following questions. Note: For some questions, you may have to create two queries—one to
calculate a total and the second to answer the question asked.
a. Which customers (show their names) made purchases from Martinez?
Query
4-4
©2018 Pearson Education, Inc.
Accounting Information Systems
…
b. Who has the largest credit limit?
Accounting Information Systems
Query Result
..c. How many sales were made in October?
4-6
©2018 Pearson Education, Inc.
Accounting Information Systems
d. What were the item numbers, price, and quantity of each item sold on invoice
number 103?
Query
Query Result
4-7
©2018 Pearson Education, Inc.
Accounting Information Systems
e. How much did each salesperson sell?
Query
…..
f. How many customers live in Arizona?
Query
4-8
©2018 Pearson Education, Inc.
Accounting Information Systems
…. …
Query Result
How much credit does each customer still have available?
Questions g and i require the use of a total customer sales calculation; thus, a customer total sales
table is prepared as a Microsoft “Make Table Query” in Microsoft Office. A Make Table Query is
prepared the same as a normal query except that the user selects the Make Table Query option under
the Query Design menu tab.
Make-Table Query
4-9
©2018 Pearson Education, Inc.
Accounting Information Systems
Table Result
4-10
©2018 Pearson Education, Inc.
