I have an access database that I need to make the following changes to: Purchasing Database Request: The Purchasing Clerk inputs the Repair Slips to the Purchasing Database to track purchases. They...

I have an access database that I need to make the following changes to:

Purchasing Database Request:

The Purchasing Clerk inputs the Repair Slips to the Purchasing Database to track purchases. They would like the following updates made to the Database:

I. The Quantity, Unit Cost, and Total Cost have to be manually input by the PC. Occasionally the PC will calculate the total incorrectly. Create a form where the PC can input the purchase, but the Unit Cost and Total Cost are automatically calculated based upon the other field data.

II. Create a query that allows the PC to view any repairs where the Total Cost was miscalculated.

III. Create a purchasing report that provides the quantity and total cost for all parts in the database.

Purchasing Database Request: The Purchasing Clerk inputs the Repair Slips to the Purchasing Database to track purchases. They would like the following updates made to the Database: I. The Quantity, Unit Cost, and Total Cost have to be manually input by the PC. Occasionally the PC will calculate the total incorrectly. Create a form where the PC can input the purchase, but the Unit Cost and Total Cost are automatically calculated based upon the other field data. II. Create a query that allows the PC to view any repairs where the Total Cost was miscalculated. III. Create a purchasing report that provides the quantity and total cost for all parts in the database.