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!
Microsoft L5V-00027 Sculpt Ergonomic Keyboard Desktop
Epson WorkForce ET-4550
Linksys AC5400 MU-MIMO Gigabit router
Epson EcoTank Expression ET-2500
Smart LED Bulb LB130
Samsung portable 1TB T3 drive
UE Boom 2 Bluetooth speaker
Lexar® JumpDrive® S57 USB 3.0 flash drive
Google Daydream VR headset
Epson WorkForce DS-360W
3SIXT Ultra HD Sports Action Camera
Lexar® Portable SSD
Huawei Mate 9
Belkin MIXIT Metallic Lightning to USB Cable
Lexar® JumpDrive® S45 USB 3.0 flash drive
Acer Swift 7
Logitech G403 Prodigy mouse
Dell XPS 13 laptop
Garmin Fenix Chronos smartwatch
HP Pavilion x360 13”
Lexar® Professional 1800x microSDHC™/microSDXC™ UHS-II cards
Surface Pro 4
Dell Inspiron 5000 series 2-in-1
Blade 28 backpack by Arc’teryx
Lexar® JumpDrive® C20c USB Type-C flash drive
HD Pan/Tilt Wi-Fi Camera with Night Vision NC450
Audio-Technica ATH-ANC70 Noise Cancelling Headphones
Most Popular Reviews
- 1 Oppo R9s Plus phone: Full, in-depth review
- 2 Samsung 2017 QLED Q7 TV: Full, in-depth review
- 3 HTC U Ultra phone full, in-depth review
- 4 Gigabyte Aorus GA-AX370-Gaming 5 AMD Ryzen AM4 motherboard review
- 5 Kogan curved 4K UHD 55-inch LED LCD TV review
Latest News Articles
- 10 powerful, obscure Windows keyboard shortcuts you should know
- Microsoft delays tools for third-party Cortana integrations
- Samsung unveils Bixby voice assistant for upcoming Galaxy S8
- Pwn2Own hacking contest ends with two virtual machine escapes
- It's time to turn on HTTPS: the benefits are well worth the effort
PCW Evaluation Team
A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.
I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.
As a freelance writer who is always on the go, I like my technology to be both efficient and effective so I can do my job well. The HP OfficeJet Pro 8730 Inkjet Printer ticks all the boxes in terms of form factor, performance and user interface.
I’d happily recommend this touchscreen laptop and Windows 10 as a great way to get serious work done at a desk or on the road.
Ultimately, I think the Windows 10 environment is excellent for me as it caters for so many different uses. The inclusion of the Xbox app is also great for when you need some downtime too!
For me, the Xbox Play Anywhere is a great new feature as it allows you to play your current Xbox games with higher resolutions and better graphics without forking out extra cash for another copy. Although available titles are still scarce, but I’m sure it will grow in time.
- Samsung Galaxy A5 2017 phone: Full, in-depth review
- LG G6: unboxing, hands on review and detail shots
- And the 2017 winner of the Formula 1 Best Pit Lane Boom Gantry is...
- What's the difference between an Intel Core i3, i5 and i7?
- Laser vs. inkjet printers: which is better?
- FTSocial Media ExecutiveNSW
- CCProject Manager Retail Supply Chain OptimisationQLD
- FTLinux / Unix Systems AdministratorSA
- FTDrupal Developer - Senior or Mid levelQLD
- FTSenior .Net DeveloperNSW
- CC.NET Developer!QLD
- FTWorkforce AnalystNSW
- FTInfrastructure ArchitectVIC
- CCAutomation Developer - LinuxNSW
- FTSolution Architect (e-Health)NSW
- CCNetwork Engineer (cisco)NSW
- FTWeb DeveloperACT
- FTDevops EngineerVIC
- TPJunior Software DeveloperQLD
- FTField Deployment EngineerNSW
- FTChange ManagerNSW
- CCOrganisational Change Manager - Banking/Financial ServicesNSW
- CCSAP FICO ConsultantWA
- TPAgile Implementation LeadNSW
- FTWeb Developer/ReportsNSW
- FTInfrastructure ArchitectNSW
- TPBusiness AnalystNSW
- FTProject Manager - Financial Forecasting SystemsNSW
- FTProject Manager, FinanceNSW
- FTBusiness Improvement ManagerNSW