Sample data · this browser only

Appointments

A salon book: clients, appointments, and services. Combos store IDs. Startup is fmnuMain.

What this demo shows · Events is a diary — this is a booking with a client and a service list · Demos

Appointments (fmnuMain)

Open a list. This is the Access switchboard, not the Access Navigation Pane.

What this demo shows

A Microsoft Access appointment book in the browser: a client, a booking, and the services on that visit. Combos store IDs.

  • tblClient is not tblCustomers — salon clients are people (FirstName / LastName), not companies.
  • Stylists are employees — tblEmployees matches Time Card.
  • Open filter — hides Cancelled, like qselAppointmentsOpen.
  • Services child tab — idle until the appointment is saved. An appointment can have more than one service.
  • Unsaved changes — Yes / No / Cancel before leaving a dirty record.

Will this work when the data is in a database?

Yes. The appointment holds FKs to client, stylist, and status. Child rows hold the services. Associate working hours and payment terms from the Access Diva model are omitted this pass.

Sample data only. Source: Appointments on access-diva.com.