1998 – 2011
Summer Solutions is placement and advisory service that helps parents select the best and most appropriate summer camp for their children. Summer Solutions was having difficulty maintaining lists of existing and potential clients as well as keeping a database of participating camps.
CCD worked with the principals of Summer Solutions to design a customized database in Microsoft Access to organize campers, camps, agents, billing, camp fairs, etc. Individual versions of the database were created for agents in several states using replicas and partial replicas. CCD created many customized reports for telephone lists, billing, and summarization of data. CCD Developed an easy-to-use search system tailored to client specifications. The database has allowed Summer Solutions to manage many more customers and placement officers in an efficient manner. The database incorporates several billing strategies which have dramatically boosted revenues since the system was implemented. Database Management is conducted to this day by CCD for Summer Solutions.