Air Condition Subsidy Database – 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