Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
4.4 Retrieve the S&S In-Chapter Database (in Microsoft Access format) from the text’s website
(or create the tables in Table 4-5 in a relational DBMS product). Write queries to answer the
following questions. Note: For some questions, you may have to create two queries—one to
calculate an Invoice Total and the second to answer the question asked.
Answers depend upon the specific DBMS and query language used. Here are suggested answers in QBE
(Query By Example) prepared in Microsoft Access.
a. How many different kinds of inventory items does S&S sell?
Query
Query Result
b. How many sales were made during October?
Query
Query Result
c. What were total sales in October?
Query
Query Result
d. What was the average amount of a sales transaction?
This question requires the use of a total invoice calculation, thus, a total invoice 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 in the Query Type
portion of the Query Design Tools ribbon.
Make Table Query
Table Result
Query
Query Result
e. Which salesperson made the largest sale?
Make Table Query
Query Result
Query
Query Result
f. How many units of each product were sold?
Query
Query Result
g. Which product was sold most frequently?
Query
