Overview: Using the Northwind.accdb database, you will do a database query as specified below and then...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Overview: Using the Northwind.accdb database, you will do a database query as specified below and then download the results into an Excel Spreadsheet. From there, you will be asked to conduct some analysis and formatting of the resulting spreadsheet. Step 1: Extract Data from Northwind Database: Open the Northwind DB and then click on "Create", "Query Wizard"; then “Simple Query Wizard" to specific the following data query: Field Name Table CustomerID Customers CompanyName Country OrderID Orders EmployeelD OrderDate RequiredDate ShippedDate ShipVia ProductID Order Details UnitPrice Quantity Discount CompanyName Shippers ProductName Products CategoryName Categories Step 2: Export Query to Excel Spreadsheet: Click on "Extermal Data" and then click on the Excel Export Icon. Note: name your spreadsheet with First Name initial followed by your Last Name. Thus, your Profs spreadsheet would be named TKayworth.xlsx. You will tum the spreadsheet in as part of the assignment Step 3: Format the Spreadsheet Overview: Using the Northwind.accdb database, you will do a database query as specified below and then download the results into an Excel Spreadsheet. From there, you will be asked to conduct some analysis and formatting of the resulting spreadsheet. Step 1: Extract Data from Northwind Database: Open the Northwind DB and then click on "Create", "Query Wizard"; then “Simple Query Wizard" to specific the following data query: Field Name Table CustomerID Customers CompanyName Country OrderID Orders EmployeelD OrderDate RequiredDate ShippedDate ShipVia ProductID Order Details UnitPrice Quantity Discount CompanyName Shippers ProductName Products CategoryName Categories Step 2: Export Query to Excel Spreadsheet: Click on "Extermal Data" and then click on the Excel Export Icon. Note: name your spreadsheet with First Name initial followed by your Last Name. Thus, your Profs spreadsheet would be named TKayworth.xlsx. You will tum the spreadsheet in as part of the assignment Step 3: Format the Spreadsheet
Expert Answer:
Answer rating: 100% (QA)
Here are the steps on how to export a query to an Excel spreadsheet Open the query in the SQL Server ... View the full answer
Related Book For
Introduction to Operations Research
ISBN: 978-1259162985
10th edition
Authors: Frederick S. Hillier, Gerald J. Lieberman
Posted Date:
Students also viewed these accounting questions
-
The Audiofile Company produces boomboxes. However, management has decided to subcontract out the production of the speakers needed for the boomboxes. Three vendors are available to supply the...
-
Adelie Enterprises (from Problem 9) has decided to drop the International Supplier from consideration. Further-more, Adelie has decided to order boxes in lots of 10,000 in order to optimize the use...
-
Ruth Fanelli has decided to drop her collision insurance because her car is getting old. Her total annual premium is $916, of which $170.60 covers collision insurance. a. What will her annual premium...
-
Bryce owns 200 shares of Basic Company stock that he purchased for $8,000 three years ago. On December 28, 2021, Bryce sold 100 shares of the stock for $2,500. On January 3, 2022, Bryce repurchased...
-
Suppose that X has the uniform distribution on the interval [2, 2] and Y = X6. Show that X and Y are uncorrelated.
-
Lois purchased the following blocks of Westgate Stock: Date _____________________ Shares _________Price June 12, 2013.....................1,000 ...............$4.225 October 21,...
-
A washing machine of mass \(50 \mathrm{~kg}\) operates at \(1200 \mathrm{rpm}\). Find the maximum stiffness of an isolator that provides 75 percent isolation. Assume that the damping ratio of the...
-
On January 1, Tellier Corporation had 60,000 shares of no-par common stock issued and outstanding. The stock has a stated value of $4 per share. During the year, the following transactions occurred....
-
(a) In a vacuum, if a certain ultraviolet photon has 6 times the energy of a green photon, what is the ultraviolet photon's speed relative to that of the green photon? (b) In a vacuum, what is the...
-
Reconsider Problem 9.3. Suppose now that the demand at each of the destinations has been reduced by 10, so that the new demands are 20, 30, and 20 at destinations 1, 2, and 3, respectively. Introduce...
-
You have 300 liras to spend on both capital and labour to produce a given output. Capital (K) and labour (L) are the only inputs. The price of capital is 1 lira per unit, the price of labour is 1...
-
You just deposited $35 in quarters and dimes. If you have the same number of quarters as dimes, how many coins total do you have?
-
There is a raffle for a 5970 prize, Out of 1,000 tickets, one ticket will win the prize, and the other tickcts will win nothing. If you have a ticket, what is the expected payoff?
-
Pam plans to make a square fence around a vacant lot. The perimeter of the fence should be at least 52 feet. What should be the measure of each side of the fence?
-
Alexis bought x boxes of cereal for $3 each, including tax, and paid with a $20 bill. Which expression represents the total amount of change she should receive?
-
The marching band is selling candy bars and fruit snacks for a fundraiser. Candy bars are sold for $2.50 and fruit snacks are $1.50. A total of 650 items were sold, bringing in $1,195. How many candy...
-
Find the profit function P ( x ) determined by the given cost and revenue functions. R ( x ) = 22 x C ( x ) = 14 x + 52
-
Why is inventory management important for merchandising and manufacturing firms and what are the main tradeoffs for firms in managing their inventory?
-
Reconsider the Goferbroke Co. prototype example, including the application of utilities in Sec. 16.6. The owner now has decided that, given the companys precarious financial situation, he needs to...
-
Find the reliability of the structure function given in Prob. 25.1-1 when each component has probability pi of performing successfully and the components are independent.
-
Speedy Wheels is a wholesale distributor of bicycles. Its Inventory Manager, Ricky Sapolo, is currently reviewing the inventory policy for one popular model that is selling at the rate of 500 per...
-
What services does an underwriter provide for a company that employs the underwriter to facilitate going public? What factors influence an issuing firms choice of underwriter?
-
From the perspective of the entrepreneur, what are the pros and cons of an IPO as opposed to private sale of the venture to a public company in exchange for stock or cash?
-
Describe the process of going public using an IPO, starting with underwriter selection and proceeding through the various stages that lead to determination of an issue price.
Study smarter with the SolutionInn App