Record:   Prev Next
Author Schwartz, Steven A
Title FileMaker Pro 7 Bible
Imprint New York : John Wiley & Sons, Incorporated, 2004
©2004
book jacket
Edition 1st ed
Descript 1 online resource (936 pages)
text txt rdacontent
computer c rdamedia
online resource cr rdacarrier
Series Bible Ser
Bible Ser
Note Intro -- 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
Updated to cover the latest program version, this comprehensive guide helps users make the most of FileMaker Pro, the sophisticated workgroup database application with nine million registered users Offers complete step-by-step guidance on FileMaker Pro features and tasks, covering both the Mac and Windows versions Features expanded coverage of ODBC, JDBC, and XML connectivity and includes a new chapter on the developer tools used to create more complex databases Other topics covered include calculations and computations, data exchange, creating and using templates, linking databases, using FileMaker in workgroups, Web publishing, plug-ins, and advanced database connectivity
Description based on publisher supplied metadata and other sources
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2020. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries
Link Print version: Schwartz, Steven A. FileMaker Pro 7 Bible New York : John Wiley & Sons, Incorporated,c2004 9780764543470
Subject FileMaker (Computer file);Database management
Electronic books
Alt Author Cohen, Dennis R
Record:   Prev Next