ProSoundWeb Community

Church and H.O.W. – Forums for HOW Sound and AV - Your Displayed Name Must Be Your Real Full Name To Post In The Church and HOW Forums => Church Sound => Topic started by: Josh Lyon on June 15, 2011, 01:13:09 PM

Title: Equipment Inventory Management
Post by: Josh Lyon on June 15, 2011, 01:13:09 PM
Well, I've been given the daunting task of creating an inventory of all our churches sound, lighting, and video equipment. I'd love to put it in some sort of easily updatable database versus something like excel - so I was wondering if anyone knows of any good management software for inventories? The few I've found are mostly point of sale oriented, which is not something we'd use.

Thank you for your help!
Title: Re: Equipment Inventory Management
Post by: Brian Gowing on June 15, 2011, 02:08:02 PM
Well, I've been given the daunting task of creating an inventory of all our churches sound, lighting, and video equipment. I'd love to put it in some sort of easily updatable database versus something like excel - so I was wondering if anyone knows of any good management software for inventories? The few I've found are mostly point of sale oriented, which is not something we'd use.

Thank you for your help!

If you're familiar with Microsoft Access or at least have it somewhere check out the Asset Management database template. It's free and it works for stuff I need to inventory.
Title: Re: Equipment Inventory Management
Post by: Jonathan Johnson on June 16, 2011, 01:22:16 AM
I've modified this Microsoft Access Database template (http://office.microsoft.com/en-us/templates/home-inventory-TC010206881.aspx) to meet my needs. Not much modification was necessary. This one allows you to attach photos of the items.

Of course, this requires Microsoft Access 2007, which is part of the Microsoft Office Professional suite. It can be purchased separately, too. But that costs money.

If you don't want to pay for Access, you could try the free Open Office (http://openoffice.org/). I just found this Inventory Database template (http://opentemplate.org/content/show.php/Home+Inventory+Database?content=123160&PHPSESSID=0871f9988d934d7bef9b81e74b656596) for Open Office. I haven't even looked at it, but it may work just fine.

And a couple others I found, too, (http://templates.services.openoffice.org/en/search/node/home%20inventory) but they are spreadsheet-driven rather than a database application.