Customer Reviews

FileMaker Pro 10: The Missing Manual

5 star:		(20)
4 star:		(10)
3 star:		(3)
2 star:		(1)
1 star:		(1)

 

 

I've been using FileMaker Pro for over ten years now, pretty much creating simple databases and runtime solutions for myself and fellow workers.

Earlier this year, however, I was commissioned to create a safety-related database (runtime solution) for none other than FedEx and its nine feeder-carriers. Talk about instant panic-attack! When I found out that I'd be the authoring it I immediately perused Amazon.com and bookstores for books that would help me get up to speed very quickly so I could start coding away; I ordered an armful of them, some were "bible" and "idiot"-titled tomes and others were so "up there" technically that my eyes glazed over just reading their Table of Contents. More often than not they made me feel dense because there weren't enough explanations or examples in them for me to fully understand what was trying to be explained.

The book I ended up using the most--and really appreciating its real-world use and easy-to-understand explanations--was "FileMaker Pro 8, The Missing Manual" by Geoff Coffey and Susan Prosser. I can honestly say without any hyperbole that their book, and downloadable practice files, gave me a solid foundation to work from so I could build the database. After some finishing touches supplied by FileMaker developer Matt Lygo of kantala.com, I submitted the database to FedEx...and they LOVED it--so much so I earned their prestigious BZ Award for Excellence.

Since then, I've been working on another project that requires much greater power and flexibility than what FileMaker 8 or 8.5 had to offer, so after upgrading to FileMaker 9.0 _the_ first book I bought was Coffey and Prosser's Missing Manual book for FileMaker 9.0. Still a winner, I'm reading it as both a refresher and to learn the new powers that come with 9.0. It's both time and money well-spent.

So, if you're looking for a book to get you going in FileMaker, make this one your first choice; you'll be glad you did.

This book is now in it's third writing. The first one (for Filekaker 7) never got printed as the release of Filemaker 8 made so many improvements to the software that a revision was mandatory. Nevertheless that early writing served its purpose as the precursor for the previous edition of this book on FileMaker 8. That edition was a real eye opener for me as it taught me so much more about the program than I had ever appreciated after many years of use. Now we have, what is in effect a third writing, for the latest version of FileMaker Pro and the benefit of those previous versions is certainly evident.

These authors have an excellent style of writing for a technical product like FileMaker Pro -- the style is both readable and accurate with plenty of light hearted quips to provide a delightful human touch to what could otherwise become fairly dreary tome. The book is thus not only a very readable tutorial on the methodology for setting up a relational database, but it also has a multitude of advice on ways to ensure that your development will follow guidelines for best practice. Explanations of "The FileMaker Way" are thus easy to follow and also display the authors' comprehensive knowledge of the program. This undoubtedly stems from their own credible work as practising FMP developers in their own right.

Some professional database gurus seem to take pleasure in deriding FileMaker for its simplicity of use and seeming inability to scale for enterprise tasks. What they overlook is that FileMaker is evolving into a data hub with its ability to exchange data so readily with an increasing number of other file formats. I can see how some of these folk will not find this book so useful as a reference work. It has not been written to be used in that way. If you come from a computer science training in DBMS, then you are only going to use Filemaker effectively if you take sufficient time to understand how and why FileMaker is different. The Missing Manual can certainly help you to achieve that but its style may not be as appropriate for your needs as it is for the database user who now wants to develop databases for their own projects.

In summary then, this book is certainly a manual "that should have been in the box" but it makes no claims to being the only source of FileMaker knowledge that you will ever need. There are plenty of other resources to meet that need but I firmly believe you will be hard pressed to find any other text or resource that can match this "Missing Manual" for its comprehensive introduction to FileMaker Pro..

The book is as massive and complete as Filemaker 9 software. I found that it was at first intimidating because of the 750 + pages but after you dive in and learn to use the index the book because a lifesaver and close companion. I highly recommend it to anyone trying to use this powerful program.

The Missing Manual series is, overall, quite good with few misses. "FileMaker Pro 10 - The Missing Manual" is no exception to the generally high quality of the series.

I've used FileMaker since its very first version when it was produced by a company called Nashoba Systems. FileMaker has always been an excellent product, but with each new version, new features add another level of complexity. The early Nashoba and Apple documentation was excellent, but bit by bit the standards slipped. Printed manuals gave way to online help.

