Dennis McDermott
Freelance Database Systems and Web Developer

Tel:  +44 (0)20 8123 0528
Email:  admin@dennismcdermott.co.uk  
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.

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

Almond Art

Almond Art is a company specialising in sugar craft supplies by mail order.

I was approached by Almond Art initially to provide advice on converting their Access 97 database system to Access 2003, this system had been written many years ago by a young man who was essentially self taught, and although the database had served Almond Art well over the years it was time for a change.

I was then requested to convert the existing database to Access 2003 and provide the client with a version to test.

The client tested the updated version and then requested various updates to the functionality of the system, this was made more complicated due to the lack of a naming convention and uncommented source code.

I undertook the programming of enhancements to the operation of some of the forms and reports within the system.

Order Form

Almond Art Form


On my advice, the client then undertook comprehensive testing of the updated database before installing in a live environment, upon installing in the live environment there was a small issue regarding the application of SP3 (Service Pack 3) for Access 2003, however I remotely connected to the client's network and after a little investigation I overcame this issue very quickly.

The client also reported that a particular function was slow and had been slow in the old Access 97 version, on investigation this was due to a data access problem whereby it was taking up to 90 seconds to retrieve some data from the back-end database, I made a small modification and this process speeded up considerably to around 1 second.

Invoice
Almond Art Invoice

See examples of some of my Microsoft Access Development and VBA Programming Projects here...
Client Comments:
I originally found Dennis with a Google search; I have to say that initially I was a little sceptical about contacting someone I was not familiar with to carry out some work to our aging database.

Dennis proved to be a very good find. He firstly converted our database from Access 97 to Access 2003, he then made some improvements to forms and layouts etc. He is professional, friendly and efficient. He kept me informed at all times of his progress and any costs incurred so that there were no surprises at the end. On the occasions that he came across problems he sorted them quickly and without fuss.

We had used our database pretty much unchanged for 9 years until Dennis upgraded it, with the improvements he made hopefully there are a good few years left in it. Should I have any need for further improvements or alterations to it, I would not hesitate to contact Dennis again and I would recommend his services to anyone.

Kevin Adams
Almond Art
 
© Dennis McDermott 2001-2021  -:-  Dennis McDermott is a Freelance Access Developer at Bespoke Software Development Limited -:- Privacy Policy