The most important part of the database software development process is for us to understand exactly what you require before we look at the software design timetable, coding and functionality. The more time spent discussing the work to be done – by phone, email or in person – the better the resulting design will be. We want to understand your business, what you would like to do with the data you already have, how we might populate a database with information such as contacts, sales items, etc. We need to discover whether an in-house or web application (or both) best suits your business. And often key to your requirements will be outputs produced by the database: sales reports, lists, finance, emails, letters, Excel exports, Word merges, and so on.
Once we have completed requirements for the work, we proceed to database software development and then installing an initial version. After your feedback and further development, we will install the final version, our standard period of 1 year’s support begins, renewable every year.
Designing the Access database alone is not enough to provide the processing and functionality you need. We use Miscrosoft Visual Basic for Applications to manipulate the data you require in order to provide you with what you need on screen and in reports.
Our work isn’t finished when we have a database and have imported all your data, and designed the functionality you need. Just as important is the look, feel and intuitiveness of the design on screen. Our experience over many years has refined our ability to select fonts and colours which are easy on the eye. We also look carefully at how navigation works, moving from one screen to another, using buttons, filtering reports.
Your data needs to be secure within your office, and beyond if your application is used on the web. We can provide secure hosting for your data. And where there are two or more users, we can design individual and group login routines to allow users to access or edit your data within the application, depending on the permissions they have.