Our clients are our greatest source of pride, without whom we wouldn’t be in business. Our clients range from small business owners to large corporations and represent many industry sectors including not-for-profits, utility companies, pharmaceuticals, manufacturers, marketing and educational organizations to name a few. The majority of clients with whom we work are referred to us by our existing clients.
Access Database Designed by the Client Developed by CCA
Client wanted an automated menthod to track projects for which the staff was responsible. They wanted the staff to be able to select topics from a list of approved projects, select associates from a list of names, enter start, finish and other milestone dates. By having the variables chosen from a list of options reduced the errors that could be caused by varying and eroneous data entry. By creating reports to supply a synopsis of the projects and associated details the management was able to easily review and provide feedback on the various activities.
All this was accomplished in an Access database with an initial “welcome” form for easy data entry and report retrieval. The database was designed such that certain selected staff members, with proper Access training, could maintain the basics of the database and therefore be self-sufficient. This database would be used to monitor the status of various projects, the involvement of the individuals and assist management in planning future projects.
Customizing a CRM System to a Company’s Needs
A CCA client had been using “good old-fashioned index cards” to track customers and prospects for many years. Though the firm had purchased ACT to handle its CRM needs it still wanted to be able to record the pertinent information in the same format as it had with its index card system.
The company initially hired CCA to train its staff on how to use ACT as its contact management system. In conjunction with this training, CCA worked with the client’s owners on customizing the database. They wanted the system to record and provide only the information they needed but to ignore those fields not being used. This effort led to a reporting system which showed the needed information in the same format as it had under the old index card system.
CCA also created ACT templates for custom letters and forms using the firm’s logo. This initiative enabled the client to save significant time per customer, to generate correspondence in a more timely and relevant fashion and in the referral tracking process overall.
In summary, the customization increased efficiency and accuracy by reducing paper work more than 65% and providing standardization for all staff. Everyone in the firm could now electronically share all information in a common, simple format without having to resort to index cards and paper files.