FROM

1. Revise the purchase order form to add a column called Extension to calculate the dollar amount of each item purchased, as well as a field of Total to show the total dollar amount of each PO. Make sure that the new fields in the design view are readable in the Word file.

QUERIES (6 points each)

2. How much did the company pay to each vendor in January 2001? You need to present the Vendor Number, Vendor Name, and the total payments to each vendor. (Hint: You need to use 5 tables and there should be 3 records for the query result.)

Answer rating: 100% (QA)

This query requires data from 5 tables Vendors Purchased Orders Purchase Order Lines Items and Payme... View the full answer