// blog

Microsoft's Northwind Database, Out of Access and Into a Browser

We took Microsoft’s Northwind sample database, the one every Access user has seen, and made it a web app: 830 orders that go from New to Invoiced, Shipped and Closed, stock that’s held when an order is invoiced, purchase orders a manager approves, payments, eight reports and invoices that print or save as PDF. It runs in any browser, and every rule is checked on the server.

Last updated 1 min read

A Northwind order in the web app: a stock warning, the products and the total

If you’ve used Microsoft Access, you’ve seen Northwind: the sample database of a small food importer, with its customers, orders and products. We made it a web app you can use right now.

Open Northwind in your browser

What it does

  • Orders go New, Invoiced, Shipped, Closed, in that order.
  • Stock is held when an order is invoiced and leaves when it ships. An order that’s short can’t be invoiced.
  • Purchase orders fill the gap: written by anyone, approved by a manager who didn’t write them, then received into stock.
  • Payments: an order closes only once it’s paid.
  • Reports: sales by employee, product and customer, money owed by age, a reorder list. Print them or save them as PDF.

Sign in as Nancy, a sales rep, then as Andrew Fuller, the vice president, and see what each may do.

Try this

Open order 11045. It’s short of dried apples. Order more from the supplier, approve it as Andrew, receive it, and invoice the order. That’s the whole loop an Access form used to run, in a browser tab.

Why it matters for your database

Northwind has the same parts as most Access databases a business runs on: forms and subforms, rules in VBA, queries, reports. Here each one has a web version:

In Access On the web
One file on a shared drive One database on a server
Windows PCs in the office Any browser, at home too
Rules in form code Rules on the server, with tests
Reports printed from Access Print pages and PDFs

How we built it · Move your own Access database