Asset Leasing System
This page is a brief illustration of the sort of Microsoft® Access database I've developed for clients.
Last updated on 2024-04-26.
Background
The client for who I created this database leases vehicles, office equipment, business machines, furniture and so on to other businesses, to education and to local government.
The database tracks the allocation of assets to customers, the terms of the accompanying lease contract agreements and any extensions and amendments to leases.
A user navigates the System from this System Switchboard. This Switchboard is an example of the use of dropdown lists for navigation of the database in preference to screens full of buttons.
16 Years of Development and Refinement
Work on this System started in 2001. At the time it was considered a stop-gap while the client awaited incorporation of lease managment into their centralised data processor. This did not happen.
2002, 2003 and 2004 saw significant additional development of the System as it grew to be a key business tool relied upon by the client for the function of this aspect of their business. This further development included upgrading from Access 97 to Access 2003.
2005 to 2011 saw further enhancements. In 2011 I upgraded the System to Access 2007.
Thereafter, I continued to support the system on an ad-hoc basis.
In 2016 I upgraded the System to Access 2010 64 bit.
In 2017 the client and I agreed that continuing on an ad-hoc basis no longer suited both parties: I assisted in appointing a company to continue caring for the System on a 24/7 basis.
Provision for Reporting
The comprehensive suite of reports, as listed in the System Switchboard, grew over the years as the client zeroed in on the possibility of exploiting their data for business advantage.
The Management Reports present summaries of historic, current and predicted future activity, from different business perspectives.
Users responsible for the input and upkeep of records have support in their efforts through Administrative Reports.
The output to Excel reports make data available to those who want to perform their own what-ifs knowing they will not compromising the primary data.