Sample data · this browser only
Inspections
Residential home inspections: a residence, an inspection, and room findings.
Inspectors are employees. Startup is fmnuMain.
| ID | Address | Owner |
|---|
Residence
Open hides Complete, like qselInspectionsOpen.
| ID | Address | Date | Status |
|---|
Inspection
Save or select an inspection first, then add a room finding.
| Room | Condition | Notes |
|---|
| ID | Name | Title |
|---|
Employee
What this demo shows
A Microsoft Access home-inspection book in the browser: a residence, an inspection visit, and room findings.
- Not Calibration — that slug is tools and
tblInspectionLog. This is houses andtblResidenceInspection. - Open filter — hides Complete.
- Rooms child tab — idle until the inspection is saved. Combos store IDs.
- Inspectors are employees —
tblEmployeesmatches Time Card. - Unsaved changes — Yes / No / Cancel before leaving a dirty record.
Will this work when the data is in a database?
Yes. Residence, inspection, and room finding are separate tables with FKs. Kitchen/bathroom appliance detail, photos, and parties from the Access Diva model are omitted this pass.
Sample data only. Source: Inspections on access-diva.com.