Sample data · this browser only
Real estate
Microsoft Access Real Estate: properties, tenants,
leases, and lease payments.
Startup is fmnuMain. Combos store IDs.
| ID | Address | Type | City |
|---|
Property
This PropertyID only.
| Tenant | Start | End | Rent |
|---|
| ID | Name | Company |
|---|
Tenant
This TenantID only.
| Property | Start | End | Rent |
|---|
| ID | Property | Tenant | End |
|---|
Lease
Save or select a lease first.
| Due | Paid | Amount | Type |
|---|
What this demo shows
A Microsoft Access landlord register in the browser: property, tenant, lease, and payments that belong to a lease.
- fmnuMain — Properties, Tenants, Leases. Microsoft hid those in the Navigation Pane; the gold file has a switchboard.
- In-app destinations — a short HTML list of objects in this app, not a clone of the Access left pane (that waits for SvelteKit).
- Combo stores the ID — property type, tenant, payment type and category.
- Open filter — active properties and tenants; open leases have not ended.
- Child payments — idle until the lease is saved; this LeaseID only.
- Unsaved changes — leave a dirty form and you get Yes / No / Cancel.
Will this work when the data is in a database?
Yes. Property and tenant are parents. A lease points at both. Payments hang off the lease. Do not store a running total twice — sum the children when you need it.
Sample data only. Source: Microsoft Access Real Estate template. Service visits are omitted this pass.