Inventory database

[iwu]

am into designing a database that will have to manage products of variuos
kind from different supplier and then I need to be able to get the database
to tell me the balance of the products and also it should be able to flash at
startup those products that have reached their re-order level for me to make
their purchase to restock and also send a mail to the manager for approvals
when one needs to go to the store to collect any product.

Does any one know how i can go about this in ms-acces.... am a newbie and
will appreciate if I can know the table format. has any one done sometime in
similar nature.?

 

[Daniel Pineault]

I would start by looking at some of the freely available template and then go
from there. It could save you a tremendous amount of time and start you off
with the correct basic table structure...

Take a look at:
http://office.microsoft.com/en-us/templates/CT101527321033.aspx?av=ZA
http://databases.about.com/od/accessdatabasetemplates/Microsoft_Access_Database_Templates.htm

Specifically
http://office.microsoft.com/en-us/templates/TC010184581033.aspx?CategoryID=CT101426031033&av=ZAC00
http://office.microsoft.com/en-us/templates/TC102068821033.aspx?CategoryID=CT101428241033&av=ZAC000
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Piet Linden]

am into designing a database that will have to manage products of variuos
kind from different supplier and then I need to be able to get the database
to tell me the balance of the products and also it should be able to flash at
startup those products that have reached their re-order level for me to make
their purchase to restock and also send a mail to the manager for approvals
when one needs to go to the store to collect any product.

Does any one know how i can go about this in ms-acces.... am a newbie and
will appreciate if I can know the table format. has any one done sometimein
similar nature.?

Allen Browne has a sample application on his website. www.allenbrowne.com