Sample data · this browser only
Ledger
Canonical tblTransactions / tblTxnCategory. Startup fmnuMain. Category combo stores CategoryID.
Active transactions
| ID | Title | Kind | Amount |
|---|
Transaction
Active categories
| ID | Name | Kind |
|---|
Category
What this demo shows
A Microsoft Access cash book in the browser. Income and expense share one transaction table; the category combo stores the ID.
- Switchboard —
fmnuMain: Transactions or Categories. - Combo stores the ID —
CategoryIDon the row, name in the control. - Kind — Income / Expense via
tlkpTxnKind, not two different amount columns. - Unsaved changes — leave a dirty record and you get Yes / No / Cancel (Access
Me.Dirty).
Will this work when the data is in a database?
Yes. This page keeps sample rows in this browser. A named “workshop cash book” would use the same fields and captions — not a second set of column names.
Sample data only. Source: Microsoft Access Personal Account Ledger template.