Copyright © Geckodb 2024. All rights reserved.
Rosies – Friends on the Street
Industry
Charitable Organisation
Technologies
Microsoft Access, Microsoft Outlook, Microsoft Excel
Project Brief
Rosies – Friends on the Street approached Geckodb to develop an application to manage their volunteer membership list, outreach roster, community events, and attendance schedule.
Developed Solution
A Microsoft Access database application was developed allowing staff to easily manage their data capture requirements of volunteers, and record details of their outreach, and community events.
The application provides detailed reporting for managers in relation to volunteer, and patron attendance at organised events, and gives team leaders the information required to work with volunteers, and stay on top of their training requirements. Formatted reporting was developed using Microsoft Access Report objects, which in some cases are sent as PDF email attachments using Microsoft Outlook automation. Microsoft Excel automation is also utilised to export large.
The Hart Centre
Industry
Counselling
Technologies
Azure SQL, Microsoft Access, Microsoft Outlook, Microsoft Excel
Project Brief
The Hart Centre Appointment Manager was built as an easy-to-use platform for generating, and managing client bookings for in-house, and external counselling sessions.
Developed Solution
A hybrid solution was developed by Geckodb consisting of a Microsoft Access application interface with a cloud hosted Azure SQL database. Azure offers great flexibility, allowing staff to work from a variety of locations, and industry standard security to protect the sensitive data of their clients.
The application interfaces with the Xero accounting platform to afford a simple means of keeping on top of their bookkeeping requirements without double handling data.
A third-party SMS texting service provides automated, timely reminders to clients of upcoming appointments, and pertinent information.
Formatted reporting was developed using Microsoft Access Report objects, which in some cases are sent as PDF email attachments using Microsoft Outlook automation. Microsoft Excel automation is also.
Goodhew’s Refrigeration Service
Industry
Hospitality
Technologies
Microsoft Access
Project Brief
Goodhew’s is a refrigeration hire & sales service in Brisbane, Australia. Goodhew’s engaged Geckodb to provide an efficient solution to their data capture, and information management needs to specifically streamline the rental side of their growing business.
Developed Solution
Previously, Goodhew’s were using a combination of Microsoft Word, Excel, and paper-based files to manage an increasing number of clients, and jobs. Geckodb worked closely with Goodhew’s staff to develop an intuitive application built with Microsoft Access. The solution is a bespoke CRM with subsections to manage stock, rentals, and the ongoing maintenance requirements associated with their hire service.
Reporting was developed using Access report objects. Everything from generating contracts for new customers, through to summarising current stock rentals, and accounting requirements are generated as printable, or exportable documents.
The Centre for Women & Co
Industry
Counselling & Mental Health
Technologies
SQL Server, Microsoft Access, Microsoft Excel
Project Brief
The Client Support Database is an application originally developed by Geckodb for the Centre Against Sexual Violence to fill a need for concise, accurate, and affordable data capture within the Women’s Health & Counselling sector. The Centre for Women & Co. sought the services of Geckodb to customise their own version of the Client Support Database to manage client details, case notes, and reporting in a way that best suited their specific needs.
Developed Solution
The Client Support Database is a package that includes a Microsoft Access user interface with an SQL Server backend. Intuitive data entry forms provide the basis of record collection, while powerful search tools allow users to quickly find existing clients and previous case note entries based on a broad set of user defined criteria.
Reporting in the form of formatted lists through to complex statistical metrics are built on Microsoft Access reporting objects. For ad-hoc reporting, Microsoft Excel is used to export large filtered sets of data which provides flexibility for occasions where a formatted reporting template is not required.
Commodity Inspection Services
Industry
Laboratory Services
Technologies
SQL Server, Microsoft Access, Microsoft Excel, Microsoft Word
Project Brief
Commodity Inspection Services approached Geckodb to develop a Laboratory Information Management System (LIMS) for the collection of data relating to imported/exported commodities. A significant requirement was to create an efficient platform for recording internal testing of commodity samples, and provide concise, accurate analysis reports for their clients.
Developed Solution
The completed project consists of a Microsoft Access application which was used to develop an intuitive user interface, while the backend takes the form of an onsite hosted SQL Server database. SQL Server was a great solution due to its scalability, security, and enhanced performance.
Analysis reports are generated using Microsoft Word automation where they can be further edited if required, or sent to a client saved in a variety of formats.
Microsoft Excel is used to generate detailed QC analysis, and provide at-a-glance KPI reporting.
Dalrymple Bay Infrastructure Management PTY LTD
Industry
Mining
Technologies
Microsoft Access, Microsoft Outlook, VB.NET
Project Brief
Dalrymple Bay Infrastructure Management engaged Geckodb to redevelop their legacy in-house Microsoft Access application which managed construction projects for their export terminal near Mackay, Queensland, Australia. The new application needed to be intuitive, efficient, and streamline existing processes.
Developed Solution
Working closely with DBI staff, Geckodb developed a solution consisting of a new Microsoft Access database with an overhauled user interface to manage all aspects of their construction projects. The application utilises neat, logical forms for data entry, and formatted reporting to cleanly present summarised data. Detailed, stylised documents can also be generated at the press of a button for submission to their clients either electronically, or physically.
One of many critical aspects defined within their scope was a need to effectively keep track of the numerous incoming, and outgoing emails relating to individual contracts. The solution was to develop a Microsoft Outlook add-in using Visual Studio, and the .Net framework. The add-in has subsections for incoming and outgoing emails, and with minimal user interaction, scrapes data from an email to generate a record in the contract management database completing key fields, and saving a full copy of the email file which can be accessed by any user of the application.
