Advice North Lincolnshire - Client Cases Database - Access Database FoxPro SQL Server VB VBA ASP WEB Programming - Freelance Database Systems and Web Developer

My client requested a database system to record the meeting results with their clients in the form of cases, the client requested that the system followed the same branding guidelines as their existing website.

I used the logo from the client’s website and selected colours to match.

The system was created to run under Access 2013.

The database was provided as a split front-end/back-end solution.

Outputs take the form of Excel spreadsheets, again following the clients website in design and colouring. The basis from extracting the data for these spreadsheets was a number of queries, some are quite complex due to the dynamic data that can be selected from numerous drop-downs, the system has been developed so that the content of these drop downs is completely managed by an administrator on the client’s site. The system is programmed in such a way as to ensure there is no orphan data should an administrator try to delete a drop-down entry that is in use somewhere in the system.

Clients existing website used as template for design and colour palette
Advice North Lincs website

Database Main Menu

Admin area showing the facility for managing the drop-down entries throughout the system, in this case the user is setting up the Nationalities that will be available
Drop-Down Management

This is the main form for managing cases

Many of the data entry boxes in the system were either auto completed via programming, such as who added/updated and when, or mandatory intputs, these are denoted by different background colours to simplify data entry.

Client Comments:
Dennis designed and delivered a bespoke system that enabled our partner organisations to really strengthen their client contact recording. The system has ensured our organisations are able to effectively monitor and evidence their outcomes and outputs.

Dennis was fantastic from the beginning and I can only commend him for his endless patience and ability to communicate technical information in a way that could be understood by those with limited Microsoft Access knowledge.

Dennis ensured he fully understood our requirements and worked with us to incorporate elements we hadn’t even considered delivering the system on time and within budget. I highly recommend Dennis and look forward to working with him on all our future database needs.

Lucy Stephenson
Project Manager
Advice North Lincolnshire

See examples of some of my Microsoft Access Development and VBA Programming Projects here...


	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		Advice North Lincolnshire - Client Cases Database My client requested a database system to record the meeting results with their clients in the form of cases, the client requested that the system followed the same branding guidelines as their existing website. I used the logo from the client’s website and selected colours to match. The system was created to run under Access 2013. The database was provided as a split front-end/back-end solution. Outputs take the form of Excel spreadsheets, again following the clients website in design and colouring. The basis from extracting the data for these spreadsheets was a number of queries, some are quite complex due to the dynamic data that can be selected from numerous drop-downs, the system has been developed so that the content of these drop downs is completely managed by an administrator on the client’s site. The system is programmed in such a way as to ensure there is no orphan data should an administrator try to delete a drop-down entry that is in use somewhere in the system. Clients existing website used as template for design and colour palette Database Main Menu Admin area showing the facility for managing the drop-down entries throughout the system, in this case the user is setting up the Nationalities that will be available This is the main form for managing cases Many of the data entry boxes in the system were either auto completed via programming, such as who added/updated and when, or mandatory intputs, these are denoted by different background colours to simplify data entry. Client Comments: Dennis designed and delivered a bespoke system that enabled our partner organisations to really strengthen their client contact recording. The system has ensured our organisations are able to effectively monitor and evidence their outcomes and outputs. Dennis was fantastic from the beginning and I can only commend him for his endless patience and ability to communicate technical information in a way that could be understood by those with limited Microsoft Access knowledge. Dennis ensured he fully understood our requirements and worked with us to incorporate elements we hadn’t even considered delivering the system on time and within budget. I highly recommend Dennis and look forward to working with him on all our future database needs. Lucy Stephenson Project Manager Advice North Lincolnshire See examples of some of my Microsoft Access Development and VBA Programming Projects here...

Clients and Projects