FileMaker Pro 7 Bible -- About the Authors -- Credits -- Preface -- About This Book -- Whom This Book Is For -- How This Book Is Organized -- Conventions Used in This Book -- How to Use This Book -- Example Files -- Acknowledgments -- Contents at a Glance -- Contents -- Part I: The Fundamentals -- Chapter 1: What Is a Database? -- Paper Databases versus Computer Databases -- Flat-File and Relational Databases -- Introducing FileMaker Pro -- Getting "The Big Picture" -- Summary -- Chapter 2: FileMaker Pro Basic Operations -- Starting Up -- Quitting -- File-Handling Procedures -- Issuing Commands -- Using Tools and Palettes -- Using Toolbars -- Getting Help -- Summary -- Chapter 3: What's New in FileMaker Pro 7? -- The FileMaker Pro 7 Product Family -- Changes Introduced in FileMaker Pro 7 -- Changes Introduced in FileMaker Pro 6 -- Part II: Database Design Basics -- Chapter 4: Creating Your First Database -- Step 1: Create a New Database -- Step 2: Define Fields -- Step 3: Set Field Options -- Step 4: Design the Work Layout -- Step 5: Design the Home Layout -- Step 6: Create the Data Entry Buttons and Scripts -- Step 7: Design a Report Layout -- Step 8: Set Startup Actions -- Tips for Using the Database -- Summary -- Chapter 5: Defining Fields -- Setting Field Definitions -- Setting Field Options -- Modifying Field Definitions, Names, and Options -- Summary -- Chapter 6: Layouts -- Layout Basics -- Creating New Layouts -- Designing Your Own Layouts -- Formatting Fields and Other Objects -- Duplicating, Renaming, Reordering, and Deleting Layouts -- Summary -- Chapter 7: Setting Preferences -- Setting FileMaker Pro 7 Preferences -- Setting Document-Specific Options -- Summary -- Part III: Working with Databases -- Chapter 8: Working with Records -- Browse Mode Basics -- Data Entry and Editing -- Summary.

Chapter 9: Searching for and Selecting Records -- Find Mode Basics -- Finding Records -- More about Find Requests -- Matching Special Items -- Working with Found Records -- Summary -- Chapter 10: Sorting Records -- About Sorting -- Creating a Sort Order -- Modifying Sort Specifications -- Sorting Data in Portals -- Additional Sort Options -- Summary -- Chapter 11: Reports -- Report Design Essentials -- Modifying and Reusing Layouts -- Chapter 12: Using the Spelling Checker -- Setting Spell-Checking Options -- Specifying Your Dictionaries -- Checking Your Spelling -- Working with User Dictionaries -- Spelling Tips and Tricks -- Summary -- Chapter 13: Printing -- The Steps in Printing -- Effective Printing Tips -- Summary -- Part IV: Putting FileMaker Pro to Work -- Chapter 14: Calculations and Computations -- About Calculation Fields -- Creating a Calculation Field -- Using FileMaker Pro's Built-In Functions -- Validation by Calculation -- Calculation Logic -- Summary -- Chapter 15: Automating FileMaker Pro -- Using ScriptMaker -- Script Step Reference -- Attaching a Script to a Button -- Advanced Scripting Procedures -- Summary -- Chapter 16: Exchanging Data -- Moving Data between Programs -- Importing Data from Other Sources -- Exporting Data -- Moving Data Using Drag and Drop -- Exchanging Data between Macs and PCs -- Exchanging Data with Microsoft Office -- Using Excel Data in FileMaker Pro -- Summary -- Chapter 17: Creating and Using Templates -- The FileMaker Pro 7 Templates -- Installing a Template -- Reinstalling a Fresh Copy of a Template -- Saving a Database as a Template -- Working with a New Template -- Summary -- Part V: Mastering FileMaker Pro -- Chapter 18: Linking Tables: Relationships and Lookups -- Lookups versus Relationships -- Going Relational with FileMaker Pro -- Working with Lookups.

Additional Relationship/Lookup Options and Requirements -- Summary -- Chapter 19: Using FileMaker Pro in Workgroups -- Running FileMaker Pro on a Network -- Protecting Databases and Setting Privileges -- Summary -- Chapter 20: Web Publishing with FileMaker Pro -- Publishing Methods and Views -- Instant Web Publishing -- Publishing Static Pages on the Web -- Summary -- Chapter 21: Advanced Database Connectivity with XML and ODBC/JDBC -- Exporting and Importing XML -- FileMaker and ODBC -- Moral of the Chapter -- Summary -- Chapter 22: Expanding FileMaker's Capabilities Using Plug-Ins -- Plug-in Licensing and Use -- Installing the Troi Plug-Ins -- Plug-In Examples -- More Plug-Ins -- Summary -- Part VI: Developing Databases for Others to Use -- Chapter 23: Designing Databases for Others -- Simplify the Interface by Using Menus -- Creating a Navigation Menu -- Providing Instant Access via Buttons and Scripts -- Consider Screen Real Estate -- Protecting a Template -- Creating Help Systems for Your Databases -- Using FileMaker Developer -- Summary -- Chapter 24: Debugging Scripts -- Introducing the Script Debugger -- Using the Script Debugger -- Summary -- Chapter 25: Generating Database Reports -- Specifying a Database Design Report -- Summary -- Chapter 26: Creating Custom Database Solutions -- Working with Custom Functions -- Using the File Maintenance Command -- Using the Developer Utilities -- Summary -- Part VII: Appendixes -- Appendix A: Macintosh Keyboard Shortcuts -- Appendix B: Windows Keyboard Shortcuts -- Appendix C: FileMaker Pro Function Reference -- Aggregate (Statistical) Functions -- Date Functions -- Design Functions -- External Functions -- Financial Functions -- Get Function -- Logical Functions -- Numeric Functions -- Repeating Functions -- Summary Functions -- Text Functions -- Text Formatting Functions -- Time Functions.

Timestamp Functions -- Trigonometric Functions -- Appendix D: Glossary -- Appendix E: Resources -- Technical Support and General Help -- Custom Programming and Vertical Applications -- Design Tips and Programming Tricks -- FileMaker Internet Mailing Lists -- Magazines: An Additional Source for Tips -- More Internet Resources -- Appendix F: About the CD -- System Requirements -- Using the CD -- What's on the CD -- Troubleshooting -- Index.