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

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

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


	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 Air Heating (Southern) Ltd. Almond Art Alpha Impact Ltd. Art du Midi Blairgowrie Guest House Broadway Records Bruce Burlington & Co. Ltd. Buy it Here Cachet (London) Ltd. Camping La Corconne Canon Consumer Imaging Careys Private Hire Dartford Council Dellcourt House Denew DIY or PRO DIY or TRADE ESAB Excel IT Ltd. 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 Moving Ahead Online Ltd. MSL Medical Pepperneck Pro-Talk Regent Carriage Services Rail Professional Development Save Your Feet Sea Containers Shopping Alley South Essex Gymnastics Club South & East Essex Training Group Standish Metal Treatment Ltd Sunnyseek Sunnyseek World The Digital Donkey The Gifted Goat The Fashion Fish The Furnished Frog Trade and DIY The Holiday Hippo The Lamp Company 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 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 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

Clients and Projects