Before → after
Saved 20+ hours a week on one optimization pass
Before
- Slow screens. Drivers waited. Dispatch re-keyed into Excel nightly.
- Prior developer gone. Nobody trusted the file.
After
- Indexed join paths. Split FE/BE. Queries stopped scanning whole history.
- Dispatch lived inside Access again. PDF manifest auto-emailed.
Results
- 20+ staff hours back weekly
- Fewer missed windows
- Calmer night shift
Legacy Access 2010 tuned—not tossed—until SQL made sense
That is freelance MS Access support with receipts.