Answered step by step
Verified Expert Solution
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
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