our work for you

about us

our technologies

sql server

Access, VBA, Microsoft SQL Server – Microsoft Competence

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.

sql server

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.

sql server

Microsoft Access, VBA, SQL Microsoft SQL Server / Consultant

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.

sql server
Add your project
If you want us to perform your project, upload all the necessary data and we will be happy to discuss with you all the details of our cooperation.
Name
E-mail
Want to order
Upload your brief
For message
Send Message
Order a template
To install and configure the theme, you need to specify your billing details and hosting data (FTP, PHP admin logins, passwords). After that, our specialists will install the template and you can test it.
Name
E-mail
Want to order
Hosting data and databases
For message
Send request
Add your Review
If you have worked with our company, you can add your review using the form below. Upload your review in A4 format (Microshoft World), Youtube url, text...
Name
E-mail
Upload your review
URL video-feedback Youtube
Write a review
Post a review
Add your review
If you have worked with our company, you can add your review using the form below. Upload your review in A4 format (Microshoft World)
Name
Upload
Post a review

User Agreement

With this questionnaire (application) I officially express my consent to the processing (collection, systematization, accumulation, storage, clarification, (updates, changes), use, distribution (including transmission), depersonalization, blocking and destruction), including automated, my personal data specified in this Questionnaire (application), in accordance with the requirements of the law "On personal data".

The personal data specified by the client are provided for the purpose of communication with the client, as well as for informing about other products and services. Consent is provided from the moment of filling of this application for the entire life of the client.

This consent can be revoked by the client upon submission of an application in simple writing in accordance with legal requirements.

+41 (0)44 586 53 45

+41 (0)76 737 00 84

+41 (0)77 915 25 52