FileMaker Pro (FMP) is powerful software used to create custom apps and databases that work seamlessly across iPad, iPhone, Windows, Mac, and the web.
Build your own custom app to meet the unique – and changing – needs of your business processes. Or, for inspiration, explore the built-in Starter Solutions for managing contacts, inventory, content, and more.
Our Security and Compliance policy requires all FileMaker Pro databases be:
- upgraded to the current version of the software to have access to the latest FMP features and maintain a high level of security.
- kept on the server in the UTHSC Data Center.
Advantages of having the FMP database on the server include nightly backups by ITS, central location, and better data security.
Determining Your Need
While both spreadsheets and databases handle and manipulate data, there are times when one works better than the other. Below are guidelines for determining which best meets your need:
While both spreadsheets and databases handle and manipulate data, there are times when one works better than the other. Below are guidelines for determining which best meets your need:
Excel vs. FileMaker Pro
| Need Excel Spreadsheet |
Need FileMaker Pro |
|
You want to track and/or review data.
|
You want to analyze and/or manage data. |
| You have a relatively small number of data fields that are easy to browse, edit, and sort. |
You have numerous or large data fields which could continue to grow. |
| The data is used mainly by one person at a time. |
The data is used by one or more people who need to access, edit, or use the data at the same time. |
| Excel's data auto-formatting feature is helpful. |
Excel's data auto-formatting feature could potentially compromise the data. |
| You need to easily integrate the data or document with other Microsoft Office software (e.g. inserting tables into Word or email). |
|
| You need to be able to email copies of the document to others. |
You need to be able to email reports to others. |
| You are okay with doing your own backups. |
You want ITS to do your backups (NOTE: This requires that the database be stored on the FileMaker server maintained by ITS). |
Sometimes you need an expert ...
If your data management needs are more complicated than what you are able to develop OR maintain on your own (i.e. lots of data, need for a web interface, lack of expertise, etc.), then please submit an ITS Project Request and let our IT Analysts develop and build a custom database application for you. This solution will take more time than going the DIY route, but you will be guaranteed a solution that is tailored to your needs, as well as expertly maintained and supported throughout its lifecycle.
- The data is sensitive or contains HIPAA, FERPA, PHI, or PII
- You require data from another application, such as Banner or IRIS
- You would like to send data to another application, such as Banner or IRIS
- The database is complex or requires extensive reporting
- The data needs to be viewed or shared by someone outside your department or by more than 15 individuals
- You want a web front-end for data entry or reporting
You are looking for a long-term, supported solution