Simple Inventory Plastic Barrel Different capacity with Logo Printed

[aces27]

Hello , Am new to access , though fairly comfortable with most Office products and programming language and methodology. Am working on improving the inventory management of a small factory set up where I am. Single Machine - 5 Different Products Forms : Enter Daily Production Count Enter Daily Printed on Product Count Enter Daily Sales Dispatch Count Tables : Customer List of Purchase Order List of Sales Production Record Product List etc Idea : To be able to maintain the inventory details : date wise , customer wise and keep a track of Purchase Order and Dispatch against each Purchase Order. Of Product A B C D E manufactured and available in plain form or printed form. I have provided a basic structure of what I am set out to do. Please advise if I am on the right track and guidelines to proceed. Of course , ready made inventory software can be used but wanted to make things real simple and much suited to the actual requirement. Thanking you Aces J

 

[jdraw]

Welcome.
Inventory control systems are not trivial. Sounds like you have a good appreciation of what is required. There are a few free data models related to Inventory Control
here that may be helpful. You may need to "concoct your own based on some of these pieces/concepts".

http://www.databaseanswers.org/data_models/inventory_control_for_retail/index.htm

http://www.databaseanswers.org/data_models/inventory_control_and_pricing/index.htm

Table structure and relationships will be key. There is a guide here on Normalization and Entity Relationship Diagramming -- First few topics are well worth the read.
http://www.rogersaccesslibrary.com/forum/topic238.html

The Hernandez process may be useful also.

 

[spikepl]

You may want to google for Access templates - MS maintaines a whole bunch