Access 2007 Database to inventory, catagorize, and search by keyword
Posted on 2008-06-14
I am a member of a Church and have been given the priveledge and responsibility of maintaining a plethera of recorded Sermons and Events stored on CD's and DVD's. I have a system of keeping them organized and catagorized physically, but I am in great need of a method that can be used to INVENTORY the CD's and DVD's.
I know Access has the potential to do what I need it too. But i know nothing about it. What I'm looking for is a "Database" that allows me to make an organized inventory of the sermons By: Date, Speaker's Name, Sermon/Event Title, Catagory, and also a place for making notes about the disk.
Then most importantly it would need to have the ability to be "searched" by keywords. Like if I want to find all the sermons/events by a particular 'speakers name' then I can just search by that persons name and it pulls up all related entries.
I know there must be tons of different methods of making this happen, so I'm not bound to using Access, I just figure its something that could be free and convienent because I own it already.
Thanks for input and IDEAS!