MS Access, VBA
Adecco, Wallisellen
Persons in the PROJECT: Stefan Troehler
PROJECT Duration: Mar 2002 - Jun 2002
PROJECT value: SFR. 00,000.00
Creation of an application for the management of folders using Microsoft Access for the corporate management of the company Adecco. The folder, its content, the storage location in the form of the shelf and the exact location on the shelf are cataloged. An interface for the import of existing Excel files is implemented. The application is developed using Microsoft Access and VBA.
Responsible: To plan, coordinate and control the project efficiently. Traditional instruments such as network planning, project cost planning and resource planning help him to do this. The newer planning instruments also include the project definition, the analysis of the project environment, the project structure planning and phase-related workshops (project start, milestone, project completion workshop).
- Creation of a system for the administration of the physical business folder filing of the management of the company Adecco in Wallisellen.
- For every existing folder in the company, the contents of the folder, the physical location, the documents contained, the time period of the documents and search terms.
- All data is stored in a Microsoft Access 2000 database.
- The user interfaces for data management are developed using Microsoft Visual Basic for Application.
- The folder label and the folder directory are automatically created from the data entered.
- A fuzzy search according to the search criteria (Soundlike algorithm) is integrated.
- Various lists are created using Microsoft Access 2000 reports.
- Requirement engineering, data model using Dezign.
- Implementation of customer requirements using Microsoft Access 2000 and Microsoft Visual Basic for Application.
- Testing and documentation (user and technical).
- Acquisition of the customer.
- First clarifications regarding the project with the customer.
- Creating an offer.
- Creation of the contracts.
- Pre-financing of the project by the holding company shs-g AG.
- Requirements recording with the customer.
- Provision of resources (developer).
- Provision of the required infrastructure.
- Provision of the specifications and approval of the specifications by the customer.
- Project management, budget monitoring, resource planning and resource monitoring.
- Technical management in the project.
- Monitoring the outsourcing of customer infrastructure.
- Provision of the customer-specific required hardware.
- Prepare the accounts for the customer and report to the customer.