LIFE MULTIMEDIA SERMONS DATABASE
LIFE Multimedia Catalog makes it easy for ministries to catalog and label unlimited media types. CD's, DVD s, MP3's, Cassettes or any type that the librarian adds to the Type Look-up table can easily be cataloged for label creation, patron orders, and reporting. Single messages cataloged have the option of an associated parent album, and likewise albums may be grouped by Collections. A parent set may include a combination of any media type. People listing enables librarian to keep track of Patrons, Ministries, Speakers and suppliers. New message entries and new patron orders are automatically flagged for labeling. Production and Patron Order reports display media usage by Date, Media type, and usage ("Master audio", "Worker copy", "purchases", Shut-ins" etc)
LIFE Multimedia incorporates file-to-record attachments, user-defined hyperlinks, data import/export, and Open Database Connectivity (ODBC). These enable LIFE Multimedia to work with applications external to itself. Photos may be attached to contacts. Messages may be hyper-linked to MP3's. Albums may have the case-cover design file attached to the database record. Pending labels may be linked via ODBC to labeling software (Avery and Memorex have applications that will link via ODBC - I've included a few layouts for Avery's DesignPro). LIFE Multimedia does include a few labels and reports, but the ability to link and export data reduces the it's limitations, especially as additional media types are added to the library
Default field-value lookup enables the easy creation of the next record for messages in series. The database assumes that the next message entry is a series continuation, populating the parent, series part#, Title, and Title Part# based on the last single message recorded for the selected speaker.
Written in Microsoft Access 2007, a copy of MS Access 2007 is not necessary. Microsoft provides a run-time application available for free download to execute MS Access 2007 databases.
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.
Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.
FOR YOUR OWN SAFETY, PLEASE:
1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.