Project description MICROSOFT SQL SERVER PROJECTS

Microsoft development, database development and database administration, web portals and OO development...

Microsoft Access, VBA, Microsoft SQL Server - Developer / Consultant

Celanese, Utzenfeld

MS SQL Server, MS Access, VBA

Celanese, Utzenfeld

PROJECT LINK: Not available
Persons in the PROJECT: Stefan Troehler
PROJECT Duration: Sep 2019 - Feb 2020
PROJECT Value: SFR. 00,000.00

SQL

Project portfolio
0
HOURS REQUIRED
0
CUP OF COFFEE
0
LINES IN THE CODE
0
EXPERTS IN THE PROJECT

Maintenance and adaptation of existing applications in Microsoft Access and in Microsoft Excel to meet new business requirements. Documentation of existing applications, clear design of the applications as well as technical documentation and user manuals.

Inventory:

Completely new solution for the inventory application for recording the inventory of the two locations in Utzenfeld and Wehr. The new applications were built on the logic of the existing old applications, but the user guidance was implemented in the form of a process. The new application was implemented using Microsoft Access, SQL, VBA.

Labels:

Adaptation of the label printing company using list and label and the associated Access database. Setting up the label printer and commissioning the application. The application was created using Microsoft Access, VBA and Microsoft Access forms as well as various queries implemented using SQL.

Various applications:

Creation of technical documentation, creation of a user manual, recording of the business processes as well as revision of the existing, partly inadequate VBA code. About ten applications in the area of ​​administration and production increase have been revised.

Evaluations :

Creating various evaluations using SQL in Microsoft SQL Server, exporting the data to a Microsoft Excel application and transferring it to the corresponding business unit. These are mainly ad hoc reports or evaluations.

  • Adaptation and further development of various Access applications.
  • Adaptation and further development of various SQL Server applications.