Book description
Refocused and completely rewritten with the needs of business users and FileMaker Pro developers in mind, FileMaker Pro 9 Bible shows you how to design an industrial-strength database, make it intuitive, and automate it with scripts and programming. From the fundamentals to data modeling to writing no-fail code, you'll find the clear, step-by-step procedures, solid techniques, and detailed explanations you need to master this powerful software and build the right solutions for your needs.
Table of contents
- Copyright
- About the Authors
- Credits
- Acknowledgments
- Preface
-
I. The Fundamentals
- 1. Databases: The What, Why, and How
- 2. Putting FileMaker Pro in Perspective
- 3. Getting Acquainted with FileMaker
-
4. What's New in FileMaker 9
- 4.1. The FileMaker Quick Start Screen
- 4.2. The Help Menu
- 4.3. Learn More Links on Critical Dialogs
- 4.4. Scheduled Software Update Notification
- 4.5. New Calculation Functions
- 4.6. Conditional Formatting
- 4.7. Append to PDF
- 4.8. The Send E-Mail Link for Database Sharing
- 4.9. Script Grouping and Editing Tools
- 4.10. Automatic Resizing of Layout Objects
- 4.11. Enhanced Tab Control
- 4.12. Web Viewer Feature Enhancements
- 4.13. Field-Specific Enabling of Visual Spell-Checking
- 4.14. Multiple Levels of Text Undo and Redo in Fields and ScriptMaker
- 4.15. Additional Toolbar Controls
- 4.16. Additional Avery Label Formats
- 4.17. Enhanced External SQL Data Source Support
- 4.18. Supplemental Fields for ESS Tables
- 4.19. FileMaker Pro 9 Advanced
-
II. Introduction to Database Design
- 5. Creating a Database
-
6. The Interface: Layout Mode
- 6.1. Initial Layouts
- 6.2. The Importance of Visual Structure
- 6.3. Different Kinds of Layout Objects
- 6.4. FileMaker as a Graphical Environment
- 6.5. Interacting with Layout Objects
- 6.6. The Tab Control and Its Uses
- 6.7. Displaying Related Data
- 6.8. The Magic of Buttons
- 6.9. The Web Viewer: Inviting in the World
- 6.10. Reports and Data Output
-
7. The Structure: The Manage Database Dialog
- 7.1. Working with Tables
- 7.2. Specifying Fields
-
7.3. Basic Calculations
- 7.3.1. Creating a Calculation field
- 7.3.2. Defining a calculation formula
- 7.3.3. Entering literal text
- 7.3.4. Referencing fields
- 7.3.5. Understanding calculation functions and their syntax
- 7.3.6. The Count( ) function
-
7.3.7. Doing some simple calculations
- 7.3.7.1. Number of days an item is overdue
- 7.3.7.2. Calculating initials from a person's name
- 7.3.7.3. Compound interest at a known rate over a given period
- 7.3.7.4. Current quarter of the calendar year
- 7.3.7.5. Changing ampersands to "and" in a block of text
- 7.3.7.6. Record navigation text (record n of nn)
- 7.4. The Relationships Graph
- 7.5. Working with External SQL Data Sources
- 7.6. The Concept of Data Relationships
- 8. The Processes: ScriptMaker
-
III. Beyond the Basics
- 9. The FileMaker Power User
-
10. Building Advanced Interfaces
- 10.1. Developing for Mac and Windows Users
- 10.2. Using Dynamic Screen Elements
- 10.3. Working with Sub-Summary Parts and Part Controls
- 10.4. Designing for Print
- 10.5. Using Multiple Windows and Views
- 10.6. Employing Custom Dialogs as an Interface Tool
- 10.7. Looking at Anchors and Resizable Layout Objects
- 10.8. Implementing Shortcut Navigation
- 10.9. Building Depth and Dimensionality
- 10.10. Working with Tab Controls
- 10.11. Recognizing the Flexibility of Portals
- 10.12. Using Advanced Web Viewer Techniques
- 10.13. Progress Bars and Native Charting Techniques
- 10.14. Using Interface Elements
- 10.15. Handling User Preferences
-
11. Data Modeling in FileMaker
- 11.1. Background in Relational Theory
- 11.2. FileMaker Relationships Graph Symbols
- 11.3. Relationship Operators
- 11.4. Note regarding theta joins in relational algebra
- 11.5. Alternative Relationship Techniques
- 11.6. Working with Data Arrays
- 11.7. Graph Techniques — Spiders, Squids, and Anchor-Buoy
- 11.8. Documenting the Database Structure
- 11.9. The Concept of Layers
- 11.10. File Architecture versus Data Structure
- 11.11. Separation and External SQL Sources
- 11.12. Implementing Separation in an Existing Solution
- 11.13. Deployment Considerations
-
12. Calculation Wizardry
- 12.1. Compound Calculation Expressions
- 12.2. Order of Operations
- 12.3. Boolean Operations
- 12.4. Variables—Calculation, Script, and Global
- 12.5. Text Processing and Parsing Functions
- 12.6. Text Formatting Operations
- 12.7. Dates, Times, and Timestamps
- 12.8. Summary Data
- 12.9. Lists and Arrays
- 12.10. Layers of Abstraction
- 12.11. Unstored Calculations
- 12.12. Calculation Fields versus Auto-Enter Calculations
- 12.13. The user over-ride capability
- 12.14. Global Calculations
- 12.15. Environment and Metadata
- 12.16. Calculations Using Custom Functions
- 12.17. Your Code's Documentation
-
13. Scripting in Depth
- 13.1. Scripting the Control of Objects and Interface
- 13.2. Trapping for Errors
- 13.3. Scripts and Access Privileges
- 13.4. Automating the Automation
- 13.5. Harnessing the Power of Parameters, Results, and Variables
- 13.6. Dynamic and Indirect Controls in ScriptMaker
- 13.7. Using Nonlinear Logic
- 13.8. Modular Script Code
- 13.9. Scripted Window Management
- 13.10. Moving and resizing windows
- 13.11. Freezing and refreshing the screen
- 13.12. Scripting Data Import and Export
- 13.13. Pivoting Data between Tables
- 13.14. Going over Some Practical Examples
-
IV. Integrity and Security
-
14. In Control with FileMaker Security
- 14.1. Concepts of Security
- 14.2. The Privilege Set
- 14.3. Granular Security
- 14.4. User Authentication
- 14.5. Scripted Account Management
- 14.6. Creating a Custom Logout Option
- 14.7. How Much Security Is Enough?
- 14.8. The Importance of Physical File Security
- 14.9. Security in Deployment: FileMaker Server
- 15. Maintaining Referential Integrity
-
16. Making FileMaker Systems Fail-Safe
- 16.1. Expecting the Unexpected
- 16.2. A Comprehensive Approach to Error Trapping
-
16.3. Opening Remote Files
- 16.3.1. Peer-to-peer hosting
- 16.3.2. File sharing risks
- 16.3.3. Network spaghetti
- 16.3.4. Opener files
- 16.3.5. Sending an e-mail link
- 16.3.6. Temporary Edit Interface Techniques
- 16.3.7. The data viewer concept
- 16.3.8. The legitimate purpose of record locking
- 16.3.9. Creating double-blind entry systems
- 16.4. Field Masking, Filtering, and Error Rejection
- 16.5. Built-In Logging Capabilities
- 16.6. Script Logging
- 16.7. Capturing User Edits in Detail
- 16.8. Managing the Accumulation of Log Data
- 16.9. Implementing Roll-Back Capabilities
- 16.10. Alternative Logging Approaches
- 17. Maintaining and Restoring Data
-
14. In Control with FileMaker Security
-
V. Raising the Bar
-
18. FileMaker Pro Advanced Features
- 18.1. Script Debugger
- 18.2. Data Viewer
- 18.3. Database Design Report
- 18.4. File Maintenance
- 18.5. Defining Tooltips
- 18.6. Creating Custom Menus
- 18.7. Custom Functions
- 18.8. Custom Functions and Recursion
- 18.9. Creating Runtime Applications
- 19. Efficient Code, Efficient Solutions
-
20. Extending FileMaker's Capabilities
- 20.1. External Scripting Calls
- 20.2. Rendering HTML and JavaScript
- 20.3. Web Viewer Widgets
- 20.4. FileMaker Plug-Ins
- 20.5. Web Deployment Options
- 20.6. Finding Third-Party Tools
-
18. FileMaker Pro Advanced Features
- VI. Appendixes
Product information
- Title: FileMaker® Pro 9 Bible
- Author(s):
- Release date: March 2008
- Publisher(s): Wiley
- ISBN: 9780470177433
You might also like
audiobook
Transformed
Help transform your business and innovate like the world's top tech companies! Transformed: Moving to the …
book
Algorithmen und Datenstrukturen, 6th Edition
Algorithmen und Datenstrukturen sind Grundbausteine eines jeden Informatikstudiums. Das Buch behandelt diese Thematik in Verbindung mit …
book
Analog Design and Simulation Using OrCAD Capture and PSpice, 2nd Edition
New to this edition: Updated to using OrCAD Release 17.2 and its new features; Coverage of …
book
Building Secure Software: How to Avoid Security Problems the Right Way
Most organizations have a firewall, antivirus software, and intrusion detection systems, all of which are intended …