TechWear Access Project

Perform your analysis in Access.

$1.$ Verify that every sales transaction has a shipping number. Identify and quantify any sales that have not been shipped $($including names of customers and transaction numbers$).$ Propose any necessary adjustment.

$2.$ Verify that every shipping number has a recorded sales transaction. Identify and quantify the cost of sales for products shipped without a sale being recorded $($including names of customers and transaction numbers$).$ Propose any necessary adjustment.

$3.$ Identify shipments that occurred in $2017$ for $2016$ sales. Identify and quantify any sales and the cost of sales for amounts recorded in the improper period $($including names of customers and transaction numbers$).$ Propose any necessary adjustment.

$4.(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 Q$4$Answer. If you use more than $1$ query, name the other queries as Q$4$Step$1.$ Q$4$Step $2...$

$5.(1\mathrm{.}5$ 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 Q$5$Answer. If you use more than $1$ query, name the other queries as Q$5$Step$1.$ Q$5$Step$2...$