Manufacturers' Agent Enterprise Software (MAES Database)
and
Customer Relationship Management







We have many years' experience developing Customer Relationship Management (CRM) and Enterprise solutions with Microsoft Access databases.  John Mitchell began working with Microsoft Access when it was first introduced in the early 90's. Several of our Manufacturers' Rep clients have hired us to develop software to help them run their business.  We have developed Access databases as front ends for a wide variety of data tables including SQL Server, Oracle, AS400, Cobol sequential indexing tables and many more.  These databases can reside on LAN's or WAN's and be accessed by employees that are on-site as well as remotely located.   We have experience setting up remote users through the Internet and using dial-up programs such as pcANYWHERE.

What's In It For You

  • Prepare quotes quickly

  • Enter orders on the fly

  • Auto-fax product spotlights

  • Create mail labels

  • Improve customer service

  • Manage customer contacts

  • Check net prices instantly

    •

 

  • Track call reports

  • Manage multiple discounts

  • Check stock immediately

  • Control inventory better

  • Pay commissions accurately

  • Change zip & area codes fast

  • Auto-email newsletters

  • Handle leads properly

    •

 

Master Screen Sample - Manufacturers' Agent Enterprise Software (MAES Database)

Notice the variety of information provided by the tab choices.  In this example we have Contacts, Actions, Call Reports, Notes, Other Addresses, Discounts, Pricing, Orders, Quotes, Cross Reference, Sales, Re-Orders.  There is virtually no end to the information that can be included.  Please note the auto-dialer icon in the upper right of the screen sample for auto-dialing a phone call.  This database uses many "drop-down" combo-boxes to provide standardized input and minimize typing.


 

Relationships

Microsoft Access is a fully "relational" database.  This means you can "relate" one table to another for anything in those tables that has the same value.  For example, you could relate a "Salesperson" field in the TblCompanies with a "Fullname" field in the TblEmployees.  Once these tables are related you can bring up any information in any or the related tables.

 

Module's Available

The following modules are available as standard although virtually all modules require some customization. Click on thumbnail to see larger picture.

Your Cost

The prices below are the range of costs and they are dependent on the amount of customization and support provided.  The total cost at the bottom is based on licenses for 20 users.

Comments

Please feel free to call Mitchell Selling Dynamics at 248-644-8092 or toll free in North America at 800-328-9696 or email us if you have further questions.

Basic Database

MainFormBasic.jpg (50330 bytes)
 Click on thumbnail
This has info on companies, people, actions and notes.

 $500 with no customization and support charged by the hour.  Up to $5000 with a lot of customization Includes TblCompanies, TblContacts, TblActions, TblNotes, several DTbls, Forms, Queries, VB Code, Auto-dialer, Reports, Macros and Modules

Lead Tracking

Leads.jpg (34460 bytes)
 Click on thumbnail
You select from a dropdown list of all the items to send a customer and a fulfillment letter is printed and follow-up starts.

 $200 with no customization and support charged by the hour.  Up to $2000 with a lot of customization. Includes TblLeads, TblLeadItems, TblLeadActions, DTblLeadActions, DTblLeadSources, RptFulfillmentLetter, Forms, Queries, VB Code, Reports, Macros and Modules

Quality Issue Tracking

Issues.jpg (40670 bytes)
 Click on thumbnail
You keep track of quality, complaints and other issues here.

 $100 with no customization and support charged by the hour.  Up to $1000 with a lot of customization. Requires modules: Basic Database. Includes TblIssues, TblIssueActions, DTblIssues, DTblIssueActions, Forms, Queries, VB Code, Reports, Macros and Modules

Pricing Cards

PricingCard.jpg (41447 bytes)
 Click on thumbnail
You keep a record of the special pricing to each customer by part number.

 $100 with no customization and support charged by the hour.  Up to $2000 with a lot of customization. Requires modules: Basic Database.  Includes TblProducts, TblPricing, TblDiscounts, several DTbls, Forms, Queries, VB Code, Reports, Macros and Modules

Quotation Creation

Quotes.jpg (66456 bytes)
 Click on thumbnail
Quotes are created using discount info and pricing cards.

 $200 with no customization and support charged by the hour.  Up to $2000 with a lot of customization. Requires modules: Basic Database, Pricing Cards.  Includes TblProducts, TblPricing, TblDiscounts, TblQuotes, TblQuoteItems, several DTbls, Forms, Queries, VB Code, Reports, Macros and Modules

Order Entering

Orders.jpg (41773 bytes)
 Click on thumbnail
