Task one: Create an application using Microsoft Access for the calculation and reporting of the TAX calculations for Italy and France. The application includes the import of the tax files taking into account weekends and holidays, the listing of the imported files as well as the possibility to store remarks regarding the imported files. The second area of the application allows for correction entries in relation to the imported data and the third area of the application creates a reconciliation between the financial data of the core application and the financial data imported by the system. The application was implemented using Microsoft Access (backend) and the frontend was also provided in Microsoft Access using VBA.
Microsoft Access-Developer/ Berater - Microsoft Access, Microsoft Excel, VBA, SQL Server, T-SQL, Jira, SAP, Oracle, DWH, Microsoft SQL Server, SSIS, Alterix
Project SDLC Reporting
The project consists of several databases, which contain the tables needed to import the data, the queries needed to refine the data, the macros needed to execute the workflow, which in turn are started by the Power Shell scripts and in turn call the functions and procedures developed using VBA. Each of these individual databases can be compared to an ETL route. Further databases consolidate the data for reporting with regard to the SDLC reports. Procedure for executing the entire application: Power Shell scripts call the macros, which in turn call the complex VBA logicians for importing the data, cleaning the data and consolidating the data. The entire application was developed using Microsoft Access, VBA and Power Shell.
Adapting and extending an existing Microsoft Access solution. Originally, four files were imported, the data was refined and then evaluated. The evaluations concerned the distribution of the company NEF in Germany. The user interface already existed, realised with Microsoft Access and VBA; this was made a bit more modern and clearer and the new functionality was integrated. In the new application, only two files are now imported and the data is evaluated on the basis of the two files. Again, the import is done by VBA, the user interfaces have been adapted to the two new files and a lot of plausibility logic has been implemented. The evaluations concern the warehouse stocks and the warehouse stock values of the individual employees in distribution.