'ZDNET Recommends': What exactly does it mean?
ZDNET's recommendations are based on many hours of testing, research, and comparison shopping. We gather data from the best available sources, including vendor and retailer listings as well as other relevant and independent reviews sites. And we pore over customer reviews to find out what matters to real people who already own and use the products and services we’re assessing.
When you click through from our site to a retailer and buy a product or service, we may earn affiliate commissions. This helps support our work, but does not affect what we cover or how, and it does not affect the price you pay. Neither ZDNET nor the author are compensated for these independent reviews. Indeed, we follow strict guidelines that ensure our editorial content is never influenced by advertisers.
ZDNET's editorial team writes on behalf of you, our reader. Our goal is to deliver the most accurate information and the most knowledgeable advice possible in order to help you make smarter buying decisions on tech gear and a wide array of products and services. Our editors thoroughly review and fact-check every article to ensure that our content meets the highest standards. If we have made an error or published misleading information, we will correct or clarify the article. If you see inaccuracies in our content, please report the mistake via this form.
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.
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.