(Solved by Humans)-Access Project Need help with 3-E & 4-3. Correct answers are

Question

Access Project

Need help with 3-E & 4-3. Correct answers are imperative.

https://bbhosted.cuny.edu/bbcswebdav/pid-23923751-dt-content-rid-116188647_1/courses/BAR01_CIS_2200_EMWA_1162_1/DatabaseAssignment%282%29.htm

Query 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.