Virtual BM -  I am a Freelance Microsoft Access Database and WEB Systems Developer/Programmer specialising in Database Development, Access, SQL, Foxpro. Design, Programming and Development of both local network and Internet based applications. +44 (0)20 8123 0528  

Home - About Me - Clients and Projects - Training - Software/Programming/Technologies - Hosting - Websites - Testimonials - Contact

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.
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
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
Metal Cleaning UK Ltd
Midaye Somali Development Network
Moving Ahead Online Ltd.
MSL Medical
Regent Carriage Services
Rail Professional
Rail Professional Development
Sea Containers
South Essex Gymnastics Club
South & East Essex Training Group
Standish Metal Treatment Ltd
The Gifted Goat
The Lamp Company
Thompson and Morgan
Total Crane Services
Virtual BM
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.

Virtual BM

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
© Dennis McDermott 2001-2019  -:-  Dennis McDermott is a Freelance Access Developer at Bespoke Software Development Limited -:- Privacy Policy