NADD 2018 Tom and Daniel

NEDERLANDSE ACCESS DEVELOPER DAG 2018

Presentatie: Interesting components of a medical application

Tom van Stiphout (Kinetik IT) & Daniel Polak (SYS)

DiSy is een grote commerciële Access applicatie voor medische klinieken.

In deze presentatie laten Daniel (in persoon) en Tom van Stiphout (via video link) een aantal interessante functies zien die van pas komen bij een dergelijke applicatie:

- Automatisch databasestructuur wijzigen bij bestaande installaties in het veld. De instructies staan in een tabel en worden één voor één uitgevoerd.

- Invullen van Word templates. De standaard Word mail-merge is leuk maar niet flexibel genoeg en kan geen Word tabellen vullen.

- Ondersteuning van verschillende back-end databases (Access, SQL Server en misschien later MySQL). Gebruik van wrapper functies en pass-through queries.

- Browser synchronisatie met patiënt op scherm. Houd één of meer browser windows in sync met de huidige patiënt. Hergebruik van de Word template code.

Over Tom van Stiphout

Tom is the Software Development Manager of Kinetik IT. Located in Phoenix, Arizona, Kinetik IT is a full service information technology and internet services provider, offering a wide array of technology and internet strategy solutions.

Tom has a degree from Amsterdam University and came to the United States in 1991.

After a few years with C++ and Windows SDK programming, he gradually focused more and more on database programming.
He worked with Microsoft Access from version 1.0, and Microsoft SQL Server from version 4.5, when both were quite immature products. Tom added .NET programming to his repertoire and he is particularly interested in hybrid applications that combine the best of what various platforms have to offer.

Tom has been a frequent contributor to the Access newsgroups and forums for many years, and has been an Access MVP for 10 years. His blogs can be found on accessmvp.com and accesssecurityblog.com.

Over Daniel Polak

Daniel first job was at a computer dealer in 1984 at the dawn of the personal computer era. He provided technical support and was the head of software development .

After that Daniel founded a number of companies, SYS an IT support company, a software distributor for internet and e-mail software and a startup that brought out an iPhone app for local discovery.

The DiSy medical practice management software for clinics that Daniel worked on during the last 15 years was written in Access. It is currently in use at over 70 medical clinics in the Netherlands.
Next to that Daniel also brought out a network security product (SYS Gladiator managed firewall and VPN gateway) that is based on Open Source Software.