Database to Store Product Formulas and Track inverntory

[Kent H.]

I have created an access database to store product formulating information
and to track product information. I know how to create a basic table and I
know how to create a basic form, but how can I create a form or report that
can list all the raw materials, and that can calculate the amount of each
ingredient needed to make a product? I would like to use a form to create
and retrieve new formulas, and to print a copy for production and I need the
information in the data base to relate. I know how to create a spred sheet
to perform the above described, but a spread sheet will not store the data
like access would. I would appreciate any suggestions...

 

[mnature]

Since it sounds as if you don't know very much about Access, you might want
to look at this software. You can download a single-user copy for free, and
they have reasonable prices for multi-user copies.

http://www.dbamanufacturing.com/

It is quite possible to use Access for what you are trying to do, but you
will have a very steep learning curve. If you want something up-and-running
very quickly, better to go with canned software. You can always be learning
about Access, and developing a personalized database, while using the other
system.

 

[Kent H.]

Kent H.
mnature, Thank You for your suggestion. I will give it a try.