Web based services
XHTML, PHP, Javascripting
MySQL database driven content
CSS, User sessions, cookies
RSS data feeds, Google maps

Single user applications
Access database storage
MS Office user interface
Excel reporting
VBA integration

Client/Server applications
Oracle database plus PL/SQL
SQL server plus T-SQL
VB/VBA GUI & business logic
Excel, Access or Brio reporting
  • Home
  • Projects
  • Database
  • Websites
  • PC Support
  • Consultancy
  • Contact Me
Sample projects previously undertaken
Web related
  • Catalogue service - user profiles, sessions, multi-currency, country specific tax calculator
  • Public event web calendar - password secured administration, email notification of event submissions
  • Charity site (church) with public event listings, RSS feeds, Google map integration, secure online maintence
  • Modularised site (artist management) with browser based security controlled maintenance, image upload, integrated html editing of content
  • Online reference subscription service with database generated pages, session security, selective content search and sorting, user reporting and javascripted PayPal interface

Access database related (max 5 users)
  • Membership database (charity) - role/committee management (mailmerge, labels, ...)
  • Whereabouts diary management (contacts, time scheduler, reporting)
  • Church stock control (Orders, Sales, Valuations, Cash Till management) with Excel reporting
  • Classroom management system (Teachers, Students, Classes, Assignments, ...)
  • Application and Product bug tracking, issue logging, reporting and resolution management

Large Scale Multi-user Applications (Multi-tier client/server)
  • Document Management System with file change tracking (Oracle, Access, VBA)
  • Parameter driven Excel report generator to facilitate preview and printing of multi-worksheet reports inclusive of logos, photos and AutoCad graphics (SQL Server, VB, VBA, Excel)
  • Reporting wizard for client and management reporting with context sensitive help (SQL Server, Excel, Robohelp)
  • Management console to link, extract, consolidate and apportion cost data using disparate data sources (Access, DB2, Excel, Lotus 123, CSV)
  • Role-based security ActiveX to manage user navigation and database access
  • SQL code generator for multi-language trend reporting
  • Reporting interface for a course scheduling system