Scotia Gas (formerly National Grid Transco) needed to replace Lotus Approach systems with Microsoft technologies. Engaged to develop a new solution and consolidate / migrate data from multiple Approach databases into Microsoft Access 2000. Engaged with business users; analysed Approach datasets; designed and developed replica of existing DBs using SQL, VBA and ADO; created migration plans; consolidated data; and led migration to a client-server design Access 2000 application. Delivered a robust application that Scotia still use today.