Book 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.
Each chapter in this fully updated edition covers the latest timesaving features of FileMaker Pro 10, including saved finds and a redesigned toolbar that reveals information and features more clearly than ever. You'll learn how to import information from the new Bento consumer database (Mac only), write scripts to make your database even easier to use, and send email without leaving FileMaker.
With this book, you will:
- Get your first database running in minutes and perform basic tasks right away
- Catalog people, processes, and things with streamlined data entry and sorting tools
- Use your data to generate reports, correspondence, and other documents with ease
- Create, connect, and manage multiple tables and set up complex relationships that display just the data you need
- Crunch numbers, search text, or pin down dates and times with dozens of built-in formulas
- Outfit your database for the Web, and import and export data to other formats
You'll also get objective advice on which features are really useful, and which aren't. To make the most of this database, you need FileMaker Pro 10: The Missing Manual -- the book that should have been in the box.
Table of contents
- FileMaker Pro 10: The Missing Manual
- A Note Regarding Supplemental Files
- The Missing Credits
- Introduction
-
I. Getting Started with FileMaker
- 1. Working with a Database
-
2. Organizing and Editing Records
- Views
-
Advanced Find Techniques
- Modify Last Find
- Multiple Requests
- Finding by Omitting
- Constraining and Extending the Found Set
-
Refining Searches with Find Operators
- The wildcard (*)
- Less Than (<), Less Than or Equal To (≤), Greater Than (>), and Greater Than or Equal To (≥)
- Exact Match (=), Literal Text (” “), and Field Content Match (= =)
- Range (…)
- Duplicates (!)
- Today’s Date (//) and Invalid Date or Time (?)
- One Character (@), One Digit (#), and Zero or More Characters (*)
- Relaxed Search (~)
- Using the Find Pop-up Menu
- Editing What’s in Your Fields
- Changing Text Appearance
- Checking Spelling
- Printing and Preview Mode
- Beyond Text: Container Fields
- 3. Building a New Database
-
II. Layouts
- 4. Understanding Layouts
- 5. Building Basic Layouts
- 6. Advanced Layouts and Reports
-
III. Multiple Tables and Relationships
- 7. Adding Multiple Tables and Relationships
- 8. Advanced Relationship Techniques
-
IV. Calculations
-
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
- 10. More Calculations and Data Types
- 11. Advanced Calculations
- 12. Extending Calculations
-
9. Understanding Calculations
-
V. Scripting
- 13. Understanding Scripts
-
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
-
15. Advanced Scripting
- Commenting Scripts
- Communicating with Database Users
- Organizing Complex Scripts
- Handling Errors
- Putting a Complex Script Together
- Advanced Script Triggers
-
VI. Security and Integration
- 16. Adding Security
- 17. Sharing Data with Other Systems
- 18. Sharing Your Database
- 19. Applying Developer Utilities
- VII. Appendixes
- Index
- About the Authors
- Colophon
- Copyright
Product information
- Title: FileMaker Pro 10: The Missing Manual
- Author(s):
- Release date: January 2009
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596154233
You might also like
book
Being Geek
As a software engineer, you recognize at some point that there's much more to your career …
book
Lean Analytics
Whether you’re a startup founder trying to disrupt an industry or an entrepreneur trying to provoke …
book
Real World Instrumentation with Python
Learn how to develop your own applications to monitor or control instrumentation hardware. Whether you need …
book
Product Management in Practice
Product management has become a critical connective role for modern organizations, from small technology startups to …