FileMaker Pro 8: The Missing Manual

ISBN: 0596005792
EAN: 2147483647

Year: 2004
Pages: 176

Authors: Geoff Coffey, Susan Prosser

BUY ON AMAZON

Part I: Introduction to FileMaker Pro

Your First Database

• Your First Database
• An Very Quick Database Tour
• Creating a New Database
• Opening and Closing Database Files
• Saving Your Databases
• Adding Records to Your Database
• Navigating Your Database
• Same Database, Multiple Windows

Organizing and Editing Records

• Organizing and Editing Records
• Views
• Advanced Find Mode
• Changing Multiple Records
• Sorting Records
• Editing Whats in Your Fields
• Paragraph Formatting
• Beyond Text: Container Fields
• Checking Spelling
• Printing and Preview Mode

Building a New Database

• Building a New Database
• Tables and Fields
• Defining Fields
• Advanced Field Options
• Bringing It All Together

Part II: Layout Basics

Layout Basics

• Layout Basics
• What Is a Layout?
• Switching Between Layouts
• What Makes a Layout
• Layout Mode

Creating Layouts

• Creating Layouts
• The Lowdown on Layouts
• Creating a Layout from Scratch
• Creating Layouts for Reports

Advanced Layouts and Reports

• Advanced Layouts and Reports
• Setting up Field Controls
• Adding Field Controls to Layouts
• Field Behavior
• Tab Order
• Print-Related Layout Options
• Format the Number/Date/Time/Graphic
• Adding Buttons
• Tab Panels
• Reports and Summary Fields

Part III: Multiple Tables and Relationships

Multiple Tables and Relationships

• Multiple Tables and Relationships
• Relational Databases Explained
• Modeling Your Database
• Creating a Relational Database
• Relational Databases

Advanced Relationship Techniques

• Advanced Relationship Techniques
• Creating Related Records
• Table Occurrences
• Managing Data with Data Tunneling
• Building a Data Tunneling Interface
• Connecting Databases
• Lookups
• Advanced Relationships

Part IV: Calculations

Introduction to Calculations

• Introduction to Calculations
• Understanding Calculations
• The Structure of a Calculation
• Creating a Calculation Field
• Auto-Enter Calculations
• Validate Data Entry with a Calculation
• Replacing Data Using a Calculation
• Comments

Calculations and Data Types

• Calculations and Data Types
• Number Crunching Calculations
• Going Beyond Basic Calculations
• Text Parsing Calculations
• Date and Time Calculations
• Containers in Calculations

Advanced Calculations

• Advanced Calculations
• Stored, Unstored, and Global Fields
• Logical Functions
• The Let Function and Variables

Extending Calculations

• Extending Calculations
• Custom Functions
• Plug-ins

Part V: Scripting

Scripting Basics

• Scripting Basics
• Your First Script
• The Importance of the Layout
• Running Scripts
• Branching and Looping in Scripts

Script Steps

• Script Steps
• Go to Layout
• Scripting for Fields
• Working with Records
• Finding Records
• Sorting Records
• Working with Windows
• Working with Files
• Printing
• Other Script Steps

Advanced Scripting

• Advanced Scripting
• Commenting Scripts
• Asking and Telling the User
• Organizing Complex Scripts
• Handling Errors
• Putting a Complex Script Together

Part VI: Security and Integration

Security

• Security
• How Security Works
• Privilege Sets
• Managing Accounts
• Extended Privileges
• Scripts and Security

Exporting and Importing

• Exporting and Importing
• Exporting a File
• Export Formats
• Importing Data
• Import Data Sources
• Importing and Exporting in a Script

Sharing Your Database

• Sharing Your Database
• FileMaker Network Sharing
• Sharing Over the Internet
• FileMaker Server
• Server Hardware

Developer Utilities

• Developer Utilities
• Script Debugger
• Disable Script Steps
• The Database Design Report
• Tooltips
• Copying Database Structure
• Custom Menus
• Developer Utilities
• File Maintenance

Part VII: Appendixes

• Appendix B. FileMaker Error Codes

Appendix A. Getting Help

• Appendix A. Getting Help
• A.1. Getting Help from FileMaker Itself
• A.2. Getting Help from FileMaker, Inc.
• A.3. Getting Help from the Community