What is the proper design for an "equipment" sign out database in MS Access 2003?

I would like to create a database to track the movement of equipment.  Each of my company's employees has a barcoded ID badge and each piece of equipment has a barcoded equipment id.  

Here is what I would like to track:
1. Associate ID (checking equip out)
2. Equipment ID (going out, and time back in)
3. Equipment Damages / Malfunctions

This question is doesn't require a ton of detail, just direction on table design/setup and form setup suggestions.


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Have you looked at the Templates here:


There's an Asset Tracking database, and an Inventory Management database that should give you some good ideas.
Derek_IndianapolisAuthor Commented:
Yeah I did.  I was hoping that someone would be able to point me in another direction.  I've been researching and found other demos, which are similar to my application but are for 400 dollars +.
There are other sample databases that come with Access XP/2003 -
Open Access
Templates/On My Computer
Databases Tab

You then have a different Asset Tracking database to try out and tweak to uor own requirements
Derek_IndianapolisAuthor Commented:
I appreciate the help so far, but these solutions requiring re-engineering of the template databases are more work than it will be worth.  I am not looking for an asset tracker, more of an equipment check in/check out.  

The assocate would come to the computer with the database and the equipment to be checked out.  The clerk checking out the equipment would need to just scan the associates barcoded id and scan the equipment barcoded id.  I would then like for the scanned out equipment to be unavailable to check out again, until checked back in.  I would then like to keep history of each time the individual pieces of equipment were checked out by time and return time.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I would tend to disagree, but:

You'd need a table to track the Equipment, a table to track the Rentor, and a table to track which user has a particular piece of equipment at that time:

lEquipID [autonumber, PK]
etc etc

lRentorID [Autonumber, PK]
etc etc

lCheckOutID [AutoNumber, PK]
etc etc

You'd need a form to capture Rentor information (i.e. your Associates), Equipment information, and one for the clerk to use when scanning. The scan form would basically have two textboxes; the clerk would enter the first textbox, scan the Associates barcode, then enter the second textbox and scan the Equipment barcode. Code in the AfterUpdate events of those textboxes would then lookup the Equipment's barcode in the tblCheckout and verify that it has, indeed, been returned (obviously it would have been returned, but your code needs to see if someone returned it without checking it back in).

If the scan doesn't locate either the Associate or the Equipment, you'd probably need to alert the clerk and allow them to capture this information (i.e. bring up one of your other forms), then let them go back to the business of scanning.

Of course this is extremely "bare bones" but should get you started. Much of your apps internals will depend on exactly what sort of scanner you use (most just use a keyboard wedge scanner).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.