FILEMAKER PRO DATABASE SOLUTIONS

Do you need a database to track something?

Filemaker Pro is an extremely easy, full featured database program that anybody can learn and use.  It is easier to use than Excel, as powerful as SQL, and has the elegance of any Apple product you can think of… Oh ya, maybe that’s because Filemaker is a subsidiary of Apple.

Examples (click the images to enlarge)

Buidling Permit Database
Purpose: To track all data needed for issuing of building permits within a city government.  Including the routing of plans from department to department, all correspondence with the applicant/contractor, as well as the fees that need to be calculated and collected.

Main Menu Screen
rsm_permitdb_mainmenu
Data Entry Screen
rsm_permitdb_permitscreen
Environmental Database
Purpose: To track data needed to comply with a state mandated National Pollutant Discharge Elimination System (NPDES) program.  There are four components to this database that include: 1. Tracking inspections for commercial/industrial sites, 2. Tracking public education opportunities, 3. Tracking staff training, 4.  Tracking Best Management Practices (BMP) for all new and existing construction.
Extra: This database is also available online using Filemaker’s Instant Web Publishing features and a Mac Mini for web hosting.

Data Entry Screen – Filemaker desktop client

cypress_npdes_client

Data Entry Screen – Online Instant Web Publishing

cypress_npdes_iwp
Before and After
The example on the left below shows a permit database that was created years ago without my help.  After I got my hands on it for a couple hours, the database was much easier to use, graphically and programming wise, and the user interface was dramatically improved to make it easy on the eyes.
Before
alisoviejo-permitdb_before
After
alisoviejo_permitdb_after
Follow me