Sample data · this browser only

Call tracker

Microsoft Access Call Tracker: calls against a customer, assigned to an employee. Combos store IDs. Startup is fmnuMain.

What this demo shows · Bugs has no customer table · Demos

Call tracker (fmnuMain)

Open a list. First freeze of tblCustomers. Employees match Time Card.

What this demo shows

A Microsoft Access call register in the browser: a call, a customer, and an employee. Combos store IDs.

  • tblCustomers is core — the same customer table we will reuse on other templates.
  • tblEmployees matches Time Card — same fields, so mix-and-match can snap the tables together.
  • Open filter — hides Resolved and Closed, like qselCallsOpen.
  • Mark Resolved — sets status without deleting the row.
  • Unsaved changes — Yes / No / Cancel before leaving a dirty record.

Will this work when the data is in a database?

Yes. The call holds FKs to customer and employee. Related Calls (Access multi-value) are omitted this pass.

Sample data only. Source: Microsoft Access Call Tracker template. Charts and Filter Details are omitted.