Almond Art -  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  

E-mail: 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-2017  -:-  Dennis McDermott is now Bespoke Software Development Limited