Sample Access Database Projects

Presented below is a sampling of the Microsoft Access databases that we have developed in recent years.  Note that while most of these are shown using the Access 2007-2010 interface, we service clients that continue to use databases from Access 97, 2000, XP and 2003 as well.

Assisted Living Facility Resident Management
This database was designed to help an assisted living facility manage the care administered for its residents.  The database keeps track of basic resident demographic data as well as medical diagnoses, chronic conditions, medical & non-medical orders, doctors' appointments/examinations, dietary requirements & restrictions, etc. The database also provides detailed printed reports to assist nurses and other facility personnel in their day-to-day management activities.
Employee Benefits Administration
Our client was seeking a better way to manage its employee benefits packages across multiple states using various providers.  Our solution was an Access database that tracks each employee, their dependents, the coverages they elect, their pay periods, and the costs for the company and the employee both on an annual and pay period basis. The database also tracks new employees' coverage start dates along with employees who leave and elect COBRA, along with  their payment requirements and coverage periods. The database provides detailed reports by employee to assist plan administrators in reconciliation of invoices from providers.
Surgical / Post-Surgical Tracking
This database was created for a laser eye surgery practice to enable it to track each patient's pre-surgical characteristics, the surgeries performed, and the post-surgical results measured at various intervals after the surgery. Its purpose was twofold -- to allow the practice to evaluate its results and use the data to improve care for its patients, and to facilitate participation in clinical trials for various lenses. This was one of several databases we created for this practice; others included operating room efficiency, patient satisfaction, and patient billing.
Trade Association Event Management
This database was created to assist a national trade association to manage its annual convention that attracts hundreds of exhibitors and thousands of attendees each year. With respect to exhibitors, the database tracks space availability, space commitments by each exhibitor, charges for each exhibitor including a tiered pricing program based upon sign-up dates, payments received, contact management, special requests, etc.  It also allows the association to track trends across multiple years in terms of repeat exhibitors, space expansion/contraction, etc.
Distressed Commercial Loan Management
This database was created to enable a bank to track collection efforts and outcomes for a $700 million distressed commercial loan portfolio it has purchased from the FDIC.  As part of the purchase agreement, the bank assumed responsibility for managing the workout process while receiving support from the FDIC in terms of a backstop to cover credit losses.  The ability to assess and document potential and actual recoveries is critical to the bank's ability to collect on any claims it submits to the FDIC.
Charity Auction Management
A not-for-profit organization needed a better way to track its burgeoning annual charity auction donations and receipts than the paper-based system they were using. Our custom-developed Access solution handles all aspects of the charity auction process, including tracking auction item donations, sponsorships, invitation lists, attendee lists, name tags for attendees, production of the auction program, real-time checkout and receipt generation, automated generation of thank-you letters, automated generation of tax letters, etc.