Using Access 2003 for Inventory

  • Thread starter Thread starter Joe Bachman
  • Start date Start date
J

Joe Bachman

I plan to setup our inventory system in the warehouse using Access 2003.
Now, what I would like it to do (and it has been a long time since I have
tried to do anything with access so I don't remember if this is possible or
not) is automatically create a report that will tell me when I am low on
equipment and possibly e-mail it to me and my supervisor.

I'd also like to do the samething so with our drop material (cables, ground
blocks, etc.) and have it e-mail to the owner so that he can place an order.

The system, ideally, will also allow me to view what our technicians have on
their trucks each day.

Like I said, it has been a long time since I last used access for anything
like this and can't remember if it is possible to do or not.

Thanks,

Joe Bachman
Warehouse Assistant
American Satellite Communications
 
automatically create a report that will tell me when I am low on equipment
and possibly e-mail it to me and my supervisor.
You can have a query to check the re-order level against stock on hand. You
could have two levels for re-order - routine or emergency. How often would
you want it to kick out the report - daily or weekly.
It could be set so that it checks each and everytime anyone opens the
database using the Autoexec macro.
Search on e-mail under Reports.
their trucks each day.
Someone will need to key in their usage and replenishment each day.
 
Daily would be nice as the equipment could be plentiful one day and the next
have next to nothing because of the amount of installs from the day before.

As for the what technicians have on their trucks, I figured that would have
to be done manually.

Thanks for your help

Joe Bachman
Warehouse Assistant
American Satellite Communications
 
Back
Top