The development and support of three MS Access 2003 databases. The Gas Grantor Database maintains a record of Land Owners and Occupiers who grant permission for National Grid’s Gas and/or Electricity Transmission pipelines to transgress their property. The Enquiry Management Database logs enquiries made with regard to the proximity of Gas and Electricity transmission assets to any proposed building work. The Hospitality Database generates invitations to County Shows, it records responses, and allocates event day tickets and lunch sittings. All databases perform letter generation, and maintain a record of correspondence.

The development and subsequent support of several LAN based Databases using MS Access version 2000. This included an Immigration database to monitor the legal costs of asylum seekers, a Dormant Cases database to clear a back log of cases, an Accreditation database to record the qualification status of Immigration Case workers, and other office administration databases.

Two of the databases maintained an interface with the LSC’s SQL Server database, and other databases interfaced with MS Excel and with MS Word to provide automated initial and follow up letter generation. Most of the development was undertaken at my home with me typically visiting the LSC’s London offices, two or three times a month to implement phases of development.

Support and enhancement of the consultancy’s existing Access databases. Development of MS Access Change Request System. Access Version 97 and version 2003 systems. Also some development using ASP.NET 2.0 and MS Visual Web Developer.

I developed a comprehensive MS Access XP application to track the staged process of a clinical assessment. Interface with existing NHS structure database. Heavy use of Word Automation to generate documents associated with many tasks throughout the assessment procedure. This involved the creation of a bookmark vba project within Word, allowing users to easily build document templates incorporating a selection of data from the database. All File & Folder management is controlled from the database application.

Development of eight new MS Access Database applications, as well as enhancement and support of several existing MS Access systems. Development included a File Tracking application which incorporated a barcode scanning feature. This application was deployed on several Laptop computers, with data synchronised to both the File server and SQL Server. Development also included a Project Office Time Recording System. I also implemented an Application Starter Menu system using Visual Basic 6. This allowed users to configure their own Application suite whilst the IT Support team retaining central administrative control over the applications made available.

Development of a Capital Allowances Database to calculate tax claims against Capital Projects. The administration functionality includes a fully audited and controlled import of base data from alternative spreadsheet formats, annual data management and selection including a brought forward/carry forward data roll over, and a Euro/Stirling conversion option. 11 flexible parameterised reports and Excel exports are provided. A transaction screen allows search, selection and filtering of Project records.

I developed and subsequently supported a Promotional Effectiveness, Planning and Analysis Tool running on Head Office file server and individual Account Managers Laptop computers. The system was developed using MS Access 2000 and it’s Developer Toolkit (Runtime distribution).

The system allows Account Managers to enter details of individual store promotions. This was combined with volume uplift marketing information, from a third party. A full analysis of sales volume and profit, for both the store and for Walkers is calculated, displayed over several screens and reported. The system incorporates bespoke replication, to maintain synchronisation of data between Head Office and Account Manager’s Laptops .

I developed a Time Recording System for the NT&T Business Unit. The system allowed 125 LAN based users, and up to 50 remote users, to book their time to Project and to a three tier hierarchy of Product, Activity and Task, on a daily basis. The system incorporated a synchronisation process instigated by the remote users over a dial up or wide area connection. 10 flexible parameterised reports and Excel exports were provided, and full administrative facilities for users with varying levels of authority. Maintenance of the Product, Activity and Task hierarchy was provided by an interface based upon the TreeView ActiveX control. I also completed a comprehensive Technical Specification, and provided post- implementation support.