Filemaker Pro 9.0
Alpha Five offers more choices for extending functions with scripts and Web software, but most users will likely want to spend the extra money for the more-intuitive FileMaker.
- Browse and edit live SQL data, Send Link, conditional formatting
- More expensive than Alpha Five
FileMaker's ease of use, rich template library, instant Web publishing, and designer-quality layout tools make it our choice for typical home and small-business users.
Price$ 299.00 (AUD)
FileMaker Pro 9 does a good job of helping ordinary people create useful and good-looking database applications. Both FileMaker and Alpha Five Version 8 Professional let you create desktop and Web databases for everything from e-mail marketing campaigns and online storefronts to media libraries and Christmas card lists. But the programs have different strengths: FileMaker is more intuitive, while Alpha Five offers more extensibility via scripts and Web apps.
FileMaker Pro 9's biggest addition is direct integration of SQL data sources within forms and reports. You can now browse and edit live SQL data just as easily as you can native FileMaker data, after creating a one-time link to the SQL data source. Workgroups can then easily access and update central SQL databases, such as for inventory or personnel data. The new version also offers a friendly splash screen that links to excellent tutorials and help files, as well as to templates and recently used databases.
I particularly liked the new Send Link feature, which adds a link to your database within an e-mail message whose body text instructs the recipient how to access the database over a local network. No more futzing around figuring out IP numbers — just click.
The new conditional-formatting feature makes it a snap to call attention to significant data points or trends. You can use it to define different fonts, sizes, styles, or colours that will be used based on certain conditions. For example, an inventory field could display in large red type when the number drops below a specified level, alerting you to order more of that item. Other useful goodies are the autoresize tool, which lets you create layout objects that resize automatically to fit different screen resolutions or paper sizes; multiple undos and redos when editing field text; and field-level spelling checking, so you can turn checking off for fields containing proper names, for instance.
Additionally, you can publish forms to the Web with one click, so others could use a browser to view, for example, updates to an ongoing project or a customer feedback form.
The dozens of included templates should cover most common database needs, such as expense reports, personnel records, and inventories. Several add-on template packs are also available. Everything is compatible across the Windows and Mac platforms, too. Plus, you can benefit from the third-party ecosystem that has built up around FileMaker. Turn-key solutions for vertical markets such as real estate offices, nonprofit organisations, and healthcare management are readily available, and developers are available to build custom projects that you can then tweak and manage yourself.
Overall, Alpha Five is less expensive than FileMaker, but its high-end versions are especially so. Comparing list prices, Alpha Five Enterprise version with SQL support costs only $US349, compared with $499 for FileMaker Pro Advanced (however, even the $299 FileMaker Pro 9 offers SQL support). If you require many people to pitch in on the design of your database, you'll need FileMaker Server to get more than nine simultaneous client connections. Alpha Five's Application Server is more of a bargain at $399 for the basic version, compared with FileMaker Server's much heftier price tag.
FileMaker's somewhat easier learning curve, rich template library, SQL capabilities, and instant Web publishing make it the better choice for typical home and small-business users. Also, businesses in need of SQL support could benefit from that feature's presence in the Pro version. But Alpha Five has the clear edge in extending basic functions via script building and Web application development tools, and its lower cost of ownership makes it an attractive alternative.
Join the PC World newsletter!
Most Popular Reviews
- 1 Google Pixel XL full, in-depth smartphone review: Phones just got smarter
- 2 Sony Xperia XZ review: turbo-charged last-gen phone
- 3 Hisense Series 7 ULED 4K UHD TV review
- 4 Sony X9300D and X8500D UHD 4K TV review
- 5 Moto X Force review: Leading features from a mid-range phone
Latest News Articles
- Buggy Windows 7 cumulative update? Just tell us, says Microsoft
- Microsoft fleshes out seismic change to Windows patching
- Successful launch for second NBN satellite
- Where's the bottom for Microsoft's Internet Explorer?
- ICANN transition moves forward, despite last-minute attempt to block it
GGG Evaluation Team
First impression on unpacking the Q702 test unit was the solid feel and clean, minimalist styling.
For work use, Microsoft Word and Excel programs pre-installed on the device are adequate for preparing short documents.
The Fujitsu LifeBook UH574 allowed for great mobility without being obnoxiously heavy or clunky. Its twelve hours of battery life did not disappoint.
The screen was particularly good. It is bright and visible from most angles, however heat is an issue, particularly around the Windows button on the front, and on the back where the battery housing is located.
My first impression after unboxing the Q702 is that it is a nice looking unit. Styling is somewhat minimalist but very effective. The tablet part, once detached, has a nice weight, and no buttons or switches are located in awkward or intrusive positions.
- Google Pixel XL full, in-depth smartphone review: The new best Android phone
- Japan Robot, gadget and car expo slideshow
- Panasonic DX900U UHD 4K smart TV review: Best all-round TV ever?
- What's the difference between an Intel Core i3, i5 and i7?
- Laser vs. inkjet printers: which is better?
- CCContract Management SpecialistNSW
- CC.Net DeveloperWA
- CCDemand ManagerNSW
- CCSAP GRC consultant with ABAP experience . Canberra LocationNSW
- CCProgram ManagerACT
- CCWeb Analytics AnalystNSW
- FTDigital DeveloperNSW
- CCLevel 3 Microsoft Resource EngineerVIC
- FTTechnical Support Engineer | Cloud | Automation techsNSW
- CCQA Test Lead- Digital, Mobile, UX, AGILE, CloudNSW
- CCContract Junior Programmer (J2EE/Oracle/XML) 161018/JP/922Asia
- CCSenior Siebel Business AnalystACT
- FTEmbedded Software EngineerSA
- CCPOS EngineerNSW
- CCContract Computer Operator (UNIX/Windows-based) 161014/CO/vmtAsia
- CCSenior Business Analyst, Margin ProjectsNSW
- CCSenior Project Manager (Marketing Automation)NSW
- CCContract Analyst Programmer (HTML/JAVA/J2EE) 161025/AP/862Asia
- FTSenior programmer / ProgrammerAsia
- CCAutomation Test AnalystNSW
- CCInfrastructure ArchitectNSW
- FTScrum MasterNSW
- CCProject ManagerACT