Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started