MS access database design
Budget: $30 – $250 USD
Create database for product cost calculation and following:
Database should include following:
1- suppliers base
2- material base
3- product base
4- cost calculator
it should work something like this:
Supplier database - contains name of suppliers
We insert materials in materials database (define prices, units of measure, from what supplier it is, what is the date that the price of material is given) - it should be able to track price change of the material - for instance we have material A - from supplier X and Y, we would like to know what supplier have a better price.
Product base- contains products that we make (it should have option to determine how much of what material it use and at what price (it should pull it from material base)
cost calculator should calculate price per item based on parameters defined in product database.
Database should include following:
1- suppliers base
2- material base
3- product base
4- cost calculator
it should work something like this:
Supplier database - contains name of suppliers
We insert materials in materials database (define prices, units of measure, from what supplier it is, what is the date that the price of material is given) - it should be able to track price change of the material - for instance we have material A - from supplier X and Y, we would like to know what supplier have a better price.
Product base- contains products that we make (it should have option to determine how much of what material it use and at what price (it should pull it from material base)
cost calculator should calculate price per item based on parameters defined in product database.