Crawford Software Works

Legacy MS Access Database Modernisation & Migration Plan

Review and modernisation plan for a legacy Microsoft Access database, including schema cleanup, migration strategy, and future-ready web admin options.

Overview

This project demonstrates how a legacy Microsoft Access system can be reviewed, stabilised and prepared for migration to a more scalable database platform such as MySQL or PostgreSQL.

Many small businesses rely on Access databases built over time, often with duplicated fields, inconsistent data entry and limited reporting. This project focuses on identifying the existing structure, improving data consistency, documenting relationships, and designing a migration path that reduces risk and downtime.

The end result is a practical roadmap for moving from a desktop database setup to a modern database-backed web or desktop system while keeping business operations running.

Project details

Category
Database

Key features

  • MS Access database review and structure audit
  • Table relationship mapping and data cleanup planning
  • Duplicate field / inconsistent data checks
  • Migration planning to MySQL or PostgreSQL
  • Data validation rules and field standardisation
  • Reporting and export compatibility planning
  • Risk-reduction approach for legacy systems
  • Option for phased migration (not full replacement at once)
  • Admin workflow redesign for future web interface
  • Documentation for maintenance and handover

Tech stack

Microsoft Access (MS Access) SQL migration planning MySQL / PostgreSQL target schema design Data normalisation Import/export mapping (CSV / structured transfer) PHP admin dashboard planning (optional extension) Query optimisation and indexing strategy

Want something similar?

Tell us what you need and we can plan a version tailored to your workflow and budget.

Start your project