Problem 2. Purchases and Payment Business Process (10 marks) Using the Purchases Fabric table and Fabric...

Transcribed Image Text:

Problem 2. Purchases and Payment Business Process (10 marks) Using the Purchases Fabric table and Fabric Inventory, construct a query table with the following fieldnames: color code, color name, qty_on_hand, fabric_cost per yard and beg_invty_amount. Name the query table as: Fabric Costs, beg. (a) How much is the beginning inventory amount? (b) What is the average inventory costs? (c) Which inventory posted the higher amount of inventory? NOTE: SUBMIT YOUR ANSWER SHEET HERE Problem 2. Purchases and Payment Business Process (10 marks) Using the Purchases Fabric table and Fabric Inventory, construct a query table with the following fieldnames: color code, color name, qty_on_hand, fabric_cost per yard and beg_invty_amount. Name the query table as: Fabric Costs, beg. (a) How much is the beginning inventory amount? (b) What is the average inventory costs? (c) Which inventory posted the higher amount of inventory? NOTE: SUBMIT YOUR ANSWER SHEET HERE