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
|
|
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.
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 AvailableThe following modules are available as standard although virtually all modules require some customization. Click on thumbnail to see larger picture. |
Your CostThe 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. |
CommentsPlease 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
|
$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
|
$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
|
$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
|
$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
|
$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
|
$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
|
$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
|
$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
|
$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-FaxingPlease 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-EmailingPlease 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
|
Reports can vary from $100 and up. | Many reports come with the full database. |
Replication & SynchronizationThe 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 GroupsDatabase 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. |
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
Please check out our web databases by clicking here: Web Databases
Why Choose Microsoft AccessMany 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 ServerThis 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. |
1360 Puritan Avenue, Birmingham, Michigan 48009, USA
Phone: 248-644-8092
Email: info@mitchellsell.com
© Copyright Mitchell Selling Dynamics Inc. www.mitchellsell.com