Question: Using the Northwind Database in Microsoft Access (search for template when opening Access) (please show how to create queries in the design view) Create following

Using the Northwind Database in Microsoft Access (search for template when opening Access) (please show how to create queries in the design view)

Create following queries:

1. We want to to contact all customers who have not paid for their orders. Using the Customers and Orders tables, display all customers who have not paid for their orders. Display the Company Name, First and Last Name, Business Phone and Order ID

2. What are the best and worst selling products overall? Use the Order Detail and Product Tables Display the Product Name and Total Quantity. Show best selling products first. Products should not repeat. Each product should have a total quantity.

3. What are the best selling product in the month of February (in terms of quantity sold)? Use the Order and Order Detail tables. Display product name and quantity sold.

4. What month showed highest sales of 'Northwind Traders Chocolate' Use the Order, Order Detail and Product tables. Display Month Name, product name and quantity sold.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Using the tables Orders and Order Details from the Northwind Database in Microsoft Access (search for template when opening Access) (please show how to create queries in the design view). 1) For each...

database management system, pdf is attached COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI...

database management system COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI AHMI DR. MOHD...

Question 4 (25 marks) Case: Fitness Centre Access Management Database The developer for the Access Management System has decided to create a database to capture the required data using Microsoft...

Ais: Requires MS Access 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...

Intro to Database Management Project 3 Start Assignment Due Thursday by 11:59pm Points 100 Submitting a file upload File Types vsdx, pdf, xlsx, and docx Attempts 0 Allowed Attempts 3 Available Dec 6...

AIS: Requires MS Access 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...

The answer to this problem is solved on chegg, in Ais 14th Edition (chapter 4 problems). However it's solved with 4 tables. Someone solve this problem with 3 tables not 4 tables. Retrieve the S&S...

CASE ONE The Counselors Group (CG), a renowned Counseling service in Ghana manages their clients meetings based only on appointment. To book an appointment, the clients are required to place phone...

PROJ ECT/ASSIG N M ENT ACTIVITY Instructions for; Assessor The Learner must demonstrate the ability to complete the tasks outlined in the elements, performance criteria and foundation skills of this...

Prepare a Cash Receipts budget for July - October DC's Projected Revenues & Expenses Sales Cost of Goods Sold Gross Profit Admin & Selling Costs Net Income before Taxes June 85,000 52,700 32,300...

A number of years ago, your client invested $6000 at a rate of return of 9% compounded annually. If the investment is currently worth $10,968.25, for how long has she held the investment? (Taken from...

Question 1 3 1 pts A finding that would provide evidence against the semistrong form of the efficientmarket theory. one can consistently outperform the market by investing in open - end mutual funds...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

2. What, according to Sergey, was strange at this meeting?

3. Are our bosses always right? If not, what should we do?

4. Do you have power relative to this person? Why or why not? Do you need or want more power in this case? If yes, then what are some of the ways in which you might increase your influence and power?