Even in a programming "language" as ugly as VBA, it is still possible to do proper coding instead of just scripting. I quote my boss at that time: "Why are you using more than one module? Why not put everything in one function?"

You may laugh at it, but for all those little tasks, even in a big corporation, MS Access is a good tool. It costs little, can be quickly developed and deployed, and you don't need an SAP developer for a few hundred bucks per hour. Of course, one needs to know the limitations and concerns: MS Access is only for smaller databases (up to 1M records in my experience), is NOT secure, and also not especially reliable. But for internal purposes, it can do a few tricks.

Btw, most of the code I had inherited from my predecessor made my eyes bleed. Needless to say, mostly I preferred to start from a "clean slate". That said, developing Access appz is not something I'd look forward to doing again :p

Good thing that there are finally macros in .odb files - and shocks me that before, there hadn't been?! Well, last time I played with Base was some time ago, and I was appalled at the features (or lack thereof), being a former Access developer. TFA makes me want to play with the new version, see if it is at least possible to create simple applications with it.

So it could be inhabitable, it might have an ocean, and maybe there are aliens that look like E.T. living there. Maybe. But does it have a Stargate?

Well, if you ask the people, that's what you get ;)