Generate reports using query of all high priority orders

Assignment Help Business Management
Reference no: EM131388490

Business Assignment

In this assignment, you will use Microsoft Access to generate reports using query. Please pay attention to every criteria when you do the selection. You can get the full credit only if everything is correct (Both the queries and the results). Please show and only show all the attributes listed in brackets in the same order, missing or unexpected attributes or criteria will cause you lose points. Import the data (DBHW1.xls) into MS Access and answer the following questions:

1. Generate a report showing the [order ID, order date, customer name, and the product subcategory] of all high priority orders shipped by express air in the year of 2011. (Hint: representing date: #3/12/2016#)

2. Generate a report showing the [product category, shipping cost, product container, and sales] for the top 5 largest sales (Hint: rank by sales and then only show the top 5).

3. Generate a report showing the [region, customer segment, profit, and shipment mode] for all furniture (product category) items in the region of "Nunavut".

4. Generate a report showing the total [profits] of technology products (product category) shipped with "critical" and "high" priorities.

5. By using parameter query, generate reports that indicate [sales, profit, customer segment, and product category] for all high priority orders shipped by regular air containing "furniture" and "technology" (product category) with the profit greater than 1000 in home office. (Hint: parameter query for "or": [] or []).

Submission Instructions

1. Make a screen shot (using snipping tool, alt+ctrl+prt sc, etc.) of each query form.
2. Combine all screen shots and reports into a single PDF file and label it "DB1".

Attachment:- Order_Data.rar

Reference no: EM131388490

Questions Cloud

Single entity structure appealing : For new leagues, why is the single entity structure appealing? At some point, do start-up leagues have to move away from this structure?
What proportion of the output is nonconforming : If the process mean is moved to 88 lumens, what proportion of the output is nonconforming? What are your proposals to improve process performance?
Give the answer of muliple choice question : The staring, wide eyes of the Tell Asmar statues are believed to indicate that the figures.Mesopotamian cultures did not include.The largest Neolithic site so far discovered in the ancient Near East is located in modern.Which of the following does a ..
Address some aspect of social media in the workplace : Address some aspect of social media in the workplace. Organize the presentation in a clear, logical manner. Provide between 10-16 total slides. Assume your target audience is familiar with the concept of social media overall.
Generate reports using query of all high priority orders : In this assignment, you will use Microsoft Access to generate reports using query of all high priority orders shipped by express air in the year of 2011. Please pay attention to every criteria when you do the selection.
Estimate the process mean and standard deviation : Construct appropriate control charts and determine stability of the process.- If the process is out of control, assuming remedial actions will be taken, estimate the process mean and standard deviation.
Growth of settled civilization and the first states : What steps in the neolithic revolution led to the growth of settled civilization and the first states (use all sources such as learning resources,modules,lectures, and the web)?
Establish similarity requirements and prediction equation : Establish the similarity requirements and prediction equation for a model to be used in the wind tunnel to study the air velocity, V, around the locomotive.
Films about slavery in the american cinema : Much of the discussion around 12 Years a Slave concerned the rather stunning lack of films about slavery in the American cinema. Was The Birth of a Nation conceived before or after you saw that film, and do you think the film may have opened Ameri..

Reviews

Write a Review

 

Business Management Questions & Answers

  What about the general public?

Were the shareholders of Apple entitled to receive information about the health of Jobs? What about the general public? Of what value is such information? How might the company benefit from the disclosure of such information and how might it suffer? ..

  Humor regarding dilbert comic

CASINO HAS NO SENSE OF HUMOR REGARDING DILBERT COMIC

  How your perspective has changed related to entrepreneurship

Describe how your perspective has changed related to entrepreneurship. What do you think are the main pros and cons of being an entrepreneur?

  Analyze two news events published within past twelve month

From the e-Activity, analyze the two news events published within the past 12 months related to sexual harassment laws for or against lesbian, gay, and bisexual individuals.

  Moisture concentration in the compost pile

Five tons of a mixture consisting of paper and other compostable materials has a moisture content of 7%. The intent is to make a mixture for composting that is 50% moisture. How many tons of water or sludge must be added to the solids to achieve t..

  Overall competitiveness of corporation

How does supply chain management contribute to the overall competitiveness of the corporation? What factors have raised the strategic importance of the supply chain management function?

  What values does the decision demonstrate

What values does the decision demonstrate? Are they consistent with the stated values of your organization? What impact did the decision have on your view of the organization?

  Information about a specific hospital organization

Choose a type of healthcare delivery system to study from the list below. Prepare a 2-3 page paper which includes information about a specific hospital organization within your chosen delivery system

  Compare the tax rule and treatment applicable to corporation

Compare and contrast the tax rules and treatment applicable to corporations and partnerships. Indicate the major way in which the tax treatment affects the shareholders or partners.

  Pivot tables and multi-attribute decision making

Pivot Tables and Multi-Attribute Decision Making - write a report to Buddy's Floor Barn in which you discuss and analyze the data, and make appropriate recommendations relative to how Buddy's Floor Barn should improve its sales performance going fo..

  What are the cost savings to each party

If the parties swap their currency proceeds, with Dell paying 8.75% to Virgin for pounds and Virgin paying 7.75% to Dell for dollars, what are the cost savings to each party?

  Different of the central bank

Following on the previous question how would China experience be different of the central bank allowed the yuan to float against the US. What would be the implications for china export to the US. For china import from the US?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd