Case study · Custom development

From Access to a shared assignment database. For the Berliner Mobilitätshilfedienste.

The mobility assistance services accompany older people in twelve Berlin districts on foot and on public transport. For more than twenty years, they managed their assignments with an Access application. We replaced it with a shared database and migrated the data.

Koordinationsstelle der Berliner Mobilitätshilfedienste, Tobias Baur Berliner Agentur für Soziales UG (haftungsbeschränkt). The services are run by non-statutory welfare organisations and funded by the Berlin Senate Department for Labour, Social Services, Gender Equality, Integration, Diversity and Anti-Discrimination.

12 districtsAccompaniment from age 60Funded by the State of Berlin

Provider organisations
  • Sozialverband VdK Berlin-Brandenburg e. V.
  • Unionhilfswerk Sozialeinrichtungen gGmbH
  • Diakonie-Pflege Verbund Berlin gGmbH
  • DRK Berlin Südwest Soziale Arbeit, Beratung und Bildung gGmbH
  • Volkssolidarität Berlin e. V.
  • Humanistischer Verband Berlin-Brandenburg

Starting point

An Access application that grew over more than twenty years.

The application was installed locally on every computer at the services. As a result, the data was spread across the individual services.

There was no technical documentation.

What we built

One database for all services. Each service sees only its own data.

All services work with the same application in the browser. Clients, staff and assignments are kept separate for each service.

Clients

Create, edit, archive and export as an Excel or CSV file.

Staff

Contracts, language skills and competences such as first aid or wheelchair training. During planning, the application shows who is eligible for an assignment.

Assignments

Record and plan, as a list and in a day view by staff member and time.

Assignment sheets

Created from the planned assignments of a day, for the whole service or for individual staff members.

Reporting

A guided export for the reports to public bodies, as a PDF or Excel file. An analysis shows how the figures are arrived at.

Master data

Project number, provider organisation, district and head of the service. Duplicate records can be merged here.

Data migration

More than twenty years of data migrated. Without documentation of the old application.

Step 1

Exported

Extracted the existing data from the Access application.

Step 2

Standardised

Brought data kept in structurally different ways into a uniform and clear structure.

Step 3

Imported

Loaded into the new database. The services continue to work with their history.

Approach

First a prototype, then improvements based on use.

  1. Assessment We looked at what the old application does.
  2. Prototype Instead of a requirements specification, there was an early version to try out.
  3. Improvement in rounds Improved in several rounds, based on how the services used it.
  4. Operation We run the application.
  5. Ready for changes If the services’ processes or requirements change, we develop the database further to match.

We appreciated that we were in continuous contact about questions, change requests and corrections. This was always so easy to understand that even those involved without a technical background could follow how the database works and how to use it.

In the process, czichos.net not only implemented our ideas but also contributed its own constructive suggestions that advanced the development of the database.

We were always able to resolve points of conflict, which naturally arise in a project like this, quickly and without red tape in direct discussion.

In addition, the database can be developed further in terms of content. It is therefore also able to meet future technical and conceptual requirements.

We can recommend working with czichos.net.

Berliner Mobilitätshilfedienste (translated from German)

Further reading

The services’ website and the user manual are publicly available.

The Berliner Mobilitätshilfedienste

Who is accompanied, in which districts and how to use the service.

berliner-mobilitaetshilfedienste.de (in German)

The user manual

The guide to all areas of the application. It is linked in the application itself.

Open the manual (in German)

Tell us about your project. We tell you whether and how we can help.

Describe in a few sentences which application you want to replace or build from scratch. We get back to you and arrange a call.

Without obligation. Before work starts, you receive a written quote.

Prefer to reach us directly? Send an email · call +49 30 994048000

Address czichos.net GmbH
Königsweg 220
14129 Berlin, Germany