Tracking equipment with Access

[TitansFan]

I'm new to this forum and I've been searching the Web looking for a way our company can keep track of our equipment. I've done some searching for stand alone software, but I'm wondering if I can use Access.

We are a construction company that specializes in the restoration of water/fire damages structures. We are wanting to keep track of our equipment which consists of 23 dehumidifiers, 16 carpet fans, and 6 HEPA air scrubbers.

Here is what we would like to keep track of:

Current location of equipment
When/where/time equipment was put into use
When/where/time equipment was taken out of use
Where equipment went after use
When equipment filters were changed?
Inventory and location of equipment filters
Notes (ex. carpet fan makes a funny noise, power cord is damaged, etc.)
And possibly more...

Does this sound like something I could set up in Access?

Thanks

 

[jackd]

It's possible with Access for sure.
See http://www.databaseanswers.org/data_models/index.htm for some sample data models.

Some of the equipment, or tracking models may give you some ideas.


A general approach to creating a database is given here
http://www.databaseanswers.org/approach2db_design.htm