01 / Access & VBA

Develop, maintain and modernize Microsoft Access applications

For many businesses, Access applications support essential processes. I build custom solutions, take over existing systems and extend them in a controlled way.

When support is useful

  • A new application must fit established business workflows.
  • An existing Access application requires changes, fixes or maintenance.
  • The original developer is no longer available.
  • Connections to Excel, Word or database servers need improvement.

How I can help

  • Analyze forms, reports, queries, data models and VBA modules
  • Implement functions, correct defects and improve performance
  • Connect SQL Server, Oracle and other databases
  • Provide short-term assistance or ongoing application support

Technologies and practical experience

  • Access reports for invoicing and document output; automation with Excel, Word and Outlook.
  • Integration with SQL Server, Oracle and MySQL using SQL and ODBC connections.
  • Taking over existing Access/VBA applications, including reverse engineering and defect analysis.
  • Migrated an Access database backend to Microsoft SQL Server at LDBV, retaining and optimizing the existing Access frontend for SQL Server access.
Example: Bank in Bavaria (anonymous)

Moving invoice generation from Word automation to native Access reports reduced processing from around six hours or more to under one hour.