A sample Excel VBA - open to bidding

Page 4 of 5 Assumptions and notes: • Please note that we have made the system simpler. Some of the details (information) or functionalities are not included such as: o Occupant details. o Tenant details are not maintained by the system. It is maintained externally. • The term rental and lease is used interchangely in this document. • Each lease will only need to be recorded once. That is only one record for the lease is made for each tenant. It is assumed that the rental fee hasn’t been increased since the tenant has rented the property. • It is assumed that the same property has never been sold to different owner before. • Please note that some of the details may not be normalised, as our intention is to cover mainly on the functionalities rather than the data recorded in the sheets. • If you are experienced in using VBA, and know things that were not covered in the materials, please do not use these (or speak to your tutor first). You must be using VBA version 6.0, (and not VB.NET which is available in Office 2013).