New db to track assets 1

[dcorleto]

Looking for advise on a structure for maintaining hardware assets. Currently I am in the process of collecting model, serial, asset tag and locations in one table. Have another table of employees and the same location field in that table, so thinking that the location would be the common field, though many will not be an exact match for several reasons.

Is there a place where I might either get a template to start from, or guidance on how to set this up in Access so in order to track new equipment as it comes in, moves, and loaner equipment. Thanks

 

[genomon]

Try opening Access and clicking on "New From Template" and choose "General Templates". Then choose the "Databases" tab. There are some excellent examples free for the taking...

Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.

 

[johnherman]

Check out the library of free data models:

http://www.databaseanswers.org/data_models/index.htm

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright

 

[TomCologne]

Thanks for the link, John. Have a star.

TomCologne