MS Access VBA programming

MS ACCESS is a Rapid Application Development ms-office application, that is rarely used nowadays by programmers, obviously it's because it was designed for non-tech savy person to develop applications with no or minimal coding requirements.

MS-ACCESS, if to be taken seriously as one programming tool, it could not just develop simple applications, it could also handle enterprise level SQL as backend database.


So you wonder why majority of programmers doesn't use MS ACCESS instead. Most programmers tend to choose a particular programming based on the language popularity or work demands, it could have been directed upon from the IT director as a general standard tool of the web/software development department for good reasons.

The real beauty of MS ACCESS is, you could develop real database applications requirements in less than a week, which usually could take 3 to 6 months compared to other programming languages.

For instance, you could create one database application in just one file, and it contains all the underlying building blocks of the applications like Forms, Tables, Data/Grid views, SQL queries, and Reports, all of which could be done thru the wizard, or manually if you feel like tweaking or adding some customized codes.

This is not my main programming language either, but for general back-office requirements, i've used MS ACCESS on small projects like Income Tax Calculator and Tax Report printing. I've also created a freelance project like Bus booking (reservation system), and Product Catalogue Management which has at least less than a million records, and done each in less than one week.

No comments:

Post a Comment