FileMaker Pro 8: The Missing Manual

book cover
FileMaker Pro 8: The Missing Manual
By Geoff Coffey, Susan Prosser
Publisher: O'Reilly
Pub Date: September 2005
ISBN: 0-596-00579-2
Pages: 762

Table of Contents  | Index

Used by millions worldwide, FileMaker Pro is an award-winning database program for managing people, projects, images, assets, and other information. It's easy to use and totally customizable--so long as you know what you're doing. But FileMaker Pro doesn't come with a printed manual, so FileMaker Pro: The Missing Manual is the authoritative, jargon-free book that should have been in the box.

FileMaker Pro: The Missing Manual approaches FileMaker the way FileMaker approaches you: it's user-friendly and seemingly straightforward enough, but it offers plenty of substance worthy of deeper exploration. Packed with practical information as well as countless expert tips and invaluable guidance, it's an in-depth guide to designing and building useful databases with the powerful and pliable FileMaker Pro.

Covering FileMaker for both Windows and Macintosh, FileMaker Pro: The Missing Manual is ideal for small business users, home users, school teachers, developers--anyone who wants to organize information efficiently and effectively. Whether you want to run a business, publish a shopping cart on the Web, plan a wedding, manage a student information system at your school, or program databases for clients, this book delivers.

Author Geoff Coffey has many years of experience using FileMaker Pro (he was, in fact, an early beta tester for the product). Author Susan Prosser is a FileMaker Certified Developer who trains other developers. Together, Coffey and Prosser show you how to:

  • Get FileMaker up and running quickly and smoothly

  • Import and organize information with ease

  • Design relational databases that are simple to use, yet powerful

  • Take advantage of FileMaker Pro calculation capabilities

  • Automate processes with scripting

  • Customize FileMaker Pro to your needs and preferences

  • Share information with other people (coworkers, clients, and customers) and other programs

  • Understand and select the best security options

What could easily come across as dry and intimidating--things like relational theory, calculations, and scripting--are presented in a way that is interesting and intuitive to mainstream users. In no time, you'll be working more productively and efficiently using FileMaker Pro.

book cover
FileMaker Pro 8: The Missing Manual
By Geoff Coffey, Susan Prosser
Publisher: O'Reilly
Pub Date: September 2005
ISBN: 0-596-00579-2
Pages: 762

