Virtual BM - Access Database FoxPro SQL Server VB VBA ASP WEB Programming - Freelance Database Systems and Web Developer

I was approached by Virtual BM to see if I could help them overcome the problems they were experiencing monitoring sales by manual means, the use of Microsoft Word for example and manual e-mailing.

After chatting to Amanda at Virtual BM I proposed two solutions, one office based using Microsoft Access, the other, Intranet based which has the added advantage of being usable while away from the office, all the data is held in one place therefore there are no synchronisation issues.

The system has been developed to run in an HTA, thereby providing a clean browser interface in which to present the data.

The system has many features, but a few that really aid quick and efficient use are

Update: After using the original system for some time, Virtual BM contacted me to discuss the possibility of adding some basic invoicing facilities to the system, at that time the client used reports from this system to create invoices in another system, so it made sense to create invoices directly from this system.

This was achieved by creating a report with user selected selection criteria to select either individual dealers or dealer groups for invoicing, upon production of each invoice the system increments the invoice number ready for the next invoice, thereby ensuring a consistant numbering facility. It also required adding facilities to store contact details for each dealer and provide facilities to maintain this contact data.

Invoice

Technologies used in this project:

ASP
CSS
Datatables
HTA
HTML
JavaScript
JQuery
SQL

Client Comments:
Dennis has recently designed, developed and installed a bespoke sales monitoring and reporting system for my company, and I honestly cannot believe how easy the transition was!

I was extremely impressed with the manner in which Dennis was able to take on board details of the specific requirements of our business and develop a system that is fast, effective and above all simple to use. In fact, after many years of working in various motor dealerships, and often having to use clumsy and overly complicated systems, this new system that Dennis has created for us is a refreshing change. My staff, who initially were slightly anxious about adapting to a new system, have taken to it in no time, and have been happily using it ever since!

Throughout the complete development process from initial information gathering, through to system design and implementation, to user training and fine tuning, Dennis has been proficient, highly professional and incredibly patient, having the ability to be able to communicate clearly with clients who are not from a technical background, whilst simultaneously showing a depth of understanding about the business they are involved in and their specific needs.

I would not hesitate to recommend Dennis and am looking forward to working with him again in the future.
Amanda Watts
Virtual BM


	Clients and Projects These are a few of the companies I have worked with recently.
	Clients and Projects 121 Fundraising Ltd. 301 Design Abbey Storage ABS Wastewater Technology Ltd Acacia Conservatories Advice North Lincolnshire Air Heating (Southern) Ltd. Allianz Global Corporate & Specialty Almond Art Alpha Impact Ltd. Anitox Art du Midi Barconn Limited Barnet and Chase Farm Hospitals Blairgowrie Guest House Brentwood Communications Broadway Records Bruce Burlington & Co. Ltd. Cachet (London) Ltd. Camping La Corconne Canon Consumer Imaging Careys Private Hire Dartford Council Disabled Living Foundation Dellcourt House ESAB Excel IT Ltd. Fleetwood Building and Maintenance GAP Photos Gites in the Languedoc Haymarket Publishing Hiltongrove Audio Bank Hiltongrove Business Space Lansbury International Le Palais des Roses Lynwood Lodge Marie-Louise von Motesiczky Metacosm Metal Cleaning UK Ltd Midaye Somali Development Network Moving Ahead Online Ltd. MSL Medical Pepperneck Pro-Talk Regent Carriage Services Rail Professional Rail Professional Development Sea Containers South Essex Gymnastics Club South & East Essex Training Group Standish Metal Treatment Ltd Sunnyseek The Gifted Goat The Lamp Company Thompson and Morgan Total Crane Services Virtual BM Wasteking Weatherbys		Sales Monitoring and Reporting System developed for Virtual BM I was approached by Virtual BM to see if I could help them overcome the problems they were experiencing monitoring sales by manual means, the use of Microsoft Word for example and manual e-mailing. After chatting to Amanda at Virtual BM I proposed two solutions, one office based using Microsoft Access, the other, Intranet based which has the added advantage of being usable while away from the office, all the data is held in one place therefore there are no synchronisation issues. The system has been developed to run in an HTA, thereby providing a clean browser interface in which to present the data. The system has many features, but a few that really aid quick and efficient use are Multi access levels, users are only offered relevant options. Auto presentation of overdue data with one click client e-mailing. Useful reporting facilities with clearly formatted client reports. Clean simple interface. Update: After using the original system for some time, Virtual BM contacted me to discuss the possibility of adding some basic invoicing facilities to the system, at that time the client used reports from this system to create invoices in another system, so it made sense to create invoices directly from this system. This was achieved by creating a report with user selected selection criteria to select either individual dealers or dealer groups for invoicing, upon production of each invoice the system increments the invoice number ready for the next invoice, thereby ensuring a consistant numbering facility. It also required adding facilities to store contact details for each dealer and provide facilities to maintain this contact data. Technologies used in this project: ASP CSS Datatables HTA HTML JavaScript JQuery SQL Client Comments: Dennis has recently designed, developed and installed a bespoke sales monitoring and reporting system for my company, and I honestly cannot believe how easy the transition was! I was extremely impressed with the manner in which Dennis was able to take on board details of the specific requirements of our business and develop a system that is fast, effective and above all simple to use. In fact, after many years of working in various motor dealerships, and often having to use clumsy and overly complicated systems, this new system that Dennis has created for us is a refreshing change. My staff, who initially were slightly anxious about adapting to a new system, have taken to it in no time, and have been happily using it ever since! Throughout the complete development process from initial information gathering, through to system design and implementation, to user training and fine tuning, Dennis has been proficient, highly professional and incredibly patient, having the ability to be able to communicate clearly with clients who are not from a technical background, whilst simultaneously showing a depth of understanding about the business they are involved in and their specific needs. I would not hesitate to recommend Dennis and am looking forward to working with him again in the future. Amanda Watts Virtual BM

Clients and Projects