AIS QUESTION:

REQUIRES MS ACCESS

this isn't a very complex problem, however im not familiar with microsoft access, so i would like help. Thank you to anyone who can solve this!

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. a. How many different kinds of inventory items does S&S sell? b. How many sales were made during October? TABLE 4-15 Problem 4.5 Tables m . Customer Name City State 0 Jones 1000 Lankford Salt Lake City UT 1005 Pagal 1007 Arocha - Description Unit Price - Cost- $1000 $12.00 1015 Toaster $15.95 $ $499.00 $9.00 S . 1035 Refrigerator 1040 Radio 1045 Clock $999. ss S . SSS $99.95 $45.00 no Customer Number - 301 102 104 105 106 Date Salesperson / Wilson 10/5/2018 Mahomet // con 10/15/2018 Drecen IV 2018 Martinez 10 /20 Martinez 10/25/2018 Mahomet 11/3/2018 Martine 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? 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 que ries-one to calculate a total and the second to answer the question asked. a. Which customers (show their names) made purchases from Martinez? b. Who has the largest credit limit? c. How many sales were made in October? d. What were the item numbers, price, and quantity of each item sold on in voice num- ber 103? e. How much did each salesperson sell? f. How many customers live in Arizona? g. How much credit does each customer still have available