Connecting Tech Pros Worldwide Forums | Help | Site Map

Inventory/asset track

Newbie
 
Join Date: Sep 2008
Posts: 2
#1: Sep 3 '08
Has anybody heard of this type of database

----My business description

In my shop i have stock items
and i have a few vans where i have my techs fix centain things

when my techs need something they come to me and ask for them

basically i want a database that would allow me to see the inventory of the vans and the inventory of the shop

Shop:
8 wheels ( example)

if van 1 asked for 2 wheels i want to be able to move wheels from the shop to the van in database form. so that next time when he asked for wheels i can see that he should have 2 wheels already in stock in his van

puppydogbuddy's Avatar
Expert
 
Join Date: May 2007
Location: Florida
Posts: 1,915
#2: Sep 4 '08

re: Inventory/asset track


Did you know there is a sample inventory database that comes with Access? To get this database Click the key icon to start Access, and instead of opening an existing file, select Access Database Wizards, Pages, and projects. Then click on the inventory database icon.

Also see this link for a 3rd party inventory database for Access that costs $35 (less than the cost of a book) and I believe it comes with source code.

http://www.tinit.co.uk/?s=Stock_Control

Additionally, one of the best book reference sources I have ever used, uses an inventory system as one of the illustrative examples, showing step by step how to build an inventory application from the ground up. The book is entitled "Building Microsoft Access Applications" Copyright 2005 by John L. Viescas, Microsoft Access MVP.

Hope this helps.
Reply