If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
simple inventory for printer toners
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. |
#2
|
|||
|
|||
simple inventory for printer toners
On Mon, 21 Jan 2008 13:01:03 -0800, PrinterTonerInventory
wrote: 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/acc...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] |
Thread Tools | |
Display Modes | |
|
|