Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Markets And Institutions

Authors: Peter Howells, Keith Bain

5th Edition

0273709194, 9780273709190

More Books

Students also viewed these Accounting questions

Question

Define facework and identify three primary facework strategies

Answered: 1 week ago