My workshops

In response to the many requests I received following my participation to the Access DevCon 2021, I am hosting a series of online workshops to explain in detail the techniques and the code for building some of the interfaces I have shown.

If you are interested in any of these workshops, please send me an email.

Happy Berthday!
Scrollable timeline

In this 6 hour workshop we are going to learn how to create a scrollable timeline, and how to put objects on it. This kind of interface can be used whenever there is a need to show a temporal sequence of events: think for example of incoming and outgoing emails, or a set of meetings, or expeditions of goods of any sort, or even incoming and outgoing hotel guests. In this demo clip, this technique is applied to management of ships and ports (UN - WFP Ethiopia, 2010-2011).

During the workshop, the so called bit field technique is going to be explained. Also known as "presence vector", this is an extremely useful technique (one of my favorites, I have to say), which happens to be very useful in many situations.

The workshop is planned for September 2021. Given its length and its difficulty, it will probably be split in four sessions.

VeLo (Vessel Loader)
Drag and Drop with MS Access

Held on 7th July 2021, we learnt how to apply a "drag and drop" effect to images and labels. Lines can also be used to link the draggable objects. This technique and its variations (some of which were explained in these 3 hour workshop) is gret to visually show relations among entities, and can be applied to a huge number of situations.

The video shows an example: a prototype I created when I was consulting for the UN - WFP Ethiopia (2010-2011), to plan the delivery of food using a number of vessels. This application was meant to replace the gigantic Excel sheets which were used at that time for the same purpose, painful sources of errors and wrong data.

FMIP Geo Module
Approximate String Matching

In this workshop (held on 10th June 2021) we learnt how to implement the so called "Levenshtein Distance" to perform an approximate string search. This technique is particularly useful when you want to perform a search on a set of values using "approximate" search values. This clip shows a possible application (UN - WFP Ethiopia, 2010-2011): searching an Ethiopian location was not easy at all, because of the different transliterations from Amharic. An approximate string search solved the problem, so the users were able to find what they were looking for, without being forced to remember the exact spelling of each location. Note that this is something completely different from the use of jolly characters such as '?' and '*'.

Here's an article about the workshop.