FileMaker Pro 10 Advanced review

We review the next generation of the popular database management software.

Price
£392

FileMaker is a tool that lets you build databases: it's been around for a long time and the latest version (10) is now available. One of FileMaker's great strengths is that it is available for both the PC and the Mac. That's great news for Mac users because they have, historically at least, been well served when it comes to a choice of database management systems (DBMS). It is even better news for companies that use both because FileMaker databases will run on both.

FileMaker has always had great facilities for the design of reports and forms. Pleasingly, this strength continues and is enhanced in version 10. The most obvious change is the movement of the Status toolbar to the top of the screen it's been clinging to its traditional position at the side of the screen for far too long. And to help you get started designing databases, there are 10 new templates to give your database a slick professional look.

The program also supports a good selection of file types for data import including Excel, tab- and comma-separated text, ODBC, DBF (dBASE) amongst others. However, that of FileMaker's main competitor, Access, is conspicuous by its absence.

These imports let you pull data into a FileMaker database where it is managed by the product's data-handling engine and can be displayed and manipulated. Reasonably large data sets for small- to medium-sized enterprises (SMEs) are well within FileMaker's comfort zone but its data-handling engine is simply not in the same class as those of SQL Server or Oracle which are used for massive data sets in multi-national enterprises.

Advertisement
Advertisement - Article continues below

That said, you now have the option of storing your data in these scalable and robust engines whilst retaining the advantages of FileMaker's friendly user interface. The newly-updated ESS (External SQL Data Sources the D is obviously silent) feature provides live two-way connections to other DBMS including Microsoft SQL Server 2008, Oracle 11g and MySQL 5.1 Community Edition. The data to which you connect can be treated in exactly the same way as data stored within FileMaker: you can build reports, add calculations and so on, just like you would FileMaker data, without the need to know the SQL querying or data manipulation languages.

Another noteworthy new feature is the Script Trigger. This provides the ability (as the name suggests) to trigger scripts from user actions. So, for example, you could ensure that the database only displays fields to collect the card number and expiry date if the user elects to pay by credit card. Also new is the ability to save a set of find' requests and then to carry them out with a single click. And, by using Dynamic Reports, you can make changes on the fly' and it's easier to create customised reports.

Featured Resources

The IT Pro guide to Windows 10 migration

Everything you need to know for a successful transition

Download now

Managing security risk and compliance in a challenging landscape

How key technology partners grow with your organisation

Download now

Software-defined storage for dummies

Control storage costs, eliminate storage bottlenecks and solve storage management challenges

Download now

6 best practices for escaping ransomware

A complete guide to tackling ransomware attacks

Download now
Advertisement

Most Popular

Visit/security/identity-and-access-management-iam/354289/44-million-microsoft-customers-found-using
identity and access management (IAM)

44 million Microsoft customers found using compromised passwords

6 Dec 2019
Visit/cloud/microsoft-azure/354230/microsoft-not-amazon-is-going-to-win-the-cloud-wars
Microsoft Azure

Microsoft, not Amazon, is going to win the cloud wars

30 Nov 2019
Visit/network-internet/wifi-hotspots/354283/industrial-wi-fi-6-trial-reveals-blistering-speeds
wifi & hotspots

Industrial Wi-Fi 6 trial reveals blistering speeds

5 Dec 2019
Visit/hardware/354237/five-signs-that-its-time-to-retire-it-kit
Sponsored

Five signs that it’s time to retire IT kit

29 Nov 2019