Sample data · this browser only
Shop stock
Products, customers, and sales orders. Available is acquisitions minus disposals minus quantities sold -- not a stored stock field.
| ID | Product |
|---|
Product
Save this product first. The Movements tab stays grey until then -- waiting, not broken.
| Kind | Date | Qty |
|---|
| ID | Customer |
|---|
Customer
| ID | Number |
|---|
Order
Save this order first. The Lines tab stays grey until then -- waiting, not broken.
| Product | Qty | Price |
|---|
Available stock
Acquisitions minus disposals minus quantities on order lines. Widget A seed is 20 - 1 - 2 = 17.
| Product | Available |
|---|
What this demo shows
A Microsoft Access shop book: products, customers, orders, and computed available stock.
- Not the Inventory demo -- that Microsoft cupboard has no customers or sales orders. Available here also subtracts quantities sold.
- Order lines -- an order has many products (Ken's OrderDetails pattern).
- Open filter -- hides inactive rows.
- Child tabs idle until save -- Movements and Lines stay grey on a new parent.
- Unsaved changes -- Yes / No / Cancel before leaving a dirty record.
- Source -- Ken Sheridan. The original sample page has been discontinued. This Microsoft Learn Q&A thread on inventory, orders and customers may be of interest: Access database for inventory, orders and customers.
Will this work when the data is in a database?
Yes. Products, customers, orders, lines, and stock moves are separate tables with FKs. Available is not stored. Source Calendar, city cascade, and stock takes are omitted this pass.
Sample data only. Source: Ken Sheridan (sample page discontinued). Related: Microsoft Learn Q&A.