FileMaker Pro Advanced

FileMaker Pro Advanced 18.0

Generates databases and manages their content.
4.1  (46 votes)
18.0.3 (See all)
Create databases and manage files and operations in the suite with several additional features. The program includes contact lists maintenance, inventory, and invoicing organization, runs estimates and generates expense reports, etc. CSV, Tab, XML, ODBC, and XLS file formats are supported.

FileMaker Pro Advanced is intended to design database applications. In this regard, the tool lets you develop custom apps that address your specific needs, both at home and for business. The tool may require some practice and study before you feel absolutely comfortable and use all the available features. Fortunately, there is a myriad of online learning resources, such as guides and tutorials.

You can start a new app from scratch, but, before you do that, it is a good idea to see if any of the available templates suits your needs. In this respect, there are built-in database templates for managing data related to assets, contacts, content management, inventory, meeting and tasks, and luckily you can find more on the developer’s site. Another possibility is to import data from external files in such formats as CSV, TAB, XMLS, ODBC, XLS and XLSX.

Once you have finished the initial app setup part, you can start customizing its interface. Luckily, this is done in a WYSIWYG style, with the possibility of resizing and moving objects or adding new ones.

An important part of using a database is generating reports. Luckily, FileMaker Pro Advanced comes with various reporting and charting tools that provide access to organized and condensed data in convenient layouts. It is also good that the reports can be saved in such widely used formats as Excel and PDF.

There is a hidden power in the tool, which comes from creating your own code. You can write your own functions to personalize your apps a little further. Luckily, there is a script debugger to find problems and clean your code. Regretfully, it does not support code refactoring and source control.

One of the best features of FileMaker Pro Advanced is that it lets you share databases on the Internet. In this respect, you can protect your data by assigning different access levels to the users. Since sharing also implies transferring data over the network, it is good news that the tool uses a strong encryption algorithm, like AES 256-bit.

In general, FileMaker Pro Advanced comes in handy for a wide array of uses. For instance, you can keep a record of your expenses as well as create a media catalog at home. In a professional context, it can satisfy diverse necessities ranging from bookkeeping to personnel management. The product is shareware and can be tried at no cost: an opportunity you should not miss. However, I should alert you that the price is possibly too high if you intend to use it for common tasks.

Pedro Castro
Editor rating:

Review summary

Pros

  • Suitable for different contexts
  • Built-in debugger
  • Multiple templates
  • Supports importing data from external files
  • Can link to SQL databases
  • Shares data and assigns user privileges
  • Strong encryption algorithms
  • Personalized reports
  • WYSIWYG design

Cons

  • No support of code refactoring and source control
Info updated on: