Sample data · this browser only
Calibration
Tools and equipment that need regular calibration.
Record an inspection log and readings.
Inspectors are employees. Startup is fmnuMain.
Due is NextDueDate on or before today. Open is Active.
| ID | Name | Type | Due |
|---|
Equipment
This EquipmentID only. Save the equipment first.
| Date | Status | Inspector |
|---|
| ID | Equipment | Date | Status |
|---|
Inspection
Save or select an inspection first, then add a reading.
| Measurement | Reading | Result |
|---|
| ID | Name | Title | Phone |
|---|
Employee
What this demo shows
A Microsoft Access calibration register in the browser: equipment, an inspection log, and readings. Combos store IDs.
- Regular frequency —
tblFrequency.IntervalDaysplus storedNextDueDate. Saving an inspection bumps the due date. - Due filter — Active equipment whose NextDueDate is on or before today.
- Inspectors are employees —
tblEmployeesmatches Time Card, so mix-and-match can snap the table together. - Readings — child rows of an inspection, idle until the parent is saved. Measurement combo follows the equipment calibration type.
- Unsaved changes — Yes / No / Cancel before leaving a dirty record.
Will this work when the data is in a database?
Yes. Equipment holds the tool. The inspection log holds each calibration visit. Readings hold the measured values. Certificate file links from the Access Diva model are omitted this pass.
Sample data only. Source: Calibration on access-diva.com.