Free inventory software in MS Access

The key facts

• Access is genuinely capable: tables, forms, queries and reports — a real relational database, included in Microsoft 365 business plans you may already pay for.
• What you build: products, movements, locations, counts — honest single-team inventory for a fraction of SaaS cost.
• The wall: sharing and concurrency (Access is fragile beyond a couple of simultaneous users), no audit trail worth the name, and every integration — scanning, accounting, portals — is yours to build.
• BSimple is the wall's other side: a shared browser record from $180/month (AUD), free to trial.

What an Access inventory database covers

Access is the serious version of the spreadsheet: products table, movements table, locations table, linked and validated — with forms for entry, queries for reorder lists, and reports for stock value. Built carefully, it is honest for a small team: better than Excel at structure, forced relationships, and one definition of each quantity. The free templates Microsoft ships get you a skeleton; your data model does the rest.

What it costs is not licence fees — it is you. The database schema is your design; the reorder logic is your query; the backup is your scheduled task; and every integration, from barcode scanning to the accounting handoff, is a project. The free desktop downloads sit in the same trade-off family: local, capable, alone.

The wall every Access inventory hits

Concurrency. Access degrades quickly with simultaneous users over a network — the second person editing is exactly the trigger. The audit trail. You can log changes with enough VBA, but almost nobody does it thoroughly, so "who changed this" stays an opinion. The integrations. Scanning posts to a form if you build it; invoices push to Xero or MYOB if you build that too — and building the accounting handoff well is a genuine engineering effort, not a template.

These are not criticisms of Access; it is a database, not a business system. The wall arrives when the inventory stops being one person's list and becomes the business's record — which is the moment the built version and the bought version converge. The free-for-PC ladder and the self-hosted comparison place Access among its alternatives.

The honest verdict

We build BSimple, so weigh that. If you own Office already, enjoy the data modelling, and the record serves a small team — build the Access version; it will teach you your own data model better than any product tour. The moment you need concurrent users, a real audit trail, phone-based counts, or invoices that reach Xero or MYOB without re-keying, that is the product territory: BSimple runs those on one browser record from $180/month (AUD), and the trial can import the same data your Access database holds — the migration path is a query away, not a rebuild.

The PC-side free ladder covers the other free shapes, and the inventory management guide shows what the record looks like once sharing is the requirement.