Project description MICROSOFT PROJECTS

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

Acquisition software - Microsoft Access, VBA, SQL Dual function as project manager

It–gr GmbH

MS Access, VBA, SQL

It–gr GmbH, Feldbrunnen

PROJECT LINK: Not available
People in the PROJECT: Stefan Troehler
PROJECT Duration: Jun 2011 - Aug 2012
PROJECT Value: SFR. 70'000.00

MICROSOFT

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

Creation of an accreditation software for the company it-gr GmbH, which automatically supported the company with the activation of projects. The Access application searched the Internet on various platforms for suitable projects, evaluated the competitor's offers and thus enabled the submission of an optimal offer. The system was developed using Microsoft Access, VBA and SQL.

  • Creation of an application for the acquisition of projects from it-gr GmbH.
  • Customer data is recorded via the user interface.
  • Costs and duration are calculated.
  • Based on the calculated values, all necessary documents such as offers, specifications, project planning (Microsoft project), order and the contract are created using VBA code.
  • The database is implemented using Microsoft Access, the logic using VBA.
  • The database is synchronized with the MS project using VB (OCX).
  • All required documents are created using VBA (from Access) in Word and stored in a file system.
  • Various graphics are embedded in the documents.
  • Interfaces to Microsoft Outlook, Microsoft Word, Shugar are implemented.
  • The automated sending of emails is implemented using VBA and stored in the database.
  • Testing and documentation (user and technical).