"When I became director, we needed a flexible solution, I was very familiar with FileMaker Pro and knew it had the multi–user capabilities [we needed]," he said. "Just about everything we do revolves around FileMaker Pro. It's become the core of our operation."
Today, more than 500 users can access the network databases stored on each of four servers; additional servers in each school provide hundreds more databases specific to a given campus.
The databases contain, Canterbury said, "all [our] student data and demographic management. All of the typical stuff, where they live, what they do, and what grade they're in."
Building on those basics, the Lakota district can also track student's use of in–school medical clinics that are staffed by skilled nursing personnel. The usage data — numbering 125,000 records per year — must also be reported to state officials in Ohio.
"In the [school] clinic database, all the compilation used to be done by hand," Canterbury recalled. "It would take days to tabulate the number of clinic calls for the state. It would take days for the data to be collected by one nurse, who would have to tabulate all that. What used to take a week to do now is done in a matter of seconds."