Retrieve the samps in-chapter database in microsoft access

Reference no: EM13590915

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?

Reference no: EM13590915

Questions Cloud

On october 1 2012 joy co issued 500 five-year bonds with a : on october 1 2012 joy co. issued 500 five-year bonds with a face value of 1000 each and a stated interest rate of 6

Compare the advantages and disadvantages of the previous : panarude airfreightis an international air freight hauler with more than 45 jet aircraft operating in the united states

Blance per books at october 31 4184785 receipts 17352391 : balance per books at october 31 41847.85 receipts 173523.91 disbursements 164893.54. balance per bank statement

A company increased the selling price for its product from : a company increased the selling price for its product from 5 to 6 per unit when total fixed expenses increased from

Retrieve the samps in-chapter database in microsoft access : retrieve the samps in-chapter database in microsoft access format from the texts web site or create the tables in table

Brislin corporation is issuing 181720 of 5 5-year bonds : brislin corporation is issuing 181720 of 5 5-year bonds when potential bond investors want a return of 16. interest is

His partner tina mass 500 kg stands on an elevated platform : question in a circus act marcello mass 70.0 kg is shot from a cannon with a muzzle velocity of 24.0 ms at an angle of

What would happen with the price you computed above if : airjet best parts inc. is concerned regarding recent changes in its stock prices for the company and would like to

A river flows from south to north at 50 kmh on this river a : question a river flows from south to north at 5.0 kmh. on this river a boat is heading east to west perpendicular to

User Account

All Pages