FileMaker Pro 5/5.5 Advanced for Windows and Macintosh
Visual QuickPro Guide
Book
Paperback/Softback
500 pages
978-0-201-78726-9 (ISBN)
Description
FileMaker Pro is the top-selling database program for Macintosh and a strong second for Windows. Version 5 features a new interface that complements the look and feel of Microsoft Office, as well as improved conversion of MS Excel spreadsheets into FileMaker databases. Built-in HTTP support lets authorized users search edit, delete, and update FileMaker Pro records for up to 10 users, while improved Web security lets you limit access to your database and ActiveX facilitates the automation of tasks for Windows users. While FileMaker's ease of use may make it seem deceptively simple, its sophistication, power, and flexibility is largely unparalleled. FileMaker Pro 5/5.5 for Windows and Macintosh: Visual QuickPro Guide is designed for intermediate to advanced database users and developers who want to break through to the next level of FileMaker. This Visual QuickPro Guide takes you from working with records and files to creating and designing databases, printing and networking, Web publishing and more.
More details
Series
Language
English
Place of publication
Berkeley
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Illustrations
illustrations
ISBN-13
978-0-201-78726-9 (9780201787269)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Other editions
New editions
Cynthia L. Baron | Daniel Peck
FileMaker Pro 6 Advanced for Windows and Macintosh
Visual QuickPro Guide
Book
01/2003
Peachpit Press Publications
€23.51
Article exhausted; check for reprint
Previous edition
Cynthia L. Baron | Daniel Peck
FileMaker Pro 5 Advanced for Windows and Macintosh
Visual QuickPro Guide
Book
11/2000
Peachpit Press Publications
€23.51
Article exhausted; check for reprint
Persons
Cynthia L. Baron is the author of Creating a Digital Portfolio and the co-author of Windows for Mac Users and Web Animation for Dummies. A designer and typographer, Cynthia teaches computer-related design courses at Northeastern University in Boston. @AUTHBIO= Dan Peck is a FileMaker database designer and consultant.
Content
1. About FileMaker Pro 5.0.
FileMaker 5.0: Highlights of New Features. FileMaker 5.0 Editions. About Upgrading to FileMaker 5.0. Using This Book.
2.Organizing Data Efficiently.
About Relational Databases. Gathering Information. Creating a Field List. Developing a Data Structure Strategy. Creating a Data Structure Chart. Field Design Tactics. Implementing Relationships. Testing Your Database.
3. Layout Enhancements.
Usability, Legibility, and Logical Grouping. Cross-Platform Issues. Using Graphic Text. Formatting Elements as Buttons. Reusing Graphics. Entering Data in a Standard Layout. Creating and Formatting Value Lists. Validating Formats with Value Lists. Working with Conditional Value Lists. Using Calculated Field Labels. Creating Field Masks. Copying Layouts.
4. Calculation Fields.
Merging Fields Using Calculations. Formatting Labels or Envelopes. Formatting Form Letter Modules. Augmenting a Form Letter.
5. Creating Data Reports.
Using Search Operators. Creating an "Inverted" Search. Creating Summary Layout Parts. Using Counts and Averages. Creating Running Totals. Creating Sub-summary Reports. Sorting Data for Sub-summary Reports. Exporting Summary Data.
6. Creating Relationships.
About Relationships. Creating a Match Field in a Master File. Lookup vs. Related Fields. Using a Match Field to Choose a Related Record. Using Calculated Match Fields. Field Formatting with a Calculated Match Field. About Repeating vs. Related Fields. About Portals. Sorting Data in Portals. Summarizing Related Data. About Self-Relationships. Using a Portal for Navigation. Searching for Self-Relationship Data. Creating a Lookup with a Self-Relationship.
7. Creating Simple Scripts.
Planning a Simple Script. Storing Settings Before Scripting. Using ScriptMaker. Creating a Basic Script. Creating Sub-scripts. Combining Sub-scripts. Retaining Multiple Settings in a Script. Using Sub-scripts for Multiple Export Settings. Adding Comments to a Script. Using External Scripts.
8. Working with Conditional Script Steps.
About Conditional Steps. Using the If Command. Using If with Else. About Status Functions. Using Status Functions with If Steps. Using Loop in a Script. Using Counters to Control Loops. Controlling Scripts with User Input. Customizing Documents with If Steps.
9. Extending the Interface with Scripts.
Making a Find Layout with a Script. Creating Script Buttons. Deleting Records in a Related File. Creating a Main Menu Layout. Linking to the Main Menu. Running Scripts from Fields. Creating Interactive Error Messages.
10. Script Troubleshooting.
Testing Finished Scripts. Fixing Typical Errors. Creating an Error Trap Script. Debugging Scripts. Printing Scripts. Changing and Adapting Scripts.
11. FileMaker and Other Programs.
Using Scripts to Send Email. Using Scripts to Send Bulk Email. Using a Script to Open URLs. Exporting Data to Static HTML Tables. Exporting Formatted Text. Using Excel Data in FileMaker. Working with ODBC. Sharing Databases Using ODBC. Using AppleScript with FileMaker Scripting.
12. Data Importing and Repairing.
Migrating to FileMaker 5.0. Importing Data from Other Sources. Cleaning Up Text Data Before Importing. Finding and Eliminating Duplicates. Importing Data without Duplications. Troubleshooting Problem Data. Replacing Inconsistent Formatting. Separating Parts of Data.
13. Multi-User Files on a Network.
Setting Network Protocols. Setting Up Multi-User Files. Hiding Related Files. Creating an Opening Script. Accessing Databases Over the Internet. Testing Scripts for Access Problems.
14. Using FileMaker Pro Server.
Hosting Files on FileMaker Server. Optimizing Server Settings. Setting Up a Usage Log. Managing Server Remotely.
15. Web Publishing.
Instant Web Publishing. Configuring Databases for Web Access. Choosing a Layout Style. Tracking Activity and Access. Accessing a File with a Browser. Enabling Remote Administration. Restricting Database Access. Creating a Custom Home Page. Creating a Guest Book. Testing Your Web Database. About Custom Web Publishing. Setting Up Custom Web Publishing. Creating a Template Format File. Prompting User Input with CDML. Providing Visitor Feedback. Searching for Data with CDML. Editing Data with CDML. Browsing Records. Using the Web Security Database. XML and JDBC. FM Developer's Edition.
16. FileMaker 5.5 Applications and OS Additions.
FileMaker Pro 5.5: Highlights of New Features. FileMaker Pro Server 5.5: Highlights of New Features. FileMaker DE 5.5: Highlights of New Features.
17. Using FileMaker 5.5 's New Features.
Validating by Number of Characters. Using GetField. Updating Auto-Entry Serial Numbers. Disabling Toolbars. Creating Interactive Buttons. Restricting Access Privileges. Changing Password Access.
18. Importing and Connecting.
Import from Excel Ranges. About Improved Script Importing. Importing with Scripts. Setting the Next Auto-Entry Serial Number. Using Relative Paths. Using FileMaker Mobile. About FM5.5's ODBC Functions. Storing SQL Commands in Fields. Using Calculations to Build Complex Queries. Creating Dynamic SQL Queries.
19. Web Publishing with FileMaker 5.5.
Suppressing Built-In Navigation in IWP. Creating Web Layouts. Creating a Web-Based Find Script. Switching Layouts with a Script. Web Display Considerations.
Appendix A: FileMaker and Third-Party Software.
Appendix B: FileMaker Resources.
Index.
FileMaker 5.0: Highlights of New Features. FileMaker 5.0 Editions. About Upgrading to FileMaker 5.0. Using This Book.
2.Organizing Data Efficiently.
About Relational Databases. Gathering Information. Creating a Field List. Developing a Data Structure Strategy. Creating a Data Structure Chart. Field Design Tactics. Implementing Relationships. Testing Your Database.
3. Layout Enhancements.
Usability, Legibility, and Logical Grouping. Cross-Platform Issues. Using Graphic Text. Formatting Elements as Buttons. Reusing Graphics. Entering Data in a Standard Layout. Creating and Formatting Value Lists. Validating Formats with Value Lists. Working with Conditional Value Lists. Using Calculated Field Labels. Creating Field Masks. Copying Layouts.
4. Calculation Fields.
Merging Fields Using Calculations. Formatting Labels or Envelopes. Formatting Form Letter Modules. Augmenting a Form Letter.
5. Creating Data Reports.
Using Search Operators. Creating an "Inverted" Search. Creating Summary Layout Parts. Using Counts and Averages. Creating Running Totals. Creating Sub-summary Reports. Sorting Data for Sub-summary Reports. Exporting Summary Data.
6. Creating Relationships.
About Relationships. Creating a Match Field in a Master File. Lookup vs. Related Fields. Using a Match Field to Choose a Related Record. Using Calculated Match Fields. Field Formatting with a Calculated Match Field. About Repeating vs. Related Fields. About Portals. Sorting Data in Portals. Summarizing Related Data. About Self-Relationships. Using a Portal for Navigation. Searching for Self-Relationship Data. Creating a Lookup with a Self-Relationship.
7. Creating Simple Scripts.
Planning a Simple Script. Storing Settings Before Scripting. Using ScriptMaker. Creating a Basic Script. Creating Sub-scripts. Combining Sub-scripts. Retaining Multiple Settings in a Script. Using Sub-scripts for Multiple Export Settings. Adding Comments to a Script. Using External Scripts.
8. Working with Conditional Script Steps.
About Conditional Steps. Using the If Command. Using If with Else. About Status Functions. Using Status Functions with If Steps. Using Loop in a Script. Using Counters to Control Loops. Controlling Scripts with User Input. Customizing Documents with If Steps.
9. Extending the Interface with Scripts.
Making a Find Layout with a Script. Creating Script Buttons. Deleting Records in a Related File. Creating a Main Menu Layout. Linking to the Main Menu. Running Scripts from Fields. Creating Interactive Error Messages.
10. Script Troubleshooting.
Testing Finished Scripts. Fixing Typical Errors. Creating an Error Trap Script. Debugging Scripts. Printing Scripts. Changing and Adapting Scripts.
11. FileMaker and Other Programs.
Using Scripts to Send Email. Using Scripts to Send Bulk Email. Using a Script to Open URLs. Exporting Data to Static HTML Tables. Exporting Formatted Text. Using Excel Data in FileMaker. Working with ODBC. Sharing Databases Using ODBC. Using AppleScript with FileMaker Scripting.
12. Data Importing and Repairing.
Migrating to FileMaker 5.0. Importing Data from Other Sources. Cleaning Up Text Data Before Importing. Finding and Eliminating Duplicates. Importing Data without Duplications. Troubleshooting Problem Data. Replacing Inconsistent Formatting. Separating Parts of Data.
13. Multi-User Files on a Network.
Setting Network Protocols. Setting Up Multi-User Files. Hiding Related Files. Creating an Opening Script. Accessing Databases Over the Internet. Testing Scripts for Access Problems.
14. Using FileMaker Pro Server.
Hosting Files on FileMaker Server. Optimizing Server Settings. Setting Up a Usage Log. Managing Server Remotely.
15. Web Publishing.
Instant Web Publishing. Configuring Databases for Web Access. Choosing a Layout Style. Tracking Activity and Access. Accessing a File with a Browser. Enabling Remote Administration. Restricting Database Access. Creating a Custom Home Page. Creating a Guest Book. Testing Your Web Database. About Custom Web Publishing. Setting Up Custom Web Publishing. Creating a Template Format File. Prompting User Input with CDML. Providing Visitor Feedback. Searching for Data with CDML. Editing Data with CDML. Browsing Records. Using the Web Security Database. XML and JDBC. FM Developer's Edition.
16. FileMaker 5.5 Applications and OS Additions.
FileMaker Pro 5.5: Highlights of New Features. FileMaker Pro Server 5.5: Highlights of New Features. FileMaker DE 5.5: Highlights of New Features.
17. Using FileMaker 5.5 's New Features.
Validating by Number of Characters. Using GetField. Updating Auto-Entry Serial Numbers. Disabling Toolbars. Creating Interactive Buttons. Restricting Access Privileges. Changing Password Access.
18. Importing and Connecting.
Import from Excel Ranges. About Improved Script Importing. Importing with Scripts. Setting the Next Auto-Entry Serial Number. Using Relative Paths. Using FileMaker Mobile. About FM5.5's ODBC Functions. Storing SQL Commands in Fields. Using Calculations to Build Complex Queries. Creating Dynamic SQL Queries.
19. Web Publishing with FileMaker 5.5.
Suppressing Built-In Navigation in IWP. Creating Web Layouts. Creating a Web-Based Find Script. Switching Layouts with a Script. Web Display Considerations.
Appendix A: FileMaker and Third-Party Software.
Appendix B: FileMaker Resources.
Index.