Orders can be entered with a variety of methods.  We have a unique "Quick" form where you can check price and availability on a bunch of items and then click on the ones to put on the order.  Backorders are created as needed.

 $100 with no customization and support charged by the hour.  Up to $2000 with a lot of customization. Requires modules: Basic Database, Pricing Cards.  Includes TblOrders, TblOrderItems, several DTbls, Forms, Queries, VB Code, Reports, Macros and Modules

Stock Reordering

Reorders.jpg (48951 bytes)
 Click on thumbnail
This is where you reorder parts when you run out of stick.

 $100 with no customization and support charged by the hour.  Up to $2000 with a lot of customization. Requires modules: Basic Database, Pricing Cards.  Includes TblReorder, TblReorderItems, several DTbls, Forms, Queries, VB Code, Reports, Macros and Modules

Commission Calculation

wpe1.jpg (30974 bytes)
Click on thumbnail
You can enter data from your suppliers from paper reports or by disk. 

 $500 with no customization and support charged by the hour.  Up to $2000 with a lot of customization. Requires modules: Basic Database, TblCrossReference, TblSales, several DTbls, Forms, Queries, VB Code, Reports, Macros and Modules

Inventory Management

CheckStock.jpg (78139 bytes)
 Click on thumbnail
This screen shows quantity on hand, quantity on order and quantity on reorder by each outstanding order.

 $500 with no customization and support charged by the hour.  Up to $2000 with a lot of customization. Requires modules: Basic Database, Order Entering, Stock Reordering. Includes TblProducts, several DTbls, Forms, Queries, VB Code, Reports, Macros and Modules

Auto-Faxing

Please click on the following link: Auto-Faxing for more information.  You can eliminate paper by faxing confirmations or quotations directly from your PC.

 $500 with no customization and support charged by the hour.  Up to $2000 with a lot of customization. Requires: Basic Database and WinFaxPro. Includes tracking completed faxes and sending post cards when faxes are not completed,  Forms, Queries, VB Code,  Reports, Macros and Modules

Auto-Emailing

Please click on the following link: Auto-Emailing for more information.  You can eliminate paper by emailing confirmations or quotations directly from your PC

 $500 with no customization and support charged by the hour.  Up to $2000 with a lot of customization. Requires modules: Basic Database and Microsoft Outlook.  Includes tracking completed emails and automatically dealing with returned emails,  Forms, Queries, VB Code,  Reports, Macros and Modules

Reports

OrderPrint.jpg (55094 bytes)
 Click on thumbnail
The database comes with a number of reports. Additional reports can be generated easily.

Reports can vary from $100 and up. Many reports come with the full database.

Replication & Synchronization

The database can be replicated by sales person for their use on a laptop and then "snyched" with the headquarters master.

 $200 with no customization and support charged by the hour.  Up to $1000 with a lot of customization. Requires modules: Basic Database. Includes Forms, Queries, VB Code,  Reports, Macros and Modules

Passwords and User Groups

Database security can be set up to limit the users ability to view or make changes.

 $200 with a limited amount of passwords and user groups and support charged by the hour.  Up to $1000 with a lot of customization. Requires modules: Basic Database.  Includes Forms, Queries, VB Code,  Reports, Macros and Modules

Total:

$3,700 with no customization and support.  Up to $24,000 with a lot of customization or support. The total is for all modules with licenses for up to 20 users.

 

Instruction Manual

You can get a better idea if this application is suited to your needs by clicking on the following Microsoft Word file.  If you have Microsoft Word, clicking on the file should open the file in your Microsoft Word application and then you can view it and save it to your PC if you wish.  If you do not have Word or have trouble viewing the file you can right-click on the file and then choose "Save target as" which will download the file for you and then you can take the file to a PC with Microsoft Word. DatabaseManual.doc

Contact Manager On The Web

Please check out our web databases by clicking here: Web Databases

Why Choose Microsoft Access

Many companies that have chosen ACT, Goldmine and others tell us that after they get started they want to customize their database and find that it can be difficult and expensive.  Access is the most standard database application with many capable developers available and it is completely compatible with all Microsoft products.   Additionally, it can be upsized easily to Microsoft SQL Server which handles terabytes of data.

Upsizing To SQL Server

This type of database works well with up to 15 simultaneous users.  For up to 5000 users we recommend upsizing the back end Access tables to Microsoft SQL Server.
Sales Training

   

Mitchell Selling Dynamics, Inc.
Since 1990

   

1360 Puritan Avenue, Birmingham, Michigan 48009, USA
Phone: 248-644-8092
Email: info@mitchellsell.com

© Copyright Mitchell Selling Dynamics Inc. www.mitchellsell.com