FAQ
Start project request!
Apply now!
VBA development Microsoft Access project database
Programming a database for project management using Access 2007 and VBA development
The full-service agency for the non-profit sector Scharrer Social Marketing (Obernburg) commissioned eWorks to develop a database to support project management: the project database. The objective was to optimize the process of project creation, project management and project implementation.
The project database was designed as a Microsoft Access database in order to manage without an additional database server and to integrate seamlessly into the client's existing Office installation. The subsequent programming was carried out using Microsoft Access 2007 and VBA ("VisualBasic for Applications").
Software development began with the design of a relational data model in the form of an Access 2007 database, which was then discussed and fine-tuned with the client. After its completion, the required Access forms were developed in order to be able to enter, list, display, edit and delete data. Subsequently, some Access reports were developed and designed according to the client's specifications in order to evaluate recorded project data and, for example, send it as an e-mail, print it out or export it to Microsoft Excel. Finally, the required additional functions were implemented using VBA development, including an Access file repository and a PDF generator for sending documents by e-mail.
A particular challenge was the requirement to be able to manage any number of file attachments of any size without causing the Access database to continue to grow. The technical solution was the VBA development of an external file repository outside the Access database, which was nevertheless seamlessly integrated into all screens and dialogs: Files can be easily uploaded, saved and reopened without increasing the size of the Access database.
eWorks developed the project database, quality-assured it, handed it over to the client and helped with installation and commissioning. Following the handover, eWorks supported its client with questions about operation and by developing minor adjustments and additional functions. Since then, the client's employees have been using the Access project database to manage their projects, saving time and money every day.