- Shopping Bag ( 0 items )
Advice and techniques that you need to get the job done.
Looking for ways to streamline your work so that you can focus on maximizing your time? In Depth provides specific, tested, and proven solutions to the problems you run into every day–things other books ignore or oversimplify. This is the one book that you can rely on to answer all the...
Advice and techniques that you need to get the job done.
Looking for ways to streamline your work so that you can focus on maximizing your time? In Depth provides specific, tested, and proven solutions to the problems you run into every day–things other books ignore or oversimplify. This is the one book that you can rely on to answer all the questions you have now and will have in the future.
In Depth offers:
COVERS: FileMaker® Pro
INTRODUCTION: Welcome to FileMaker Pro 10Introduction: Welcome to FileMaker Pro 10 Best of Three Worlds
Welcome to the world of FileMaker Pro 10. By simply browsing through this book, you’re sure to have seen the word database. We cover what databases are in the rest of this book, but one of the first things you need to understand about FileMaker Pro 10 is that it is far more than just a database application.
FileMaker Pro 10 is nearly unique in the world of software. It is a powerful database system that can manage and store a wide range of information—it’s an application for end users (like Microsoft Excel or Intuit’s Quicken), and it’s also a robust rapid application software development platform.
When you hear people speak about FileMaker, keep in mind they might be viewing it from any one of these different perspectives. An IT professional likely sees FileMaker as a database engine that fits into a larger security and network infrastructure. An end user is probably thinking about a specific solution built in FileMaker Pro and how it helps make her work more efficient. A software developer might see FileMaker as one of many tools he employs in building a wide range of applications.
This book was written with an eye toward the FileMaker developer community. If you’re mostly interested in learning how to use the essential features of the FileMaker application, though, this book might not be for you. Although we’ve included some introductory chapters to be as comprehensive as possible, we’ve chosen to focus on an audience that we assume is largely familiar with the essential operations of FileMaker already and is interested mostly in topics for the beginning to advanced developer.
How This Book Is Organized
FileMaker Pro 10 In Depth is divided into five parts, organized into something like a tree. Part I, “Getting Started with FileMaker 10,” and Part II, “Developing Solutions with FileMaker,” constitute the “trunk” of the tree; they cover fundamental material that we recommend everyone read.
Subsequent parts branch out from this base. Part III, “Developer Techniques,” focuses on using FileMaker’s features to develop complete, robust database applications. Part IV, “Data Integration and Publishing,” covers getting data into and out of FileMaker. And Part V, “Deploying a FileMaker Solution,” covers options for making a FileMaker solution accessible to others.
The following sections describe the five parts of FileMaker Pro 10 In Depth and the topics they cover.
Part I: Getting Started with FileMaker 10
Part II is intended to introduce you to the fundamental techniques of database application development using FileMaker Pro and FileMaker Pro Advanced. Chapters 5 through 7 cover the theory and practice of designing and building database systems with multiple data tables. Chapters 8 through 10 introduce you to foundational concepts in application and reporting logic.
The chapters in Part III delve deeper into individual topics in advanced FileMaker application development. We build on earlier chapters by exploring more complex uses of portals, calculations, and scripts. We also offer chapters that help you ready your FileMaker solutions for multiuser deployment, and we examine the still-important issue of conversion from previous versions.
Part IV covers technologies and capabilities that allow FileMaker to share data, either by exchanging data with other applications, or by exporting and publishing data, for example, via ODBC, JDBC, and the Web.
Part V delves into the choices you have for how to deploy a FileMaker database, including deployment via FileMaker Server and via kiosk or runtime mode using FileMaker Developer.
This book includes the following special features:
Most of the examples in this book are based on the FileMaker Starter Solutions that are installed automatically for you when you install FileMaker. Thus, you already have most of the files. In some cases, additional files or additional code has been added to the Starter Solutions as described in this book. These files can be downloaded from filemakerindepth.com. You can also download them from the publisher’s website at http://www.informit.com/title/9780789739469.
Who Should Use This Book
Like FileMaker itself, this book has several audiences. If you work with structured data a lot (Excel spreadsheets, for example) but are new to databases, this book will provide you with a solid foundation in the world of databases, in the basics of database theory, and in the practical skills you need to become a productive database user or developer. The book’s more introductory chapters tell you what you need to know to get started building basic databases for your own use. Later chapters introduce you to the world of multiuser database design and to some of FileMaker’s more advanced application design features.
If you’ve worked with other database systems—either server-side relational database engines based on SQL or desktop development environments such as Access—this book will help you see how FileMaker Pro fits into the universe of database software. Refer to the “How This Book Is Organized” section earlier in this Introduction to get a sense of which chapters will get you started quickly with FileMaker.
And in case you’re an old hand with FileMaker, we’ve provided a good bit of in-depth discussion of advanced techniques and have called out new FileMaker 10 features throughout the book.
© Copyright Pearson Education. All rights reserved.
I Getting Started with FileMaker 10
1 FileMaker Overview 7
2 Using FileMaker Pro 23
3 Defining and Working with Fields and Tables 75
4 Working with Layouts 103
II Developing Solutions with FileMaker
5 Relational Database Design 143
6 Working with Multiple Tables 159
7 Working with Relationships 177
8 Getting Started with Calculations 197
9 Getting Started with Scripting 229
10 Getting Started with Reporting 257
III Developer Techniques
11 Developing for Multiuser Deployment 285
12 Implementing Security 297
13 Using the Web Viewer 325
14 Advanced Interface Techniques 335
15 Advanced Calculation Techniques 351
16 Advanced Scripting Techniques 387
17 Working with FileMaker Triggers 403
18 Advanced FileMaker Solution Architecture 413
19 Debugging and Troubleshooting 427
20 Converting Systems from Previous Versions of FileMaker Pro 453
IV Data Integration and Publishing
21 Connecting to External SQL Data Sources 471
22 Importing Data into FileMaker Pro 493
23 Exporting Data from FileMaker 511
24 Instant Web Publishing 521
25 Custom Web Publishing with XML/XSLT 545
26 Custom Web Publishing with PHP 575
V Deploying a FileMaker Solution
27 Deploying and Extending FileMaker 587
28 FileMaker Server and Server Advanced 601
Posted November 17, 2009
I own the print version of this book, also. Wanted a digital version on my Mac and iPod Touch for convenience. I chose the eReader format rather than Kindle for two reasons. First, at this point Kindle Reader does not support search on the Touch, nor the ability to copy text. Same is true for the beta version of Kindle's PC reader, and the Mac version of Kindle reader has not been released yet. Second, I already have another Filemaker title in the Kindle reader format and wanted to try the BN eReader format.
While I like the eReader on both the Touch and the PC (using Windows in Fusion on my Mac) better than the Kindle readers, the conversion of this book is awful. Linked text is presented out of place (the header for paragraphs in the intro section is at the start of the following paragraph). Throughout the title, linked text is presented at the end of sentences or paragraphs, rather than in context. The result is a very confusing reading experience. Additionally, the presentation of figures is a mess. Referenced figures do not appear anywhere close to the reference in many cases, and may in some cases actually be completely missing. In some cases clicking on a link to a figure, takes you to another location in the text, but not to the figure it references.
I really like the ability to search within the title, highlighting and notes, as well as the copy function in the Mac version.
For reading fiction, I think either reader would be great. For reference works, such as "Filemaker Pro 10 In Depth", searching, highlighting, notes and copy are a huge advantage. Had I known, however, how difficult it would be to read the eReader version of this book, I would have chosen the Kindle version, even at its slightly higher price. "The Filemaker Pro 10 Bible" on the Kindle reader is presented much better than this book is. Hopefully Barnes & Noble will correct the problems with the book or the software, whichever is causing these issues, because when I'm ready to buy a dedicated reader, I really like the looks of the Nook better than the Kindle, but almost all the books I would buy would be computer related references, and I can't buy the printed version, just so I can read the ebook without getting confused.
Posted October 12, 2010
No text was provided for this review.