// 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.

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 |
































































































































