A Blue Claw Database Design Template:
Corporate Document Control Solution
Key to a complex customer management database is the user interface. Below we show our classic tabbed interface for our custom CRM database designs. All functions are accessible from a single main menu. There are no subordinate popup menus to get lost in or to have to navigate backwardly to return to the main menu.
Normally this design might slow down a database however; we use recordset and form
programming techniques which prevents any slowness in the CRM database.
The CRM Software main control panel for maintaining customer membership lists is
shown below. This form
includes main member records and
subordinate associate member records. Included are payments and payment statuses, incidents statistics, and periodic
notification milestones. Additionally, this data is automatically coordinated with an SQL Server database running on the web
The Access CRM Database's secondary duties are to track roadside breakdown incidents. Included as a part of customer incident response is a measure of response time and customer satisfaction. All customer incident statistics are updated immediately and are available on the screen or in report format.
The Access CRM database design includes the capability to track prospective customers. The database tracks status of prospective customers and generates labels and letter for marketing material. During new member entry, the database automatically checks the new customer against the list of prospects and loads all stored data into the members table. The CRM customers and prospects are kept in separate table for efficiency of processing.
Our software developers' efficient table design allows all CRM data for
thousands of customers to be managed in less than 5 megabytes of disk storage.
The entire application, including data can be zipped and placed on a diskette.
All coding is done using Visual Basic - there are no macros in this
one of our Microsoft Access developers today to see what we can do for your
CRM software needs.