Retrieve the Samp;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…

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?(Accounting Information Systems, 12th Edition. Pearson Learning Solutions p. 110).