Microsoft Access to web app
Northwind's orders, stock and invoices: out of one file on one PC, into any browser. Same records, same rules.
Before: Access


After: web app

Invoice an order. Order 11071 has its stock. Invoice it
Fix a stock problem. Order 11045 is short of dried apples. Order more, approve as Andrew Fuller, receive, invoice. Open order 11045
Ship, get paid, close. A shipped order can't close until its payment is in. Shipped orders
Print. Sales by employee, by product, money owed, and any invoice as a PDF. Reports
| In Access | On the web |
|---|---|
| Tables in the .accdb file | PostgreSQL tables on the server |
| Forms and subforms | React screens that work on a phone |
| VBA behind the buttons | C# rules every change goes through |
| Queries | Lists, filters and search |
| Reports | Print pages and PDFs |
| Login form | Sign-in, with what each person may do |
The data is Microsoft's Northwind sample database, under the MIT License (source), with the dates moved to today. The order steps follow Microsoft's Northwind 2.0 Access template, as its help pages describe them. The screens and code are AI Web Center's. Northwind Traders is fictional.
Open the app How we built it Have your Access database moved