Example Apps for Businesses, Schools & Developers

Screenshots

Click any image to view a larger version

Patient Login - Start

PatientLogin2-KioskStart
Patient Login - Gender

PatientLogin3-Gender
Patient Login - Month

PatientLogin4-Month
Patient Login - Day

PatientLogin5-Day
Patient Login - Check

PatientLogin6-Check
Patient Login - Appointment

PatientLogin7-ApptInfo
Patient Login - Decade

PatientLogin8-Decade
Patient Login - Year

PatientLogin9-Year
Patient Login - Time Check

PatientLogin10-TimeCheck
Patient Login - Check Failed

PatientLogin11-CheckFailed
Patient Login - Later Appt

PatientLogin12-LaterAppt
Patient Login - Missed Appt

PatientLogin13-MissedAppt

Version 3.0      Updated 29 Oct 2018               Approx 1.5 MB   (zipped)

This is the second in a series of examples showing different ways of filtering and grouping data in Access

This example demonstrates a typical patient login system similar to that used in my local medical practice. It is used on a touch screen with no keyboard and is designed to occupy the entire screen (kiosk mode).

The startup form provides various options for testing/using this application.

PatientLogin1-StartForm


The challenge when creating kiosk mode applications is to design forms that guide the user through all possible scenarios in as few screens as possible in order to filter the data down to a single unique record.

Large font sizes and large buttons are always used in kiosk mode apps for ease of use on touch screens.

In this example, users first select their gender then their birth month & birth date.

The application then checks the list of appointments for the current date
If there is only one record matching those details, a confirmation screen appears.
Click Yes if the details are correct and the appointment details are displayed
If the details are incorrect, click No to return to the Login screen

When the Done button is clicked, the app returns to the login screen ready for the next user.

The login time is saved in the appointments table. This provides an easy method of checking for non-attenders as their login time will be blank

There are several variations in the process depending on the outcomes.

For example, two or more patients with the same gender and birth month/date may have an appointment that day. If so, two additional screens appear so that the year of birth can be selected.

On the very rare occasions that two or more patients with the same gender and date of birth have an appointment that day, the application selects all the related appointment times for that day and displays these for the user to make a final selection.

If no matching details are found, the app will state this & then return to the login screen ready for the next user.

If the time was earlier in the day, a missed appointment message appears.

The PDF file supplied with the app gives full details of all the different routes possible using the app. The PDF file should be saved in the same folder as the application.



Further info:

The DEMO application contains over 3300 patients and over 530 appointments for the same date.

To make this as realistic as possible for testing purposes, the following changes are made to the records in the appointments table when the application is started:
a)   All appointments are changed to the current date
b)   All login times for dates other than today are cleared



Keyboard Shortcuts: (for the purpose of this DEMO only)

a)   Open the application with the SHIFT key held down to view the navigation pane,
      ribbon & code
      OR click Ctrl+H to view the navigation pane and ribbon at any time.
b)   To hide the navigation pane & ribbon again, click Ctrl+Shift+H
c)   To return to the startup form, click Ctrl+S
d)   To close the application, click Ctrl+Q



Click to download:
       Patient Login v3    Includes both ACCDB & PDF files (zipped)



Colin Riddington           Mendip Data Systems           Last Updated 29 Oct 2018

Return to Example Databases Page Return to Top