Database Queries - With Microsoft Access
Create and execute queries that will answer the following questions. You may use the graphical design view of Access to write your queries for this assignment. Save each of the queries to the database file - using the naming convention of Q1, Q2, Q3 - corresponding to the question number.
1. As a salesperson, you need to get all of the pertinent information for all varnish products before talking with one of your customers. Order the data by product description.
2. You were just given your sales territory (Connecticut) and you need to get a list of all of your customers in that state with all of their vital information.
3. As the newly hired VP of marketing, you need to get a count of customers in each of the states covered by your company. Order the data by State.
4. To understand your most junior employees, you need a list of employees hired after Dec 31st, 2009. You need their full names along with their emails. Order the data by last name.
5. To find out which states provide the most sales, you need to get a total of all sales (inv_total) for each of the states. Order the data by sales in descending sequence.
6. You customer, Ms. Amos, is wanting a list of any water-based interior products you offer along with any pertinent product details.
7. You need to identify your 5 best salespersons for the year 2016 and how much they sold.
8. To reduce the number of vendors that you use, you need to identify which vendor provides the least number of products. Be sure to include any vendors that provide 0 products.
Database Queries - With Microsoft Access
Create a word document to compile a simple to grade solution. Use the naming convention, Q1, Q2, Q3 ... etc. Also, add the following data for each of the above questions (queries):
• Identify the question number
• Copy and paste a screen shot of the design view for your query
• Copy and paste the query results - when more than 10 rows of data are returned from the query - snip only the first 10.
• Separate each solution by some visual delimiter (row of underscores, **, or a line)
Attachment:- Case Study.rar