« FP Magazine Issue Redesign | Main | Info-Packed CME Meeting Mailer »

August 15, 2007

Meetings Management Database

A professional association needed an upgrade to their meetings registration management software. MS Access to the rescue.

I developed a MS Access-based database tool that enables a professional association to manage its continuing education meetings. The tool's features are very basic, but it delivered on expectations.

The trick was mapping their existing workflow/registration process and mirroring it within the tool. Had to create the entire data model. For ease, I utilized a slightly de-normalized schema.

I intend to continually upgrade the tool as needs change/warrant and eventually convert into web application to tie with their online membership managment tool I also developed. (I used an existing framework for that project)

Tools: MS Access 2002, Visual Basic for Applications (VBA)


msys2007.jpg

Posted by pgraber at August 15, 2007 12:28 PM

Last Update: 8/24/2007