Book description
FileMaker Pro 9: The Missing Manual is the clear, thorough and accessible guide to the latest version of this popular desktop database program. FileMaker Pro lets you do almost anything with the information you give it. You can print corporate reports, plan your retirement, or run a small country -- if you know what you're doing. This book helps non-technical folks like you get in, get your database built, and get the results you need. Pronto.
The new edition gives novices and experienced users the scoop on versions 8.5 and 9. It offers complete coverage of timesaving new features such as the Quick Start screen that lets you open or a create a database in a snap, the handy "save to" buttons for making Excel documents or PDFs, the multiple level Undo and Redo commands let you step backwards through your typing tasks, and much more. With FileMaker Pro 9: The Missing Manual, you can:
- 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.
- Learn to use layout tools to organize the appearance of your database.
- Use your data to generate reports, correspondence and other documents with ease.
- Create, connect, and manage multiple tables and set up complex relationships that show you just the data you need.
- Crunch numbers, search text, or pin down dates and times with dozens of built-in formulas.
- Automate repetitive tasks with FileMaker Pro 9's easy-to-learn scripting language.
- Protect your database with passwords and set up privileges to determine what others can do once they gain entry.
- Outfit your database for the Web and import and export data to other formats.
Publisher resources
Table of contents
- FileMaker Pro 9: The Missing Manual
- A Note Regarding Supplemental Files
- Introduction
-
I. Introduction to FileMaker Pro
- 1. Your First Database
-
2. Organizing and Editing Records
- 2.1. Views
-
2.2. Advanced Find Mode
- 2.2.1. Finding by Omitting
- 2.2.2. Constraining and Extending the Found Set
-
2.2.3. Refining Searches with Find Symbols
- 2.2.3.1. The wildcard (*)
- 2.2.3.2. Less Than (<), Less Than or Equal To (<), Greater Than (>), and Greater Than or Equal To (>)
- 2.2.3.3. Exact Match (=), Literal Text (“”), and Field Content Match (= =)
- 2.2.3.4. Range (…)
- 2.2.3.5. Duplicates (!)
- 2.2.3.6. Today’s Date (//) and Invalid Date or Time (?)
- 2.2.3.7. One Character (@), One Digit (#), and Zero or More Characters (*)
- 2.2.3.8. Relaxed Search (~)
- 2.2.4. Refining a Found Set with Omit Commands
- 2.3. Changing Multiple Records
- 2.4. Sorting Records
- 2.5. Editing What’s in Your Fields
- 2.6. Paragraph Formatting
- 2.7. Beyond Text: Container Fields
- 2.8. Checking Spelling
- 2.9. Printing and Preview Mode
- 3. Building a New Database
-
II. Layout Basics
-
4. Layout Basics
- 4.1. What Is a Layout?
- 4.2. Switching Between Layouts
- 4.3. What Makes a Layout
-
4.4. Layout Mode
- 4.4.1. The Status Area
-
4.4.2. View Options
- 4.4.2.1. Go to Layout
- 4.4.2.2. Page Margins
- 4.4.2.3. Graphic Rulers
- 4.4.2.4. Text Ruler
- 4.4.2.5. Ruler Lines
- 4.4.2.6. T-Squares
- 4.4.2.7. Object Info
- 4.4.2.8. Buttons
- 4.4.2.9. Sample Data
- 4.4.2.10. Text Boundaries
- 4.4.2.11. Field Boundaries
- 4.4.2.12. Sliding Objects
- 4.4.2.13. Non-Printing Objects
- 4.4.2.14. Tooltips
- 4.4.2.15. Toolbars
- 4.4.2.16. Status area
- 4.4.2.17. Zoom in and out
- 4.4.3. Layout Setup
- 4.4.4. Layout Tools
- 4.4.5. Working with Parts
- 4.4.6. Adding and Editing Text
- 4.4.7. Formatting Fields
- 4.4.8. Field Controls
- 4.4.9. Laying Out the Layout
- 4.4.10. Adding a Dividing Line Between Layout Parts
- 4.4.11. Finishing Touches
- 4.4.12. Autoresize
- 4.4.13. Wrapping up
-
5. Creating Layouts
- 5.1. The Lowdown on Layouts
- 5.2. Creating a Layout from Scratch
- 5.3. Creating Layouts for Reports
-
6. Advanced Layouts and Reports
- 6.1. Value Lists
- 6.2. Advanced Field Controls
- 6.3. Field Behavior
- 6.4. Conditional Formatting
- 6.5. Print-related Layout Options
- 6.6. Format the Number/Date/Time/Graphic
-
6.7. Adding Buttons
- 6.7.1. Creating Buttons with the Button Tool
- 6.7.2. Turning an Existing Layout Object into a Button
- 6.7.3. Making a Button Not a Button
-
6.7.4. Button Actions
- 6.7.4.1. Go to Layout
- 6.7.4.2. Go to Record/Request/Page
- 6.7.4.3. Go to Field
- 6.7.4.4. Go to Next Field and Go to Previous Field
- 6.7.4.5. Enter Browse Mode, Enter Find Mode, and Enter Preview Mode
- 6.7.4.6. Editing actions
- 6.7.4.7. Field actions
- 6.7.4.8. Record actions
- 6.7.4.9. Found Set actions
- 6.7.4.10. Window actions
- 6.7.4.11. Print actions
- 6.7.4.12. Open actions
- 6.7.4.13. Exiting FileMaker
- 6.8. Tab Order
- 6.9. Web Viewer Controls
- 6.10. Tab Controls
- 6.11. Reports and Summary Fields
-
4. Layout Basics
-
III. Multiple Tables and Relationships
-
7. Multiple Tables and Relationships
- 7.1. Relational Databases Explained
- 7.2. Modeling Your Database
- 7.3. Creating a Relational Database
- 7.4. Relational Databases
- 8. Advanced Relationship Techniques
-
7. Multiple Tables and Relationships
-
IV. Introduction to Calculations
-
9. Introduction to Calculations
- 9.1. Understanding Calculations
-
9.2. The Structure of a Calculation
- 9.2.1. Fields
- 9.2.2. Constants
- 9.2.3. Operators
-
9.2.4. Functions
- 9.2.4.1. Text functions
- 9.2.4.2. Text formatting functions
- 9.2.4.3. Number functions
- 9.2.4.4. Date functions
- 9.2.4.5. Time functions
- 9.2.4.6. Timestamp functions
- 9.2.4.7. Aggregate functions
- 9.2.4.8. Summary functions
- 9.2.4.9. Repeating functions
- 9.2.4.10. Financial functions
- 9.2.4.11. Trigonometric functions
- 9.2.4.12. Logical functions
- 9.2.4.13. Get functions
- 9.2.4.14. Design functions
- 9.2.4.15. Custom functions
- 9.2.4.16. External functions
- 9.2.5. Expressions
- 9.3. Creating a Calculation Field
- 9.4. Auto-Enter Calculations
- 9.5. Validate Data Entry with a Calculation
- 9.6. Replacing Data Using a Calculation
- 9.7. Comments
-
10. Calculations and Data Types
- 10.1. Number Crunching Calculations
- 10.2. Going Beyond Basic Calculations
- 10.3. Text Parsing Calculations
- 10.4. Date and Time Calculations
- 10.5. Aggregate Calculations
- 10.6. Containers in Calculations
- 11. Advanced Calculations
- 12. Extending Calculations
-
9. Introduction to Calculations
-
V. Scripting
- 13. Scripting Basics
-
14. Script Steps
- 14.1. Go to Layout
- 14.2. Scripting for Fields
- 14.3. Working with Records
- 14.4. Finding Records
- 14.5. Sorting Records
- 14.6. Working with Windows
- 14.7. Working with Files
- 14.8. Printing
- 14.9. Other Script Steps
-
15. Advanced Scripting
- 15.1. Commenting Scripts
- 15.2. Asking and Telling the User
- 15.3. Organizing Complex Scripts
- 15.4. Handling Errors
- 15.5. Putting a Complex Script Together
-
VI. Security and Integration
-
16. Security
- 16.1. How Security Works
- 16.2. Privilege Sets
- 16.3. Managing Accounts
- 16.4. Extended Privileges
- 16.5. Scripts and Security
-
17. Sharing Data with Other Systems
- 17.1. Sharing Your Data with Others
- 17.2. External SQL Sources
- 17.3. Exporting Data
- 17.4. Importing Data
- 17.5. Import Data Sources
- 17.6. Importing and Exporting in a Script
- 18. Sharing Your Database
-
19. Developer Utilities
- 19.1. Copying and Pasting Database Structure
- 19.2. Script Debugger
- 19.3. The Data Viewer
- 19.4. Disable Script Steps
- 19.5. The Database Design Report
- 19.6. Tooltips
- 19.7. Custom Menus
-
19.8. Developer Utilities
-
19.8.1. Using the Developer Utilities
- 19.8.1.1. Renaming files
- 19.8.1.2. Create Runtime Solution application(s)
- 19.8.1.3. Remove admin access from files permanently
- 19.8.1.4. Enable Kiosk mode for non-admin accounts
- 19.8.1.5. Databases must have a FileMaker file extension
- 19.8.1.6. Create error log for any processing errors
- 19.8.1.7. Loading and saving settings
- 19.8.2. Delivering a Runtime Solution
-
19.8.1. Using the Developer Utilities
- 19.9. File Maintenance
-
16. Security
- VII. Appendixes
- Index
- About the Authors
- Colophon
- Copyright
Product information
- Title: FileMaker Pro 9: The Missing Manual
- Author(s):
- Release date: August 2007
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596514136
You might also like
book
FileMaker Pro 8: The Missing Manual
Used by millions worldwide, FileMaker Pro is an award-winning database program for managing people, projects, images, …
book
FileMaker Pro 14: The Missing Manual
You don’t need a technical background to build powerful databases with FileMaker Pro 14. This crystal-clear, …
book
FileMaker Pro 10: The Missing Manual
The FileMaker Pro 10 desktop database lets you do almost anything with the information you give …
book
FileMaker Pro 11: The Missing Manual
This hands-on, friendly guide shows you how to harness FileMaker's power to make your information work …