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
|
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..
|