Question: 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

 III Customers without contact information Using appropriate object(s) identify customers who

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 without Contact Info" Printscreen: a. Design view of obiect. b. Datasheet view of object. IV Net Revenue earned on each shipped order Using the relevant objects create a Select Query "YourFirstName Net Revenue" displaying appropriate fields, including NetRevenue, GrossProfitLoss, Commission, Shipped Date. NetRevenue is Gross Revenue less Discount Amount. Commission should be calculated @ 1.5% of NetRevenue on profitable orders only. Printscreen: c. Design view of select query, displaying relevant fields. Make sure expressions for the calculation of NetRevenue, GrossProfitLoss and Commission are completely visible. No marks will be awarded if they are not completely visible. If necessary, please submit additional printscreens. d. Datasheet view of the Query, showing at the bottom of the datasheet, the total aggregate sums of NetRevenue, GrossProfitLoss and Commission. Earnings by Sales Representatives Using appropriate objects, create a summary titled "YourFirstName Earnings by Sales Representatives" ts calculate NetRevenue, GrossProfitLoss, Commission earned by each sales representative on shipped orders only. Use captions Revenue, Profit or (Loss), Commission, for the appropriate columns. Printscreen: e. Design view of Query. f. Datasheet View of Query, showing at bottom of datasheet, sums for Revenue, Profit or (Loss) and Commission. Top customers Using appropriate object(s) identify names of customers who placed orders totalling more than $40,00 Name the object "Your Name Top Customers". Printscreen: Design view of object. Datasheet view of obiect

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!