A mini-industry developed as publishers introduced new titles. It was never a tsunami, but there were a number of books on various aspects of FileMaker, some very well developed references.

The Missing Manual neatly fills the gap.

Starting with the basics, you are guided through the basics in the first three chapters. In reality, many people will not need to go beyond this point. There's enough here to get you through the creation and maintenance of simple FileMaker databases.

Beginning with Chapter 4, on layouts, your knowledge will quickly expand. FileMaker was among the first, if not the first, microcomputer database product to allow you to design layouts to meet your needs. Since those early days, the power of the FileMaker layout engine has grown almost beyond comprehension. You can create whatever layout meets your needs - and you can have multiple layouts per database. The Missing Manual does a superb job of showing you how to create very sophisticated layouts. It is important to understand that a FileMaker layout differs considerably merely creating a user interface: in FileMaker, the various fields are also components of the database. For example, for summaries, you use a particular field and have to create a formula to manage it. The Missing Manual explains all this quite nicely.

The remaining nine chapters lead you into more complex areas of database design in general and FileMaker in particular. In order, the chapters cover using multiple tables and relationships and then advance relationship techniques. These can be difficult concepts to grasp and even more difficult to implement. The book helps you along, though it doesn't really get into very complex relationships.

The next four chapters cover calculations. You can create FileMaker fields that perform virtually any computational task. One of the reasons I've used FileMaker for so many years is because I can use it to rearrange, recombine, sort and do all manner of things with text. Though I don't it use it much for mathematical calculations, it has every function you might reasonably need. Obviously because four chapters are devoted to it, there's a lot to FileMaker calculations and the book is thorough in its approach.

Two chapters on scripting follow. Over the years, FileMaker scripting has progressed from being a hair-pulling experience to being occasionally frustrating. If you're developing databases that must perform for relatively unskilled users, scripting is a must. Only your imagination and the sometimes confusingly documented or undocumented FileMaker feature set will stop you.

The last four chapters are the ones that will be the least used. Most people simply will not need information on adding security to your database, sharing data with other systems, sharing the database itself and using developer utilities.

Overall, "FileMaker 10 - The Missing Manual" follows its earlier editions in being almost a model for a solid technical manual. If you own FileMaker 10, you need this book. It is not the only FileMaker book you'll need, since there are others that are more suited to the reference role, but it is essential.

Jerry

Pros:

- The writing style is accessible and easy to understand
- You can download the database examples used in the book.
- It's the best FileMaker Pro 9 book I've seen.

Cons:

- Like a lot of computer books out there, this one is unnecessarily wordy. The publisher said, "I need a 750-page book," and the author complied.

-And you gotta read ALL of it (especially beginners), because important information is distributed like buried treasure.

- The wordiness and lack of consistent structure makes it easy to get lost. Let me give you an example:

This is my first stab at FileMaker Pro. The first chapter shows you how to find records. It starts out nicely with bolded text showing the steps to perform a find. Then it gets wordy. And then it shows a few figures of what you will see. Huge paragraphs of smaller, italicized text accompany the figures.

I skipped the figures and went on. Suddenly, I couldn't access most of my database entries. I went back to Browse mode, like the book told me to do, and still couldn't see them.

Finally, after much digging, I found the crucial step I had missed, buried in the smaller, italicized text of the gargantuan paragraph accompanying Figure 1-17. Inconsistencies like this make the book a tough slog.

