About this blog

Built by someone who actually uses Access

Real-world database experience, translated into tutorials you can apply today.

Anthony Passeri, MBA

Anthony Passeri, MBA

Microsoft Access Specialist

I've been building and troubleshooting Microsoft Access databases for over 21 years, working across healthcare, construction, nonprofits, and small-to-mid-size businesses to turn messy spreadsheets and fragile legacy systems into reliable tools people actually trust. Somewhere along the way, Access stopped being just "the database I use for work" and became a genuine specialty — I've spent two decades in the weeds of relational design, VBA, and the countless quirks that come with keeping older systems running smoothly in a modern IT environment.

On the credentials side, I hold Microsoft's PL-900 certification along with a Microsoft Access Expert certification, and I earned my MBA from Eastern New Mexico University — a combination that lets me speak both the technical and business language when a database decision affects budgets, workflows, or leadership buy-in. That mix of formal education and hands-on database work has shaped how I approach every project: not just "does it work," but "does it work for the people who depend on it."

What I love most about Access, though, is what happens at the edges of its lifespan — the migration conversations. Watching a database evolve from a single-user Access file into something built on SharePoint, Dataverse, or Power Apps is one of the most satisfying parts of this work: the bones of a system someone built years ago, carried forward into something that scales. That's the whole reason this blog exists — to share the tips, gotchas, and lessons I've picked up along the way, whether you're maintaining an Access database today or starting to think about what comes next.

Areas of expertise

  • Microsoft Access

    Query design, form/report development, VBA automation, multi-user architecture

  • SQL Server

    Backend upsizing, linked tables, pass-through queries, performance tuning

  • Power Platform

    Access-to-Power Apps migration planning, Dataverse modeling, Power Automate flows

  • Database Design

    Normalization, relationship modeling, indexing strategy, data integrity

Why this blog exists

Microsoft Access has been declared dead roughly every two years since 2003. It's still here — and for good reason. For the right use case, it remains one of the fastest ways to build a functional, maintainable database application without a full development team.

This blog exists to give Access developers the depth they can't find elsewhere: not just "how to do X" but why, what the tradeoffs are, and what to watch out for when your database grows beyond its original scope.

Browse the articles