FileMaker Pro 9: The Missing Manual (Paperback)

~ (Author), (Author)
Key Phrases: script debugger, extended privileges, trailing grand summary, Line Items, First Name, Last Name (more...)

Editorial Reviews

Product Description

FileMaker Pro 9: The Missing Manual is the clear, thorough and accessible guide to the latest version of this popular desktop database program. FileMaker Pro lets you do almost anything with the information you give it. You can print corporate reports, plan your retirement, or run a small country -- if you know what you're doing. This book helps non-technical folks like you get in, get your database built, and get the results you need. Pronto.

The new edition gives novices and experienced users the scoop on versions 8.5 and 9. It offers complete coverage of timesaving new features such as the Quick Start screen that lets you open or a create a database in a snap, the handy "save to" buttons for making Excel documents or PDFs, the multiple level Undo and Redo commands let you step backwards through your typing tasks, and much more. With FileMaker Pro 9: The Missing Manual, you can:

• Get your first database running in minutes and perform basic tasks right away.
• Catalog people, processes and things with streamlined data entry and sorting tools.
• Learn to use layout tools to organize the appearance of your database.
• Use your data to generate reports, correspondence and other documents with ease.
• Create, connect, and manage multiple tables and set up complex relationships that show you just the data you need.
• Crunch numbers, search text, or pin down dates and times with dozens of built-in formulas.
• Automate repetitive tasks with FileMaker Pro 9's easy-to-learn scripting language.
• Protect your database with passwords and set up privileges to determine what others can do once they gain entry.
• Outfit your database for the Web and import and export data to other formats.

Each chapter in the book contains "living examples" -- downloadable tutorials that help you learn how to build a database by actually doing it. You also get plenty of sound, objective advice that lets you know which features are really useful, and which ones you'll barely touch. To make the most of FileMaker Pro 9, you need the book that should have been in the box.

About the Author

Geoff Coffey has years of FileMaker Pro experience and is an early beta tester.

Product Details

• Paperback: 800 pages
• Publisher: O'Reilly Media; 1 edition (August 2, 2007)
• Language: English
• ISBN-10: 0596514131
• ISBN-13: 978-0596514136
• Product Dimensions: 9.1 x 7.1 x 1.7 inches
• Shipping Weight: 2.9 pounds (View shipping rates and policies)
• Average Customer Review: 4.5 out of 5 stars  See all reviews (31 customer reviews)
• Amazon.com Sales Rank: #435,460 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #4 in	Books > Computers & Internet > Networking > Networks, Protocols & APIs > ODBC
  #12 in	Books > Computers & Internet > Databases > Specific Databases > FileMaker

Customer Reviews

Most Helpful Customer Reviews

59 of 61 people found the following review helpful:

5.0 out of 5 stars This book won't end up as a doorstop or a climbing platform for your cat(s), November 3, 2007

By	R. Stuart "A 21st Century Man" (Post Falls, ID United States) - See all my reviews (REAL NAME)

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.

17 of 19 people found the following review helpful:

5.0 out of 5 stars So much more than a "Missing Manual.", October 21, 2007

By	John E. Wolff (Hamilton, NZ) - See all my reviews (REAL NAME)

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..

9 of 11 people found the following review helpful:

5.0 out of 5 stars FILEMAKER 9 .. MISSING MANUAL, November 25, 2007

By	David Mayer - See all my reviews (REAL NAME)

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.