Table of Contents  | Index

   The Missing Credits
      About the Authors
      About the Creative Team
      The Missing Manual Series
      Why FileMaker Pro?
      What's New in FileMaker Pro 8
      The Very Basics
      About This Book
    Part I:  Introduction to FileMaker Pro
      Chapter 1.  Your First Database
      Section 1.1.  An Very Quick Database Tour
      Section 1.2.  Creating a New Database
      Section 1.3.  Opening and Closing Database Files
      Section 1.4.  Saving Your Databases
      Section 1.5.  Adding Records to Your Database
      Section 1.6.  Navigating Your Database
      Section 1.7.  Same Database, Multiple Windows
      Chapter 2.  Organizing and Editing Records
      Section 2.1.  Views
      Section 2.2.  Advanced Find Mode
      Section 2.3.  Changing Multiple Records
      Section 2.4.  Sorting Records
      Section 2.5.  Editing What's in Your Fields
      Section 2.6.  Paragraph Formatting
      Section 2.7.  Beyond Text: Container Fields
      Section 2.8.  Checking Spelling
      Section 2.9.  Printing and Preview Mode
      Chapter 3.  Building a New Database
      Section 3.1.  Tables and Fields
      Section 3.2.  Defining Fields
      Section 3.3.  Advanced Field Options
      Section 3.4.  Bringing It All Together
    Part II:  Layout Basics
      Chapter 4.  Layout Basics
      Section 4.1.  What Is a Layout?
      Section 4.2.  Switching Between Layouts
      Section 4.3.  What Makes a Layout
      Section 4.4.  Layout Mode
      Chapter 5.  Creating Layouts
      Section 5.1.  The Lowdown on Layouts
      Section 5.2.  Creating a Layout from Scratch
      Section 5.3.  Creating Layouts for Reports
      Chapter 6.  Advanced Layouts and Reports
      Section 6.1.  Setting up Field Controls
      Section 6.2.  Adding Field Controls to Layouts
      Section 6.3.  Field Behavior
      Section 6.4.  Tab Order
      Section 6.5.  Print-Related Layout Options
      Section 6.6.  Format the Number/Date/Time/Graphic
      Section 6.7.  Adding Buttons
      Section 6.8.  Tab Panels
      Section 6.9.  Reports and Summary Fields
    Part III:  Multiple Tables and Relationships
      Chapter 7.  Multiple Tables and Relationships
      Section 7.1.  Relational Databases Explained
      Section 7.2.  Modeling Your Database
      Section 7.3.  Creating a Relational Database
      Section 7.4.  Relational Databases
      Chapter 8.  Advanced Relationship Techniques
      Section 8.1.  Creating Related Records
      Section 8.2.  Table Occurrences
      Section 8.3.  Managing Data with Data Tunneling
      Section 8.4.  Building a Data Tunneling Interface
      Section 8.5.  Connecting Databases
      Section 8.6.  Lookups
      Section 8.7.  Advanced Relationships
    Part IV:  Calculations
      Chapter 9.  Introduction to Calculations
      Section 9.1.  Understanding Calculations
      Section 9.2.  The Structure of a Calculation
      Section 9.3.  Creating a Calculation Field
      Section 9.4.  Auto-Enter Calculations
      Section 9.5.  Validate Data Entry with a Calculation
      Section 9.6.  Replacing Data Using a Calculation
      Section 9.7.  Comments
      Chapter 10.  Calculations and Data Types
      Section 10.1.  Number Crunching Calculations
      Section 10.2.  Going Beyond Basic Calculations
      Section 10.3.  Text Parsing Calculations
      Section 10.4.  Date and Time Calculations
      Section 10.5.  Containers in Calculations
      Chapter 11.  Advanced Calculations
      Section 11.1.  Stored, Unstored, and Global Fields
      Section 11.2.  Logical Functions
      Section 11.3.  The Let Function and Variables
      Chapter 12.  Extending Calculations
      Section 12.1.  Custom Functions
      Section 12.2.  Plug-ins
    Part V:  Scripting
      Chapter 13.  Scripting Basics
      Section 13.1.  Your First Script
      Section 13.2.  The Importance of the Layout
      Section 13.3.  Running Scripts
      Section 13.4.  Branching and Looping in Scripts
      Chapter 14.  Script Steps
      Section 14.1.  Go to Layout
      Section 14.2.  Scripting for Fields
      Section 14.3.  Working with Records
      Section 14.4.  Finding Records
      Section 14.5.  Sorting Records
      Section 14.6.  Working with Windows
      Section 14.7.  Working with Files
      Section 14.8.  Printing
      Section 14.9.  Other Script Steps
      Chapter 15.  Advanced Scripting
      Section 15.1.  Commenting Scripts
      Section 15.2.  Asking and Telling the User
      Section 15.3.  Organizing Complex Scripts
      Section 15.4.  Handling Errors
      Section 15.5.  Putting a Complex Script Together
    Part VI:  Security and Integration
      Chapter 16.  Security
      Section 16.1.  How Security Works
      Section 16.2.  Privilege Sets
      Section 16.3.  Managing Accounts
      Section 16.4.  Extended Privileges
      Section 16.5.  Scripts and Security
      Chapter 17.  Exporting and Importing
      Section 17.1.  Exporting a File
      Section 17.2.  Export Formats
      Section 17.3.  Importing Data
      Section 17.4.  Import Data Sources
      Section 17.5.  Importing and Exporting in a Script
      Chapter 18.  Sharing Your Database
      Section 18.1.  FileMaker Network Sharing
      Section 18.2.  Sharing Over the Internet
      Section 18.3.  FileMaker Server
      Section 18.4.  Server Hardware
      Chapter 19.  Developer Utilities
      Section 19.1.  Script Debugger
      Section 19.2.  Disable Script Steps
      Section 19.3.  The Database Design Report
      Section 19.4.  Tooltips
      Section 19.5.  Copying Database Structure
      Section 19.6.  Custom Menus
      Section 19.7.  Developer Utilities
      Section 19.8.  File Maintenance
    Part VII:  Appendixes
      Appendix A.  Getting Help
      Section A.1.  Getting Help from FileMaker Itself
      Section A.2.  Getting Help from FileMaker, Inc.
      Section A.3.  Getting Help from the Community
      Appendix B.  FileMaker Error Codes