Question: Using the relevant objects create a Select Query YourfirstName Net Revenue displaying appropriate fields, including NetRevenue, NetProfitLoss, Commission, Shipped Date. Commission should be calculated @

Using the relevant objects create a Select Query YourfirstName Net Revenue displaying appropriate fields, including NetRevenue, NetProfitLoss, Commission, Shipped Date. Commission should be calculated @ 10% of NetRevenue on profitable orders only. Printscreen: Design view of the Select Query, displaying the relevant fields. Make sure the expressions for the calculation of NetRevenue, NetProfitLoss and Commission are completely visible. No marks will be awarded if they are not completely visible. Datasheet view of the Query, showing at the bottom of the datasheet, the total aggregate sums of NetRevenue, NetProfitLoss and Commission. ings by Salesperson Using appropriate objects, create a summary query titled "YourFirstName Earnings by Salesperson" to calculate NetRevenue, NetProfitLoss, Commission earned by each sales person. Use captions Revenue, Profit or (Loss), Commission, for the appropriate columns. Printscreen: Design view of Query. Datasheet View of Query, showing at the bottom of the datasheet, sums for Revenue, Profit or (Loss) and Commission

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 Accounting Questions!

At a price of $3 each, Yoshi (a typical New Yorker) drinks 200 44 oz. sodas each year. Concerned about burgeoning obesity, the Mayor of New York proposes a $0.50 tax on on such drinks. He then...

III Customers without contact information Using appropriate object(s) identify customers who do not have either a contact name or telephone or fax number. Name the object "YourFirstName Customers...

This assignment is to review Amazon?s most recent financial statements (provided) and find recent business articles on Amazon (examples provided) to get the answer to the following: 1. What does...

Paragraph One & Two: Prior to the financial recession in the late 2000s, some companies had built up significant cash balances. By 2010, discussions began about whether "cash hoarding" by firms was...

Hi tutors, can anyone help me work on the below assignment thanks. Paragraph One & Two: Prior to the financial recession in the late 2000s, some companies had built up significant cash balances. By...

Hi guys, I am trying to properly answer an accounting question concerning shares, bonds, and stock. I was given two annual reports, and am asked to make a decision on one of the companies depending...

Answer the questions below for this year and last year, using your SEC 10-K: Category: Operating Activities 1. Net income versus total for operating activities: report these values. 2. Items of...

Using the Annual Report of your selected company answer the following questions in the Discussion: What is the value of the company's inventory at year end? What was the amount of cost of goods sold...

Boston Beer Company WACC Project In this project, you will find and discern the appropriate data to determine a realistic assessment of the weighted average cost of capital for The Boston Beer...

use the functions and find the given requirement f(x) = 2x-3x + 2 and g(x) = 2x + 1 Find (f - g) x

An aluminum can of a soft drink is placed in a freezer. Later, you find that the can is split open and its contents frozen. Work was done on the can in splitting it open. Where did the energy for...

Which of the following statements about beta is not true? A . The return of a security with a negative beta would tend to move in the opposite direction of the market return on a given day. B . The...

Hugo decides to buy his Christmas gifts on Black Friday. To simplify his life, he is giving his 10 closest friends scarves for Christmas and everyone else Christmas cards. Hugo is willing to pay up...