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
Designing Data-Intensive Applications
Data is at the center of many challenges in system design today. Difficult issues need to …
book
Hands-On Machine Learning with Scikit-Learn, Keras, and TensorFlow, 3rd Edition
Through a recent series of breakthroughs, deep learning has boosted the entire field of machine learning. …
book
Learn FileMaker Pro 19: The Comprehensive Guide to Building Custom Databases
Discover how easy it is to create multi-user, cross-platform custom solutions with FileMaker Pro, the relational …
audiobook
The Design of Everyday Things
First, businesses discovered quality as a key competitive edge; next came science. Now, Donald A. Norman, …