Task and Resource Scheduling Database Built in Access
Our client provide regular and ad hoc lawn maintenance services. The business is well established and uses an existing Microsoft Access database, running on Access 2010, to maintain customer and lawn treatment records as well as generating invoices and customer mailings. The client needed to update the database. In particular, they wanted to develop a paperless approach to customer communication.
The Solution
Xlteq Access Database Consultants redesigned the legacy database to include new screens and functionality.
The Process
Developing a legacy Access database with the file and table structure already in place can add extra complexity. As well as the requirements in the proposal, there were a number of functions that were working and needed to retain their existing logic. Screens and queries were redesigned but, where possible, existing processes were not amended, this had the added advantage of making testing easier.
The existing menu system was insufficient, so the new screens needed to be branded and designed around a Switchboard Menu System. Existing screens from other functionality also needed to be updated where necessary to reflect the new look and feel of the database.
The new design included a number of new Customer Configuration Flags and the delivery mechanisms for communications was extensively overhauled.