Question: I need help CREATING the spreadsheet please and thank you The general manager wants to know which offices were most profitable during the previous year

I need help CREATING the spreadsheet please and thank you

The general manager wants to know which offices were most profitable during the previous year and asks you to prepare several reports. In the file FY2012.mdb, you find information about the offices, sales agents, and destinations. Use the report wizard to generate the following reports:

- List of all sales agents grouped by office (including total number of agents per office)

- List of all sales agents for each destination (grouped by destination, including total number of agents)

- Destinations sold by each sales agent (including total number of destinations)

Hint: You will need to generate the necessary queries before creating the reports.

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 General Management Questions!

6-43. The general manager wants to know which offices were most profitable during the previous year and asks you to prepare several reports. In the file FY2012.mdb, you find information about the...

London School of Science & Technology Qualification Unit number and title BTEC Level 5 HND Diploma Business UNIT 6: Business Decision Making Student name and ID number Assessor name Al Hassan Barrie...

Here is all the Questions of my project, But I need answers only for part 4 Below here I am going to attach the answers for part 1, and 2 so this will help you give answers of part 4 PLEASE ANSWERS...

Here is my Part 1,2, and 3 answers NEED ANSWERS FOR PART-4 ALL QUESTION NEEDED PLEASE, WHICH IS BASED ON PART1,2, and 3 PLEASE ANSWERS ALL QUESTIONS FROM MARKETING STRATEGY TO CONCLUSIONS ON YOUR OWN...

Qustion1. identify what job from duplex copiers you would use for "key job matching". Make the choice from the jobs included in the job evaluation outcomes spreadsheet you have been provided. You...

-Should they geographically expand? if so, where and why? -Should they expand their services? If so, how and why? -Should they target new customers? If so, who and how? -What are the implications of...

A vendor is recommending a program to make supervisors better at 'dealing with difficult conversations' at work. How would you apply the concepts of optimisation and the Kirkpa- trick model to set up...

Find attached Ingredients: Water, MCC, Salt, Nicotine, pH regulator, sweeteners and flavours I am wondering why the decision to go with LYFT. I understand migrating to LYFT would be easier from sells...

Minimum monthly, weekly, and daily productivity levels are strictly specified for each TSS, and there are strict quotas on repair expenses and travel expenses. Prior approval from an FSM is required...

d) You own a put option on a Brambles share with an exercise price of $12. The option will expire in exactly six months' time. i) If the share is trading at $9 in six months, what will be the payoff...

An n-year bond with par value $1,000 has annual coupons of $82. At a price of $891.62, the yield to the purchaser is 10% convertible semiannually. Find n.

9.82 In addition to the sample size n, what population value(s) must be known to find a standardized score for a sample proportion p^ ?

describe in details the risk management plans and assign them for each task in the attached sheet for building a resturant. 1 2 1.1 3 1.2 14 1.3 NO 5 days a 2 - 11 Selection and evaluation of a place...

11. Take a familiar problem as your starting point. a) Frame the problem so that it promotes aggressive behaviour. b) Frame the problem so that it promotes defensive behaviour.

2. Give examples from your everyday life that understanding the context is crucial to how you act.

4. Give examples of how a communication situation can change from a win-lose to a winwin situation.