Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

uery 3-A: Query results when price cut off of $25 is entered. Query 3-B: Query 3-C: Note: Exclude the counting of orders per customers as

uery 3-A: Query results when price cut off of $25 is entered. Query 3-B: Query 3-C: Note: Exclude the counting of orders per customers as this requires some advanced SQL which we have not covered. Query 3-D: Query 3-E: Query 3-F: Since you need to use your judgment on what fields to include to communicate with the customers, I don't have any screenshot for this query. But when you do create the query, you should get 3 results after taking into account different constraints mentioned in the instructions. Salesperson Form: As mentioned in the class, feel free to have a different look and feel for forms and reports as long as they look clean and professional. Customer Order Entry Form: Created using Form Wizard Report: Created using Report Wizard: Note: Easiest approach is to create a new query with all the fields required for the field and use that as a source in wizard

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

Step: 3

blur-text-image

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

Effective small business management An Entrepreneurial Approach

Authors: Norman M. Scarborough

10th Edition

132157462, 978-0132157469

More Books

Students also viewed these General Management questions

Question

=+How does it affect the steady-state rate of growth?

Answered: 1 week ago