Hi CecyBeans,
I could do that very easily, but that wasn't what I actually had in mind. I was thinking of just taking an Access db template for a media library and making it our own. The reasons why I was thinking of doing it that way is because I can easily repurpose already existing elements/tables like this:
- 'Genre' - will be changed to 'Subject' - i.e. motion hearings, interviews, depositions, etc.
- Media Type - like cd, book, dvd would be altered to reflect - print, video, audio, online blog, etc.
- Say I wanted to document a depo. By bastardizing the template for say an 'album' (renamed by genre), I can then use the fields for 'song', 'author', 'length', etc. to actually record the keynotes, speaker and page/lines.
- As well, we can store video/audio clips in it
Probably sounds like Greek to many, but it is actually pretty easy to swap field labels out in an entire access/sql database and not recreate the wheel from scratch, yet still end up able to really use the inherant search capabilities and already functioning reports.
That's where I was heading. Leave it with me for a day or two and I'll drop a sample on you guys. Alternately, I could whip an excel workbook/DB together faster than you can go gather all the links you want.
End-user's choice. To you guys, it will just look like a nifty little program, nothing techie.