02 June 2006

Real World Access (16)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.

John Vinson's animals

I've been working for some years now with the Los Angeles Society for the Prevention of Cruelty to Animals (LA-SPCA). They run a very large operation including field agents who respond to calls (handled by up to four dispatchers) about abused, neglected, or sick animals; they have an animal shelter which takes in some 25,000 animals a year.

They use Access to track all steps: the dispatchers track all phone calls (using conditional formatting to color-highlight high-urgency calls, for instance); the shelter uses the application to keep track of all impounded animals (when they were impounded, from where, what kennel the animal is in, what medical treatment did it get, who is fostering it, who adopted it, etc.). For another agency we've added a module to handle dog licenses in eight cities (with eight different calendars and fee structures), all Access table driven.

Tags:

Powered by Qumana

0 Comments:

Post a Comment

Links to this post:

Create a Link

<< Home