Description
The FileMaker Pro 10 desktop database lets you do almost anything with the information you give it -- especially with this book as your guide. Clear, thorough, and accessible, FileMaker Pro 10: The Missing Manual helps you get in, build your database, and get the results you need, whether you're running a business, pursuing a hobby, or planning your retirement. It's the ideal guide for non-technical and experienced folks alike.
Full Description
Table of Contents
-
Getting Started with FileMaker
-
Chapter 1 Working with a Database
- A Very Quick Database Tour
- Opening and Closing Database Files
- Adding Records to Your Database
- Navigating Your Database
- Finding Records
- Sorting Records
- Same Database, Different Views
- Saving Your Database
-
Chapter 2 Organizing and Editing Records
- Views
- Advanced Find Techniques
- Editing What's in Your Fields
- Changing Text Appearance
- Checking Spelling
- Printing and Preview Mode
- Beyond Text: Container Fields
-
Chapter 3 Building a New Database
- Tables and Fields
- Defining Fields
- Advanced Field Options
-
-
Layouts
-
Chapter 4 Understanding Layouts
- What Is a Layout?
- The Layout Bar
- What Makes a Layout
- Customizing a Layout
- Determining Tab Order
-
Chapter 5 Building Basic Layouts
- The Lowdown on Layout Types
- Creating a Layout from Scratch
- Conditional Formatting
- Web Viewer Objects
- Adding Tab Controls
- Creating Layouts for Printing
-
Chapter 6 Advanced Layouts and Reports
- Value Lists
- Advanced Field Controls
- Format the Number/Date/Time/Graphic
- Adding Buttons
- Summary Fields and Sub-Summary Parts
-
-
Multiple Tables and Relationships
-
Chapter 7 Adding Multiple Tables and Relationships
- Relational Databases Explained
- Modeling Your Database
- Creating a Relational Database
- Relational Databases
-
Chapter 8 Advanced Relationship Techniques
- Creating Related Records
- Table Occurrences
- Managing Data with Data Tunneling
- Building a Data Tunneling Interface
- Connecting Database Files
- Lookups
- Advanced Relationships
-
-
Calculations
-
Chapter 9 Understanding 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
-
Chapter 10 More Calculations and Data Types
- Number Crunching Calculations
- Going Beyond Basic Calculations
- Text Calculations
- Date and Time Calculations
- Containers in Calculations
-
Chapter 11 Advanced Calculations
- Conditional Formatting Formulas
- Using Storage Options
- Logical Functions
- The Let( ) Function and Variables
-
Chapter 12 Extending Calculations
- Custom Functions
- Plug-Ins
-
-
Scripting
-
Chapter 13 Understanding Scripts
- Your First Script
- The Importance of the Layout
- Running Scripts
- Organizing Your Scripts
- Branching and Looping in Scripts
- Script Triggers
-
Chapter 14 Exploring 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
-
Chapter 15 Advanced Scripting
- Commenting Scripts
- Communicating with Database Users
- Organizing Complex Scripts
- Handling Errors
- Putting a Complex Script Together
- Advanced Script Triggers
-
-
Security and Integration
-
Chapter 16 Adding Security
- How Security Works
- Privilege Sets
- Managing Accounts
- Extended Privileges
- Scripts and Security
-
Chapter 17 Sharing Data with Other Systems
- Sharing Your Data with Others
- External SQL Sources
- Exporting Data
- Importing Data
- Import Data Sources
- Importing and Exporting in a Script
-
Chapter 18 Sharing Your Database
- FileMaker Network Sharing
- Sharing over the Internet
- FileMaker Server
- Server Hardware
-
Chapter 19 Applying Developer Utilities
- Copying and Pasting Database Structure
- Script Debugger
- The Data Viewer
- Disable Script Steps
- The Database Design Report
- Tooltips
- Custom Menus
- Developer Utilities
-
-
Appendixes
-
Appendix Getting Help
- Getting Help from FileMaker Itself
- Getting Help from FileMaker, Inc.
- Getting Help from the Community
-
Appendix FileMaker Error Codes
-
-
Colophon
Product Details
- Title:
- FileMaker Pro 10: The Missing Manual
- By:
- Susan Prosser, Geoff Coffey
- Publisher:
- O'Reilly Media / Pogue Press
- Formats:
-
- Ebook
- Safari Books Online
- Print Release:
- January 2009
- Ebook Release:
- January 2009
- Pages:
- 832
- Print ISBN:
- 978-0-596-15423-3
- | ISBN 10:
- 0-596-15423-2
- Ebook ISBN:
- 978-0-596-15738-8
- | ISBN 10:
- 0-596-15738-X
Customer Reviews
