Caution -
    (a) An activex control named 'Microsoft Date And Time Picker Control' has been used in this database. This control is required to be registered in the access installation on user's computer, before attempting to open & use the sample db
    (b) For registration - file  mscomct2.ocx  should be available in System32 folder of windows operating system. Open any access database other than this db (even a blank one will do), click Tools -> Activex Controls -> Register. Navigate to the location of above .ocx file and click OK.


1 - The Appointment Planner opens with appointment grid for today's date pre-selected and the cursor moves to first available free time slot.
2 - Default display is for chair A. If option button for chair B is clicked, the display adjusts accordingly.
3 - If any other date is seleted in the Date Picker control, fresh appointment grid for that date is presented (if there are no existing entries for that date).
4 - Default values of timeslots can be altered (e.g. longer slots might be needed for some tasks) - provided it does not intrude upon an already booked timeslot. If any unbooked timeslot gets infringed (even partially), it becomes non-available, so as to prevent conflicting bookings.
5 - Data entry for patient particulars can be done in the subform at bottom right. This form normally functions as a linked child subform to the appointments subform (bottom left), but assumes the role of independent data entry subform as soon as it is clicked directly.
6 - Data entry for job particulars can be carried out in the pop up form displayed by clicking the command button at bottom.
7 - Unbooked records older than one week get deleted automatically.
8 - When a patient makes the actual visit, check box titled 'Complied' should be ticked in confirmation.