Price calculating interface

[sara-y]

Hi,



I would like to design a price calculating interface, by which the user only enters some few information in a form and by the information he enters, the program returns the total price of a part.

Each product individually has about 10pcs of parts with different weights which will play role in calculating its price and the products themselves are different in sizes...

For example: Product 'N' with size 'X' has 'A', 'B' and 'C' parts with corresponding 'a', 'b' and 'c' Kg weights. This product will 2pcs of 'a' 4pcs of 'B' and 6pcs of 'C'. The user will enter the unit price (per each Kg) of these parts and the program should return the price of product 'N' with size X.

Next time for product 'M' with size 'y', the same story...

The information of the weights and sizes can be stored in access tables. But has any body done a similar project to guide me what should be done? and what is a proper way to do it?

Thanks in advance...

[June7]

An off-the-shelf application might be best option.
Google: Access database manufacturing
Review
http://www.pedyn.com/access/