R
Remacricky
I work for a construction distribution company and we sell "widgets". I need
a simple application that I can train junior staff to use that can contain
all info on each widget and the stage it is at for each project. Here is a
quick breakdown of our process.
1. Widget sold
2. Widget ordered (either from stock or from mfg)
3. Widget re-worked in house (if needed)
4. Widget shipped
5. Widget invoiced
Right now I am using a simple Excel spreadsheet to lay out the size and
other variables for each widget (could be 800 different types per order),
then add columns, for purchased, stock, rework, delivery date etc, using
links by PDF for purchase order numbers etc.
Is access a better program to use, and if so, what is the best way to set up
this operation.
Thanks in Advance
Ricky
a simple application that I can train junior staff to use that can contain
all info on each widget and the stage it is at for each project. Here is a
quick breakdown of our process.
1. Widget sold
2. Widget ordered (either from stock or from mfg)
3. Widget re-worked in house (if needed)
4. Widget shipped
5. Widget invoiced
Right now I am using a simple Excel spreadsheet to lay out the size and
other variables for each widget (could be 800 different types per order),
then add columns, for purchased, stock, rework, delivery date etc, using
links by PDF for purchase order numbers etc.
Is access a better program to use, and if so, what is the best way to set up
this operation.
Thanks in Advance
Ricky