Retrieve the samps in-chapter database in microsoft access


Retrieve the S&S In-Chapter Database (in Microsoft Access format) from the text's Web site (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.

* a. How many different 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 most frequently?

Can you please send me a copy of the actual database file you used to get your screen shots from.

Request for Solution File

Ask an Expert for Answer!!
Accounting Basics: Retrieve the samps in-chapter database in microsoft access
Reference No:- TGS0659275

Expected delivery within 24 Hours