Sample data only

Components

Clean pieces from Microsoft Access, rebuilt so they can be drawn together. If your database looks roughly like one of these groups, start there. Nothing here is a live production system.

Registers and lists

Daily working lists: a row per issue, student, asset, task, or event, with a filter and a status you can update. If the Access file is mostly one list and a detail form, start here. Sample data only.

Issues

Nifty Access conversion of Microsoft's Issues template (tblIssues plus lookups). Split list and detail. Open filter. Mark Resolved. Data in this browser. Shared D1 sandbox (sample data only). Bring a small sample CSV on Intake. Microsoft's original file is not a download here — how to get Microsoft's templates.

Issues shared sandbox

Same Issues screens, shared on Cloudflare D1. Anyone on the URL sees the same rows. Sample data only. Not a company database.

Students

tblStudents register plus tlkpStudentLevel. Split list and detail. Level combo stores the ID. Mark Inactive. Sample data in this browser.

Assets

tblAssets register plus category and condition lookups. Combos store the IDs. Mark Retired. Sample data in this browser.

Tasks

tblTasks plus optional project, status and priority combos that store IDs. Open filter. Mark Complete. Sample data in this browser.

Work tasks

Work against a client, assigned to an employee. Not the personal Tasks to-do. Sample data in this browser.

Bugs

tblBugs plus a comment thread. Status, category, and priority combos store IDs. Open filter. Mark Resolved. Sample data in this browser.

Events

tblEvents diary: EventName, StartAt, EndAt, Location. Upcoming filter. Mark Done. Sample data in this browser.

Incidents

Workplace incidents with parties, location, and disciplinary actions. Not Issues, Bugs, or Complaints. Sample data in this browser.

Complaints

Members (company or contact in one table) and their complaints, with activities and levies. Not Issues or Bugs. Sample data in this browser.

Calls

tblCalls plus tblCustomers and tblEmployees. Combos store IDs. Open filter. Mark Resolved. Sample data in this browser.

TaskList (lab)

Older SaveAsText lab: frmTasks-style New, Save, Delete, Mark Complete. Not the canonical tblTasks page.

Lab items

Simple inventory list and bound edit form (name, qty, price, active).

Master-detail

A parent record with the rows that belong to it: phones on a contact, expenses on a vehicle, enrolments on a course. This is the Access subform. Membership terms sit with the specialist books below. Sample data only.

Contact book

People and companies, phones, emails, addresses, and named lists. Combos store IDs. Not the parked Contacts slug. Sample data in this browser.

Families

Family Support: one person form in three wrappers (Client, Carer, Sibling). Not Contact book. Sample data in this browser.

Courses

Training with attendance: courses, students, instructors, schedules, and enrolments. Not the Students year-group register. Sample data in this browser.

Clubs

Club groups, dated sessions, members, roster, and roles. Not Complaints members. Sample data in this browser.

Vehicles

tblVehicles and tblExpenses. Expense type combo stores the ID. Select a vehicle to see its expenses (Access subform). Mark Sold. Sample data in this browser.

Real estate

Properties, tenants, leases, and payments. Type combos store IDs. Menu: Properties, Tenants, or Leases. Sample data in this browser.

Listings

Estate-agency listings with brokers, sellers, and interested buyers. Not the landlord Real estate book. Sample data in this browser.

Rentals

Properties, buildings, units, and guest bookings. Not the Real estate landlord book. Sample data in this browser.

Marketing

tblMarketingProject plus deliverables. Budget vs the sum of child cost. Status and priority combos store IDs. Sample data in this browser.

Time card

tblEmployees and tblWorkHours. Work-code combo stores the ID. Select an employee to see their hours (Access subform). Menu: Employees or Hours. Sample data in this browser.

Ledger

tblTransactions plus categories. Kind and category combos store IDs. Menu: Transactions or Categories. Sample data in this browser.

Publications

Publications, articles, and subscribers. Combos store IDs. Sample data in this browser.

Parking

Non-paying lot: associates, visitors, plates, in and out stays. Not fleet Vehicles. Sample data in this browser.

Master-detail

Parent groups and child rows linked by ParentId — the Access subform pattern.

Lookups and combos

Drop-downs that store the ID and show the name, lists that depend on each other, one lookup table for many lists, and a calendar that writes a date back. Sample data only.

Lookup system

One tlkpInfo table holds many drop-down lists. Combos store the ID and show the name. Hide Me, Edit, and parent-pointer groups.

Synchronized combo boxes

Pick a category; the product combo lists only that category. Combos store IDs. Sample data in this browser.

Date picker

Calendar popup writes the date back to the calling box (Access NiftyDatePicker). Go! or double-click. Sample data in this browser.

Workflows and status

Many of the registers above already use an Open filter and Mark Resolved or Mark Done. These two pages are the audit of a change: old value, new value, who, and when. Sample data only.

Audit trail

Web twin of AuditTrailSample.accdb. Notes, field-level log (old/new/who/when), read-only history. Body is logged here; Access data macros skip it. Sample data in this browser.

Audit trail D1

Same audit-trail screens, shared Cloudflare D1 (like Issues D1). Anyone on the URL sees the same notes and log. Sample data only. Compare with the localStorage twin.

Specialist books

A whole activity, not a single list. If the database looks roughly like a charity CRM, a membership book, a salon diary, a stock room, a calibration log, or an inspection round, these are the pieces that often fit together. Sample data only.

CCRM

Charity CRM for keeping in touch: prospects, a call list, events, and Gift Aid. About CCRM. Browser demo only -- the Access file is not a download. Sample data in this browser.

Membership

Organisation members and membership terms (type, date, amount). Not Clubs and not Complaints members. Sample data in this browser.

Appointments

Salon book: clients, appointments, and services. Open filter. Combos store IDs. Sample data in this browser.

Inventory

Stock is not a field. In Stock is the signed sum of additions and removals (Access DSum). Sample data in this browser.

Shop stock

Products, customers, and orders. Available is acquisitions minus disposals minus quantities sold. Not the Microsoft cupboard Inventory demo. Sample data in this browser.

Calibration

Equipment due dates, inspection log, and readings. Inspector combo stores the employee ID. Sample data in this browser.

Inspections

Residential inspections: residences, room findings, inspectors. Not Calibration. Sample data in this browser.

Utilities

Menus, a find popup, speech to text, a numeric keypad, and small Access routines that sit beside the data. Sample data only, except where a page is a written note rather than a live list.

Switchboard Builder

Edit the table-driven menu the way Nifty Switchboard Builder does in Access: pages, rank up/down, add page, delete leaves a gap, close gap. Live preview from the same rows. Sample data in this browser. Not the heritage product page.

Switchboard

Table-driven menu. Items are rows, not hardwired buttons. Sample data in this browser.

Switchboard Builder notes

The written page for the Access tool: a form over the table-driven Switchboard. Not the live browser demo.

Search form

Popup find form (Access frmSearch). Find opens it; Show Selected Record writes the contact back. Boxes declare the field, abc* / *abc* / *abc. Sample data in this browser.

STT-1

Speech to text. Two boxes, one popup, microphone transcribes, Use this writes back (like the date picker). Browser demo, no database. Chrome or Edge.

Keypad

Numeric keypad popup. It writes an amount back to the box that opened it. Sample data in this browser.

CallCalled

Class module note: a popup takes its caption from the calling control and can pass a value back. The VBA is on the page.

Advanced message box

Yes, No, and Cancel with plain-English labels, and the VBA that takes the next step. Written up from the older Nifty Access page.