Microsoft Access is an excellent tool for creating bespoke systems that have a database at their heart. It includes various wizards to speed up the process of creating a database application, and a vast array of readily available functionality. For an expert programmer specialising in MS Access, we find that development time is approximately half that needed for creating the same system using a different platform. This is a huge advantage. It translates directly into a cost-saving for you and it means that turn-around times are usually a matter of a few weeks from inception through to delivery.
2. Microsoft Access produces very user-friendly applications through its comprehensive programming language (VBA).
You may find that you can produce a very basic database in Access yourself. But with a bit of magic from an expert VBA programmer you can turn a database into a fully-fledged user-friendly application. There are hundreds of examples of how we have used programming code in our clients' systems to provide a user-friendly interface, and to automate processes - from buttons to open screens or to jump between them, to buttons to calculate and submit VAT returns to HMRC; from automatically populating one box dependent on the user's choice in another, to automatically sending out reminder emails when a milestone is passed. The end result is always an easy-to-use system that fits around the way that your business works.
3. MS Access produces flexible and adaptable database systems.
Access really scores here. Nothing in your system need ever be written in stone! Whilst it isn't as quick to make changes as it is to create systems in the first place, it is still much quicker to amend things in Access than it is in other packages. And if you need to add new bits into your system they can often be integrated as quickly as creating something new. In practice this means that Access is perfect for the real-life business world. Things change and your system can change with them - without costing you the earth, and without long time delays.
4. Well-known so you can get help and support easily.
Access and its VBA programming language are known by many developers, programmers and software companies. This means that if you create a system using Microsoft Access, you will not be stuck with the person who created it for you. So, if they move on or retire, you will not be left high and dry. One important point to note here though - you must make sure that you have the source files. These will be .mdb or .accdb files; .mde or .accde files are not source files and cannot be examined or amended by another programmer. A reputable developer will always make sure that you have the source files and that you know it! Another point to note here is that, because Microsoft Office and VBA are so widely-known, programmers' rates are lower than for other programming languages, again contributing to a lower cost to you.