simple inventory for printer toners

[PrinterTonerInventory]

I need to order and track printer toners. We have many many different
printers, therefore many toners. When a user requests toner, I need to enter
their department and name. At the end of the month I need a report that
lists which toner the user took, date they took; so I can charge back to
their department. I also need to have a running count on toner inventory.
Hope this makes sense, I just took over this duty and am trying to find a
simple to use template to keep the toner inventory organized.

 

[John W. Vinson]

I need to order and track printer toners. We have many many different
printers, therefore many toners. When a user requests toner, I need to enter
their department and name. At the end of the month I need a report that
lists which toner the user took, date they took; so I can charge back to
their department. I also need to have a running count on toner inventory.
Hope this makes sense, I just took over this duty and am trying to find a
simple to use template to keep the toner inventory organized.

I don't know if there's a *template* specifically configured to this very
narrow application; but do you really need a template?

This should be a pretty simple database to set up. You'll need a table of
Toners, of Departments, of Users, of Inventory, and of Transactions. The
running count would simply be a totals query based on the transactions table.

If you want a database to start with, check out some of these resources or do
a Google search for Access inventory applications:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

Tony Toews' Access page:
http://www.granite.ab.ca/access

John W. Vinson [MVP]