I just brushed up on my Access 2003 (I haven't used it in 7 years) with one of those procedure-based illustrated books. It took me 3 hours to get through the 250-page book. It took me about an hour to get through chapter 1 (27 pages) of this book.


I recommend downloading the examples from their website (I doubt you got a CD-ROM with your book). See the Missing CD-ROM link on this book's web page.

When I picked up Filemaker Pro 10: The Missing Manual, I was looking for a book that would help me get a jump start on building a relational database with multiple many-to-many relationships. So far I have completely redesigned one database I had created and creating a new one.

I haven't found every detail I was looking for, but this is a big book! I am learning that FileMaker Pro 10 is quite capable of doing most anything I'd want. One of the things I like about it is that it explains database concepts. I took a course in metadata for Internet-based database systems and I wish I had had this book going into that class because the book really helps a person understand the process of designing an information management system: tables, relationships, etc. It is very easy to overcomplicate the whole thing, and this book tells you what questions to ask yourself along the way.

The Missing Manual guides the reader through creating a database, designing layouts, working in calculations, including logical functions (if...then), and much more. I am sure I'll be referring to it and learning something new for many months to come.

It's been years since I used Filemaker, and then only as a database user...not the creator of the application. So when I set out to create a new FM database solution for a small private school I needed help! The tutorial provided with Filemaker9 is VERY basic and the application's "Help" tool is very thin. (I finally stopped clicking on it when search after search yielded no real help at all.)

I picked up a copy of the Missing Manual hoping it would save my neck. I found that I already knew the material in the first half of the book, which was actually comforting. It was the second half where I found the help that I needed to make my FM solution do what I wanted it to do. The Missing Manual is well written by real humans...even with a bit of a sense of humor thrown in. And downloadable files on the Missingmanuals.com site make it easy to learn through hands-on exercises.

I'm now rockin' & rollin' on my new database application! FileMaker is a powerful tool and the Missing Manual has helped me to unlock its secrets! A few dollars very well spent!

For anyone that uses FileMaker Pro on a daily basis, this book is an absolute steal. With over 750 pages of relevant information, the authors go beyond this applications basic use as digital address book and really get into the details of what makes this a great application. With tons of pictures and clear detail how to follow along, the authors start with the basic use of displaying and inputting people data and go far beyond that, discussing design of databases and learning how to script FileMaker Pro to get this program to do nearly anything you need it to! Reports, exporting data to other formats, or publishing to the web, this book has it all!

A must read for any FileMaker Pro user who wants to get the most out of their experience and learn the ins and outs.

***** HIGHLY RECOMMENDED

One of the first things that I noticed about "FileMaker Pro 9: The Missing Manual" is it's size. It's a big, heavy book, clocking in at 778 pages. But there is a good reason for this: This book covers a lot -- and I mean a LOT -- of ground. As such, it has something for everyone. From newcomers to veteran developers, you're bound to find something new here. So don't let it's size scare you away!

Written by Geoff Coffey (of Six Fried Rice fame) and Susan Prosser (president of dbhq, a FileMaker certified consulting firm based in Gilbert, Arizona), FileMaker Pro 9: The Missing Manual is part of a series of books published by Pogue Press. Like other books in the series, it is very well written, and is presented in a way that allows a lot of information to be presented without overwhelming the reader.

The book is divided into seven parts. Part One provides a good introduction to FileMaker Pro and is a good start for FileMaker newcomers. Part Two covers layouts, including all of the tools that are available to us in layout mode. Part Three dives into relational databases, with information on modeling, relationships, table occurrences, data tunneling, and more.

Part Four deals with calculations, and does a good job of explaining topics that can be hard to grasp, including the Self function, the Let function, and variables. The "Power User Tip" in this section is one of the best examples that I've seen yet on how to put the Let and Self functions to good use. It shows how to use these functions, and a few others, to clean up and format a user-entered phone number.

FileMaker users who have yet to automate their databases with scripts will find Part Five of FileMaker Pro 9: The Missing Manual especially useful. Everything from script basics and how to use ScriptMaker, to advanced scripting techniques, is covered. The information presented about script parameters is especially informative. Readers will learn how to pass multiple parameters to a script, as well as how to pass parameters to subscripts. Script variables, and error handling techniques, are also covered.

Part Six covers FileMaker security and integration. Readers will learn how to use FileMaker's built-in security model to protect their databases. In terms of integrating Filemaker, this section explains how to share data in FileMaker databases with other systems, and vice versa. The authors do a great job of introducing what many believe to be one of the most compelling new FileMaker features: External SQL Sources (or "ESS"), which was introduced in FileMaker Pro 9. Rounding out Part Six are terrific explanations of some of the developer utilities that are only available in FileMaker Pro Advanced. Copying and pasting database structures, the script debugger, the data viewer, the database design report, tooltips, custom menus, and more are covered.

And finally, Part Seven includes two helpful appendixes. Appendix A, "Getting Help," offers a good review of other places that developers and users can turn to when they run into trouble. Appendix B provides a list of FileMaker Error Codes.

At a list price of $34.99, FileMaker Pro 9: The Missing Manual is a smart, affordable investment for any FileMaker user or developer. Reading the book is like taking a crash course in FileMaker Pro development. Read it, and your FileMaker skills are sure to benefit!

A well written book with good insight into features of Filemaker 9. Great tips along the way for designing structure and layout. Authors do a good job in detail explanations. Good translation of technical concepts into real life usage.