Search

Search Tips

FileMaker Pro 9: The Missing Manual

By Geoff Coffey, Susan Prosser
August 2007
Pages: 799
Series: The Missing Manuals
ISBN 10: 0-596-51413-1 | ISBN 13: 9780596514136
Press Release (Average of 1 Customer Reviews)

Description

FileMaker Pro 9: The Missing Manual is the clear, thorough and accessible guide to 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. This Missing Manual helps non-technical folks like you get in, get your database built, and get the results you need. Pronto.
Full Description

---

---

Featured customer reviews

FileMaker Pro 9 : The Missing Manual -- Review,  October 08 2007
Submitted by Tom Cremer   [Respond | View]

FileMaker Pro 9 : The Missing Manual/ Geoff Coffey and Susan Prosser
Pogue Press/O'Reilly Sebastapol, California 2007. US $34.99

“FileMaker Pro 9 : The Missing Manual” Review -- Thomas Cremer

Filemaker Pro is a database application (a program for storing any systematic collection of information) compatible with both Mac OS X and Windows and other platforms. It is known for being easy to use and powerful as well.

Filemaker was developed in the 1980’s and is now very popular and adaptable, you don’t have to be a “geek” or a programmer to use it. Home users to large corporations
such as NASA are amongst the millions of users of this database management system. Apple uses Filemaker as the database to handle customers and transactions to do with the online store, for example.

FMP can handle relational databases, which are collections of related files that share data like invoice numbers which link important transaction information together, such as customer, inventory, or shipping and handling data.

Geoff Coffey and Susan Prosser are the authors of this “Missing Manual” and their book helps novices to create their own databases, covering the changes in versions 8.5 and 9. FMP comes with printed and online documentation, but it is not as user-friendly or as detailed as the Missing Manual.

Coffey and Prosser have been developers and users of FMP for over ten years, and their language is simple, helpful and non-technical, just the ticket for “newbies” eager to learn.
The exciting thing about FMP is that users can begin with ready to go templates or so-called starter solutions, which are available for many common database needs. The book, published in August this year, covers old and new features of FMP thoroughly, with many examples and sample databases. For readers who prefer the PDF format, that version of the book is available on the oreilly.com website, advertised on the last page.

The first three chapters give the reader a quick tour of the main features of FMP, getting started on a simple contact management database, used to track useful details of people, organizing and editing records in such a database and designing a contact database from the perspective of the user.

The second part of this book discusses database structure, looking at layouts or views of records as used for different purposes. A computer database can generate tags, forms, envelopes, labels, reports and even mass mail-outs. FMP can now use links to information like shipping details found on the internet with the new webviewer function. Layouts and reports are covered in chapters 4,5, and 6.

Part 3 explains relational databases, a major strength of FileMaker Pro. This complicated section is systematically and expertly approached, something that cannot be adequately done by the online documentation of FMP alone.

Powerful calculations performed by database functions are introduced to the reader by chapters nine to twelve. Actually processing data is basic to FMP, doing all sorts of useful things like summing, analysing and comparing values. Functions done with numeric data include mathematical, financial and trigonometric processes. A scientific or statistical research background would be very useful to readers working on this aspect of database development. FMP can be a very sophisticated tool, useful for much more than routine business inventories. Data can be output in the form of PDF or Excel files.

Scripting is a form of programming which can automatically perform a series of steps working on database information to produce a useful, routine report. Scripting can be a tool for developing very specialized databases. Three chapters of the book are devoted to ever more complicated scripting examples, beginning with the basics and building up to advanced forms. Luckily for the novice database user, FMP can be used with about 40 different templates without necessarily requiring scripting skills. This Missing Manual book illustrates what a powerful tool FileMaker Pro can be in its latest incarnation, depending on the skills of the developers and the users.

Database security is about which users can access the database, what privileges they have while working with it (what aspects of the database they can modify), and who they can share information with. External sources of data like SQL and ODBC are discussed, data sharing over networks and the internet, and setting up a FileMaker server are all advanced topics covered in chapters sixteen to eighteen. FileMaker Pro 9 can now be integrated with external data sources such as Microsoft SQL servers, so FMP can talk to the rest of the information world.

The final chapter covers special programs for FMP developers, including database structures, and script debugging, or working out problems with scripting. The final sections on security and database development are fairly advanced, and everyday users of FileMaker Pro will not have to concern themselves too much with them. The beauty of this book is that it gives readers an overall view of issues involved in working with FileMaker Pro from the basics right through to advanced problems.

The appendices on Getting Help and FileMaker Error Codes are very useful, while the table of contents and the index are excellent for finding help as users work with FileMaker Pro 9.

This “Missing Manual” book well and truly lives up to the formidable reputation that this series of software books deserves, and authors Geoff Coffey and Susan Prosser are to be congratulated for tackling a complex topic so well. FileMaker Pro 9 users are thus given the confidence they need to work with this popular database software.

Read all reviews

---

Media reviews
"We're thrilled to see an update to the Missing Manual series for FileMaker Pro 9. The authors' unique ability to explain deep FileMaker Pro topics with clarity and simplicity make it a perfect fit for our customers."
-- Ryan Rosenberg, vice-president, Marketing and Services, FileMaker


"One of the beauties of the Missing Manuals is that there is always something new to discover and the research is quite thorough...I kept finding snippets of information, in the way of Tips or Notes, that would give just that bit extra."
-- Graham K. Rogers, Bangkok Post


"The Missing Manual series is a collection of good and useful books. They serve a need by acting as guides for learning and more easily accessing information about your application that is not usually supplied by manuals that come with software. The authors in the series and in this manual, do a great job and go “above and beyond.” For novice to advanced users, this book’s details and the authors’ added guidance and instruction will give you a better understanding how to create and use your databases, but doing them right and advancing your skills along the way. This book for FileMaker Pro 9: The Missing Manual is no exception. It offers breadth and depth and worthwhile background and clues for learning and developing your databases. The price of the book is right, the instruction and detail are well done. Why wait? Take the step towards learning how to make your databases like a pro and with FileMaker Pro 9: The Missing Manual."
-- Dr. Eric Flescher, MacCompanion



Read all reviews

• 
  

---

• Table of Contents
• Index
• Sample Chapter
• Missing CD-ROM
• Colophon
• Register Your Book
• View/Submit Errata
• View/Submit Review

"For novice to advanced users, this book’s details and the authors’ added guidance and instruction will give you a better understanding how to create and use your databases, but doing them right and advancing your skills along the way."
--Dr. Eric Flescher, MacCompanion