Once upon a time - in the early years of PCs, we used MULTIPAN and DBase. I instantly learned that database-supported work offers many advantages compared to traditional paperwork. It was easier, faster and less prone to errors, what aroused my interest very easily.
The system evolved over the years and VBA (Visual Basic for Appliations) extended the range of possibilities widely: Connecting various office programs and other applications via VBA combined database content with mass formula calculations and automated word processing. And the results can be presented highly professionally.
Nowadays it doesn’t matter what underlaying database is used, Informix, Oracle, SQL or Access, the application an it’s user interface is just the same one.
So MS-Office using VBA is the little step to office automation: You can do a lot of every day typewriting or with one simple click all is done.
For that I can offer you a wide range of support – data analysis, restructuring and migrations.
MS - Access
The MS Access database is not only a very useful data management system, but also a programmable interface for other databases (SQL server, Oracle, etc.).
Programmable not only on the table and query level, but also for intelligent forms, self-healing interfaces, other systems (eg SAP) and databases. Web-Forms and integration in Sharepoint round off the Access world. Even in the private life has MS-Access with me.
Whether it is to freeze logistics with shopping guide on the Smartphone APP or the TV program filtered intelligently to my personal interests: MS-Access and VBA are an integral part of my life.
Complex data landscapes tend to become increasingly complicated by historically grown backpacks and workarounds. Also, combinations of many, many local Excel tables and CSV files make a consistent, central data retention often impossible. That is the moment when the actual, main data structure has to be recognized, duplicates, redundant data and unused data fields need to be eliminated and a central user interface has to be created or released.
Governance principle: Only really required data is stored (minimalistic approach), the comfortable displays are generated by queries and calculations.
In most cases migrations are restructurings as well. But changing (or upgrading) the database system causes the examination of additional factors as new built in functionalities of the target database system. For example, auto-numbers, triggers, stored procedures, etc.