Training Management System (TMS)


We have developed a Microsoft Access database to keep track of employee or customer's employee training.  The database stores information on all individuals that require or are scheduled or completed specific training programs.  It is perfect for HR organizations; government institutions; associations and training companies that want to know exactly who needs certain training programs, who has been scheduled to attend specific training programs and who has completed them satisfactorily.  It creates letters, roll-call sheets and a wide variety of reports automatically.

What's In It For You

  • Print transcripts

  • Create reports of persons requiring specific training programs

  • Monitor training expenses

  • Create mail labels

  • Comply with ISO quality requirements

  • Rate existing training suppliers

  • Enter company and individual information only once for all employees or attendees

  • Create form letters

    •

 

  • Identify job candidates that have completed necessary training programs

  • Manage people that need annual training to maintain certifications

  • Develop and store employee assessments

  • Auto-email registration info to individuals using SnapShot Viewer

  • Auto-fax registration info to individuals using WinFaxPro

  • Low cost to modify or customize

    •

 

Master Screen Sample - Training Database

Notice the variety of information provided by the tab choices.  In this example we have Companies, Contacts, Actions, 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.  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.

Panel


 Click on thumbnail
 The Panel is the primary navigation tool.  Choose forms, reports and other objects from here.

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

Basic Database


 Click on thumbnail
This has info on companies, people, actions, notes and classes.

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

Individual Training Records


 Click on thumbnail
This allows you to select from a dropdown list of all the classes and enter info automatically by individual.

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

Attendee Letter


 Click on thumbnail
 This letter goes out to all attendees prior to the program.

 $100 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

People Need Classes


 Click on thumbnail
 This report shows all people that require classes based on ReqFreqCode and company TypeCode.

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

Classes To Be Added


 Click on thumbnail
 This report shows all classes that are not listed in the DTblClasses.

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

Registrants List


 Click on thumbnail
 This report shows all people that completed all classes by any time frame entered.

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

Enter Class Information


 Click on thumbnail
 This from is used to enter class information.  Most info pops in from a dropdown.  It has a duplicate button for programs that repeat regularly.

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

Program Tracking


 Click on thumbnail
This report shows planned versus actual attendance for all programs for any period.

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

Diplomas


 Click on thumbnail
 A diploma can be printed after any class.

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

Transcripts


 Click on thumbnail
This screen shows quantity on hand, quantity on order and quantity on reorder by each outstanding order.

 $100 with no customization and support charged by the hour.  Up to $1000 with a lot of customization. Requires modules: Basic Database, 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


 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 "synched" 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:

$500 to $4000 with no customization and support.  Up to $10,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

Web Databases

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

Why Choose Mitchell Selling Dynamics

- We have the know-how to get it right
- We use the most economical hardware and software
- We develop all screens in Microsoft Access which you can modify yourself
- We have extensive experience developing databases and auto contacting
- We are training experts
- We can do the whole project or any part
- We are the best VALUE for this kind of project

Why Choose Microsoft Access

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.

   

Mitchell Selling Dynamics, Inc.
Since 1990

   

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

© Copyright 1996-2014 Mitchell Selling Dynamics Inc. www.mitchellsell.com