|FileMaker Pro 5.5 (Trial),
by FileMaker Inc
The Trial version of FileMaker Pro expires 30 days after installation and is limited to 50 records per database file. I had a 2.1 database file of a home inventory that I wanted to use with the 5.5 Trial version to test the compatibility with older files. Since it had more than 50 records, I had to modify the file with FileMaker Pro 2.1. The modified file loaded into 5.5 perfectly, and even the script created in version 2.1 still worked in 5.5. It did not feel like a different program, but an improved version of a familiar program. This is a good thing!
Four different view modes are available: Browse, Find, Layout, and Preview. The Browse Mode is the default view where you look at your records and add new records to the database. In the Find Mode, records meeting certain search criteria can be found and displayed. The Layout Mode is where you can make different database layouts to display the data the way you want. When you are entering data into the records, you normally want to see all the fields. When you make a report, however, you may just want a subset of the data. You can do this in the Layout Mode. The New Layout/Report assistant under the Layouts menu will help you perform this task. In the Preview Mode, you can see how a layout will look with the data before you print it.
A new view available is View as Table which will display your database in a spreadsheet type mode. Speaking of spreadsheets, FileMaker Pro will import an Excel spreadsheet and turn it into a functional database quite easily.
One of my favorite features of FileMaker Pro is ScriptMaker. ScriptMaker will help you to automate routine tasks that would normally take several steps to complete. For example, you may want to change to a specific layout, find certain records, sort those records, change to Preview mode, print the report, and then return to the previous layout mode. If you want to repeat this process on a regular basis, you can easily create a script using ScriptMaker. Then, by making a script selection from the Script menu, this process can be repeated on deman by selecting a simle menu item. You can also create a button in the Layout mode to perform the script while in the Browse mode.
Similar to Microsoft Office applications, FileMaker Pro now has Toolbars. Menus and Toolbar Buttons change according to the current Mode. The Toolbars make performing the most commonly use functions quicker, and you can show or hide the different Toolbars. However, unlike with Microsoft Office, you cannot customize the toolbars.
I also installed the FileMaker Pro Trial on the Windows 2000 PC that I use at work. Working with the same databases between the two platforms was as seamless as advertised. The only caveat is when you create database files on the Macintosh, you need to add the .fp5 extension to the file name to keep Windows happy.
If you are an AppleWorks user and find its database not powerful enough, get a copy of the FileMaker Pro Trial and give it a try. You will find that creating databases is very similar, but you have a much richer feature set.