I am looking to create a database to track some equipment. Most of my databases I have created have been to store and graph data based on date or retrieving a series of documents based on a procedure.

Here are the specifics of I am looking to do:

I have a bunch of computer units that are placed on various pieces of equipment. I want to be able to track where they are at any time. The equipment (ex lcd01) could be on truck1 or truck2, etc. Or it could be available for use, out for repair, broken, etc. I want to be able to see the history also, when was it repaired, what trucks has it been on, etc. I know it is simple, but I can't figure out how where to start. Any help would be appreciated.