FileMaker Pro 6.0

  • Editors' rating
    8.3 Excellent
  • $299.00

Pros

  • XML support
  • easy to learn
  • high-end functionality
  • usable interface
  • informative manual.

Cons

  • Toolbars can’t be customised.

Database programs let you store, retrieve, organise and analyse all sorts of data -- from complex billing records to home-video collections. FileMaker Pro 6.0 lets you manage vast quantities of such information and also allows you to share this information quickly with other applications. FileMaker's attractive, straightforward interface and relatively low £219 (ex. VAT) price make it easier and more economical than Microsoft’s Access. We heartily recommend this database program for everyone: although it's simple enough for novices, it also supplies sophisticated, higher-end features that will suit database veterans.

FileMaker Pro 6.0's installation process is relatively simple. It follows all of the familiar software setup steps, with one exception: you don't use the code on the CD-ROM sleeve to activate the product -- that code merely identifies the CD-ROM. The activation information comes in an easily overlooked, two-page booklet entitled ‘Service Directory and Installation Codes’.

Even database novices will be able to understand FileMaker's intuitive layout. The program's menus resemble the Windows-standard interface (File, Edit, View, Insert, and so forth), except that FileMaker has replaced the Tools category with one called Scripts, where you'll access FileMaker's scripting tools (more on that later) and dispersed its Tool commands into other categories. For example, you'll find the Security menu under File > Access Privileges. The new arrangement will take some getting used to for Microsoft Word users. Unfortunately, you can't customise FileMaker's individual toolbar buttons either, as you can in Microsoft Access, but the toolbar selections provide most of what you need.

To create a database from scratch, you can either walk through a simple design process, which involves naming and defining fields in a dialogue box, or enter data into an uncomplicated database template. FileMaker supplies roughly two dozen of these prefabricated templates, tailored to a variety of uses, including family medical records, time billing and contact management (Access also has such templates). If you've created databases in other programs, no problem: FileMaker easily imports files in a host of formats, including comma- and tab-separated values, Excel, Lotus 1-2-3 and HTML.

You'll have no trouble performing all of the typical tasks, such as sorting records and importing files. The Records/Sort submenu lets you right-click to arrange your records either alphabetically or by any field.

If you want to perform complex automated database operations, such as emailing a data file or launching your Web browser from the database, FileMaker does it the easy way. Microsoft Access, for example, lets you build database scripts if you're fluent in Microsoft Access Visual Basic. But FileMaker's wizard-like ScriptMaker lets you build scripts using natural English commands, such as ‘Go to next field’, Show All Records, and Send Mail. You can achieve some truly sophisticated results using ScriptMaker in a fraction of the time required to learn Access's Visual Basic. When it comes to ease of use, FileMaker Pro 6.0 beats Access hands down.

Top ZDNET Reviews

Of all the new features added to FileMaker Pro 6.0, support for XML is the most significant. FileMaker 6.0's XML templates allow the program to import and export a much broader range of document formats, including Excel 2002 spreadsheets, and it does it much faster than previous versions.

Even in FileMaker, you may encounter a problem that you can't solve -- it happens to the best of applications. Luckily, you can turn to FileMaker's thoroughly annotated help files and lengthy but well-written manual. What's more, FileMaker's first-rate technical support offers a large, online reference database of articles, as well as a newsletter, FAQs and knowledgeable phone support.

Overall, FileMaker Pro 6.0 combines the complexity that you and your business need with tools that bypass the difficult programming that Microsoft Access requires. FileMaker is straightforward and power-packed enough to appeal to both newcomers and veterans. Add in its new XML support and slightly lower price tag than Access, and you have a sure winner. Give the 30-day free trial a go if you don't believe us.

Specifications

General
Packaged Quantity 1
Localization English
Category business applications
Subcategory business - databases / database tools
Package Type retail
Distribution Media CD-ROM
Version 6
Software
Subcategory business - databases / database tools
Category business applications
License Type box pack
Version 6
License Category shrinkwrap
System Requirements
Min RAM Size 32 MB
OS Required Microsoft Windows 2000, Microsoft Windows 98, Microsoft Windows Millennium Edition, Microsoft Windows NT 4.0 SP6, Microsoft Windows XP
OS Family Windows
Additional Requirements CD-ROM
Min Processor Speed 90 MHz
Min Processor Type Intel Pentium
Header
Brand FileMaker
Product Line FileMaker
Model Pro
Localization English
Packaged Quantity 1
Compatibility PC

Top ZDNET Reviews

Kick off your day with ZDNet's daily email newsletter. It's the freshest tech news and opinion, served hot. Get it.

Newsletters

You have been successfully signed up. To sign up for more newsletters or to manage your account, visit the Newsletter Subscription Center.
See All
See All