Sample data · this browser only

Inventory

Microsoft Access Inventory Management: there is no quantity column on the item. In Stock is the signed sum of additions and removals (Access DSum).

What this demo shows · Assets is a register of owned things — this is stock movements · Demos

Demo chrome — same data, three UIs. A company app would ship one of these, not the combo.

Items (Split · datasheet)

In Stock is computed. A row at or below ReorderLevel is marked.

ID ItemName In Stock Reorder Location

Item

Edit the selected item. Post movements in the Transactions pair.

What this demo shows

Microsoft Access Inventory Management: stock is a calculation, not a field you type.

  • No QtyOnHand column — In Stock is DSum of signed movements (Addition plus, Removal/Shrinkage minus).
  • Quantity is always positive — the type carries the sign, like Microsoft IIf(Add/Remove="Addition", Quantity, -Quantity).
  • Reorder — the list flags items where computed stock is at or below ReorderLevel.
  • Demo layouts — Tab view (Access default), One page, or Switchboard. Same data; a company app would ship one layout, not the combo.
  • Item Information | Transactions — each pair is a datasheet + form, like the Access tab control on frmInventory.
  • tblSuppliers is core — the same supplier table we will reuse on other templates.
  • Unsaved changes — leave a dirty item and you get Yes / No / Cancel (Access Me.Dirty).

Will this work when the data is in a database?

Yes. A company database would still not store on-hand twice. The item table holds the item; the transaction table holds the movements; on-hand is the sum.

Sample data only. Source: Microsoft Access Inventory Management template. Assets on this site is a register of owned things, not this stock ledger.