queries in access

$(15$ points$)$ Analyze gross margin percentages by customer for Year $2016,$ after considering your previous findings. Sort gross margin percentage from the smallest to the largest.

Your answer will be in a query called $O4$Answer. $If$ you use more than $1$ query, name the other queries as Q$4$Step$1,$ O$4$Step$2...$

$(15$ points$)$ Develop a trial balance of accounts receivable by customer at December $31,2016,$ after reflecting about any proposed adjustments. The trail balance should include Opening Balance, Sales, Cash Receipts, and Unapplied Receipts $($in that order$).$

Your answers will be in a query called O$5$Answer. If you use more than $1$ query, name the other queries as Q$5$Step$1,$ Q$5$Step$2...$