brief descriptions of some projects

british american tobacco
This database project was based around the collation of marketing data from across the world into a single reporting tool. Each market supplies its information by filling out a spreadsheet based form.
The data from these spreadsheets is imported into a central Access database which generates reports and calculations based on the accumulated data.

walt disney
This database project involved the tracking of Disney’s promotional activities across its markets in Europe and the Middle East. The user interface and programming was created in Access with the data held in a SQL Server database networked across the international offices.
A major aspect of this system is the ability to generate ‘calendar view’ spreadsheets showing an overview of the activity across markets and time.

barclays bank plc
Developed in Excel, this project involved the creation of a three-tier series of spreadsheets for tracking performance targets across branches, regions and nationally. Each tier of sheets would collect data from the import of data from a lower tier along with the addition of data relating to that area.
The system provided the ability to view performance from a national summary down to an individual branch’s detail.

hampden group
The structure of this group of companies meant that generating accounts for the whole group or subset of companies was a difficult process.
This Access database project imported accounting data from each of the 30+ companies in the group and then generated balance sheets, P&Ls and other accounting reports based on data. Using this software it is possible to choose which companies to include over the selected period and also apply a whole range of options to the reports. The reports themselves where generated in Excel and where completely formatted in the Hampden accounts style ready for printing.

bt/turner townsend
Turner Townsend were managing a project to upgrade BT’s infrastructure. The scale and complexity of this project required data to be collated from a large number of sites and reported on weekly and monthly.
This project used an Access database to import the data from the sites and then generate Excel based reports for the selected periods and geographical areas.

bds beechwood
Developed for BDS Beechwood advertising agency on behalf of one of their clients, this project entailed building a series of templates in Microsoft word that would prompt the user to provide relevant data and then generate a particular format of document based on the input.
Although Word is a less common vehicle for extended programming, this project shows that there are possibilities to automate tasks and control consistency.

oc&c strategy
There are occasions when even a database can’t provide the answers!
OC&C’s customer database allows them to track and organise their companies’ relationships with great flexibility and power. It is based on a SQL Server database with an Access front end application. The relationships tracked in the database are very complex and generating results for certain tasks had become impossible.
We added some additional programming to enhance the interface and provide solutions for the tasks which standard database programming alone couldn’t solve.