Database Management Archives

12 05 2023

Ground Rent

The Ground Rent application is an MS Access application which tracks rents of various properties in the Baltimore (U.S.) area. We were contacted by Web Works on the US east coast for specialty diagnosis and debugging of an issue relating to incorrect year and incorrect rents being generated by the system. The problem for them was causing hundreds of hours of manual billing needing to be generated. We investigated the existing VBA and SQL code, and our fix saved them hours of time, as well as getting the rents correct and able to be sent out by them with confidence.

Ground Rent - MS Access

12 12 2022

Air Condition Subsidy Database – MS Access

admin Database Management, MS Access

In the beginning of 2022 a new business rule was negotiated which granted teachers in the WA Education system, who were stationed in remote areas, an extra 15 days subsidy at both the beginning and the end of their usual subsidy period. This decision, although seemingly quite simple, meant there was a complete new algorithm needed within the existing Air Conditioning subsidy database in order to appropriate funds correctly on masse.

Air Conditioning Subsidy Front End User Interface - MS Access Database

The front end user interface of the application.

Air Conditioning Subsidy Back End Database - MS Access Database

Housing Allocation System (H.A.S.) Back End Database Structure and Reports – MS Access Database

03 08 2017

Housing Allocation System – MS Access

admin Database Management, MS Access

In 1997 the Western Australian Department of Education commissioned a small local IT company to write them a software program that would help them manage their housing. The role of this branch of the W.A. Education Department is to take care of housing requirements of employees that have been appointed to regional and remote areas within the vast state of Western Australia. The Housing Allocation System was born, written originally in MS Access 1997 version. Nearly 25 years later, the Housing Allocation System, or HAS as it is known within the Education Department, is still going strong!

“Gavin has worked at changing and improving the Housing Allocation System (HAS) over many years. He is extremely competent with MS Access and always delivers what we require. He is always very helpful with managing the flow of our data between different government agencies” – Wayne Sieber, Housing and Transport Officer, W.A. Dept Of Education