Development Microsoft SQL Server - SQL, T-SQL, VBA

Company: Swisscard AECS GmbH, Horgen

Technology: MS SQL Serve, SQL, T-SQL, VBA

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Jan 2003 – Oct 2004

Cost: no details

Support for Swiss Card in the realisation and implementation of requirements in the area of Microsoft SQL Server developments and all VBA Microsoft applications (Access, Excel, Word, Project ...), regardless of the application. Complex stored functions and complex dynamic SQL statements, Excel evaluations, Access tools and much more are realised.

• Support for the internal software development of Swiss Card in the areas of Microsoft Visual Basic 6.0, Microsoft Access 97, Microsoft SQL Server, Microsoft Visual Basic for Application and Microsoft Office (Word, Excel).
• Development of concepts and specifications and their implementation.
• Consulting internal IT in the area of database technology and DWH.
• Creation of interfaces to other applications in the non-Microsoft environment.
• Import of data from the Microsoft environment into applications from the non- Microsoft environment.
• Implementation of requirements using Microsoft VB 6.0, Microsoft Access, Microsoft Visual Basic for Application, Microsoft SQL Server, T-SQL.