You have chosen to sponsor your bid up to a maximum amount of .
Build a database in access to track purchases, sales, and inventory levels for an oil company. There is essentially three types of inventory that need to be tracked in this database along with the average cost of each of those inventories. Inputs would be: meter readings from 10 different trucks and caculations of sales, and adjustment of daily inventory levels based off of those readings. Purchases of each of three types of inventory along with contract info for those purchases. Daily costs from our suppliers and average price of our competetors. Reports needed: inventory levels, average cost of each of those levels, purchases and what has to be picked up from those purchases during a given time and sales for a given time. I do most of this with excel now and as such have a lot of the formulas that are needed.