Book description
You don’t have to be a techie to use FileMaker Pro 12, but you do need to know what you’re doing. With this crystal-clear guide, you’ll learn how to create a powerful database that lets you do almost anything with your data. Whether you’re running a business, printing a catalog, or planning a wedding, you’ll learn how to customize your database and put it to work.
The important stuff you need to know:
- Get started. Tour FileMaker Pro’s features and create your first database in minutes.
- Catalog your data. View, sort, and shape information in dozens of ways.
- Create professional documents. Publish reports, invoices, and other documents with ease.
- Harness processing power. Use calculations and scripts to crunch numbers, search text, and automate tasks.
- Add visual power and clarity. Create colorful charts to illustrate and summarize your data.
- Think like a developer. Dive into the high-level features of FileMaker Pro Advanced.
Publisher resources
Table of contents
- FileMaker Pro 12: The Missing Manual
- A Note Regarding Supplemental Files
- The Missing Credits
- Introduction
-
1. Getting Started with FileMaker
- 1. Working with a Database
-
2. Organizing and Editing Records
- Views
-
Advanced Find Techniques
- Multiple Requests
- Finding by Omitting
- Refining a Found Set with Omit Commands
- Constraining and Extending the Found Set
-
Refining Searches with Find Operators
- Zero or More Characters, A.K.A. “Wildcard” (*)
- Less Than (<), Less Than or Equal (≤), Greater Than (>), and Greater Than or Equal (≥)
- Match Whole Word (=), Match Phrase (“”), and Match Entire Field (= =)
- Range (…)
- Find Duplicate Values (!)
- Today’s Date (//) and Invalid Date or Time (?)
- Any One Character (@), Any One Digit (#), and Zero or More Characters (*)
- Relaxed Search (~)
- Modify Last Find
- Using the Find Pop-Up Menu
- Editing What’s in Your Fields
- Changing Text Appearance
- Checking Spelling
- Preview Mode and Printing
-
2. Building Your First Database
- 3. Creating a Custom Database
- 4. Adding Power to Your Database
-
3. Thinking Like a Developer
- 5. Creating and Managing a Relational Database
- 6. Field Options
- 7. Layout Mechanics
- 8. Layout Design
-
9. Understanding Calculations
-
Understanding Calculations
- Creating a Calculation
- The Structure of a Calculation
- Using Fields in Calculations
- Using Constants in Calculations
- Using Operators in Calculations
-
Functions
- Text Functions
- Text Formatting Functions
- Number Functions
- Date Functions
- Time Functions
- Timestamp Functions
- Container Functions
- Aggregate Functions
- Summary Functions
- Repeating Functions
- Financial Functions
- Trigonometric Functions
- Logical Functions
- Get Functions
- Design Functions
- Custom Functions
- External Functions
- Expressions
- Using a Related Field in a Calculation
- Understanding the Specify Calculation Dialog Box
- Auto-Enter Calculations
- Validate Data Entry with a Calculation
- Commenting in Calculations
-
Understanding Calculations
- 10. More Calculations and Data Types
- 11. Understanding Scripts
-
12. Exploring Script Steps
- Go to Layout
- Go to Object
- Scripting for Fields
- Working with Records
- Finding Records
- Sorting Records
- Working with Windows
- Working with Files
- Printing
- Other Script Steps
-
4. Becoming a Power Developer
- 13. Applying Developer Utilities
- 14. Advanced Relationship Techniques
- 15. Reporting and Analysis
- 16. Advanced Calculations
-
17. Advanced Scripting
- Commenting Scripts
- Importing Scripts
- Communicating with Database Users
- Creating Modular Scripts
- Script Parameters
- Script Variables
- Handling Errors
- Advanced Script Triggers
-
Putting a Complex Script Together
- Planning the Script
- Considering Exceptions
- Creating Subscripts
-
Finishing the Subscripts
- The Find Unbilled Activity Subscript
- Copying and Editing Existing Script Steps
- Adding a Script Parameter to a Perform Script Step
- Checking a Subscript’s Result
- Finishing the Create Invoice Record Subscript
- Finishing the Process Timeslips Subscript
- Creating a Looping Script
- The Process Expenses Subscript
- Testing Scripts
-
5. Security and Integration
- 18. Sharing Your Database
- 19. Adding Security
- 20. Sharing Data with Other Systems
-
6. Appendixes
-
A. Getting Help
- Getting Help from FileMaker Pro
- FileMaker’s Installed Extras
- Getting Help from the Community
- B. File Conversion
- C. Using the Insert Commands with Container Fields
- D. FileMaker Error Codes
-
A. Getting Help
- Index
- About the Authors
- Copyright
Product information
- Title: FileMaker Pro 12: The Missing Manual
- Author(s):
- Release date: July 2012
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781449316280
You might also like
book
FileMaker Pro 10: The Missing Manual
The FileMaker Pro 10 desktop database lets you do almost anything with the information you give …
book
Office X for Macintosh: The Missing Manual
Mac OS X, Apple's super-advanced, Unix-based operating system, offers every desirable system-software feature known to humans. …
book
Excel 2003: The Missing Manual
Whether you are an Excel neophyte, a sophisticate who knows the program inside out, or an …
book
Adobe® Photoshop® CS2 Studio Techniques
If you're ready to go from blindly following step-by-step instructions to "Aha, I finally GET Photoshop!" …