Case Studies

PCA designed and developed a custom MS Access Database solution to enable M&A bankers and their teams to more efficiently manage M&A engagement lifecycle activities — from initial client prospecting, through financial evaluation, to deal close and relationship management. PRACTICAL worked with Advest’s M&A department to design a solution from existing contact management applications and MS Excel spreadsheets. Read Advest Case Study.

PCA designed and developed an MS Access Database Application Solution for the telemarketing sales force to track Professors, Universities, Textbooks and follow-ups to support direct telemarketing campaigns. PRACTICAL worked with Blackwell to design the new system from scratch. Read Blackwell Case Study.

PCA developed a healthcare risk assessment database in MS Access that allows LifePlans nurse associates to efficiently analyze diagnosis risk factors and determine long-term health care implications. LifePlans uses the application internally and markets, sells and supports the application commercially. Read Lifeplans Case Study.

PCA designed and developed a custom parts management and tracking system for Medtronic’s catheter production facilities. The solution supported their existing document-based parts tracking process and was fully integrated into Medtronic’s new MAX MRP system, existing labeling and barcoding system, and other corporate reporting systems.  Read Medtronic Case Study.

PCA designed and developed a complete, end-to-end automobile service warranty sales and customer support system. The system was built in MS Access with a SQL Server back-end database, and supports 60+ concurrent End Users.  Read Royal Administration Case Study.