Just about the biggest player in business automation is the database.  Go get a driver's license?  Ring up food at the grocery store?  Order an umbrella from a business on the internet?  Buried beneath just about every modern transaction is some sort of database application.  In the desktop world, it may be a single platform Access^®/VBA application.  Order on line, and your transaction may be routed through a load balancer to a server farm which is backended by an array of replicated databases. 

A Road Department Work Tracking and Reporting Application

The Franklin County Road department wanted to track their operations better, so Cypress Software worked with them to create "Road Department Tracker".  They input their employee data (hours spent on a particular job or haul, road worked on, district worked in, etc...), equipment data (hours or mileage, rate of fuel consumption, etc...), as well as materials hauled.

After the data input investment, the user can then call up a reports dialog box and print a variety reports which "slice" the data in a variety of ways, generally pulling out information based on a date range.  Since the customer included FEMA payment rates for their equipment use, they were able to get a FEMA cost report as part of this project.

Cypress Software wishes it could take credit for the color palette used for this application, but the user (Virginia Messer of the Franklin County Road Department) gets all of the credit for that.

A Building Permit/Contractor Registration Application

Cypress Software can build it in Microsoft Access^® as the Franklin County Planning & Building Department uses to track building permits and contractor Registration.  The customer requirement was to migrate an existing single-user, flat-file Microsoft Works 97 ^® application to a multi-user, relational database which tracked:

1. building permits
2. inspection schedules and results
3. contractor registration
4. audit-compliant tracking for any departmental transactions

An Occupational License Application

The City of Apalachicola uses a second application for their Occupational Licensing system.  They are able to print invoices and mailing lists with the click of a button (and loading some paper in a printer), print out licenses with another click, and even send out late notices for the tardy.  They run reports on monies taken in over any time span, licensees by occupation type, and even the weather.  I threw that in to see if you were really reading this, the application doesn't report the weather.

A Purchase Order Application

Island Adventures of St. George Island uses a Cypress Software Purchase Order component to their inventory tracking system.  It builds hardcopy purchase order information from their tables of vendors and vendor products, tracks item arrival (through marriage to their receive area scanner) and provides a summary of open and closed purchase orders.