Filemaker Pro 5/5.5 Advanced for Windows and Macintosh,9780201787269

Filemaker Pro 5/5.5 Advanced for Windows and Macintosh

by ;
ISBN13: 9780201787269
ISBN10: 0201787261
Format: Paperback
Pub. Date: 2001-12-01
Publisher(s): Peachpit Pr
Upgraded Edition: Click here!
List Price: $24.99

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $24.72

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

You use FileMaker every day--you know your way around the basics. But howcan you be sure you're getting the most out of this database heavyweight?Take your skills to the next level with FileMaker Pro 5/5.5 Pro Advancedfor Windows and Macintosh: Visual QuickPro Guide, the quickest, easiestway to put FileMaker's power to work for you.

FileMaker Pro 5/5.5 Advanced: VQP doesn't waste your time withwordy explanations. This visual, task-based guide is loaded withscreenshots and clear, concise explanations of key database publishingtechniques, including working with records and files, designing databases,printing and networking, Web publishing, and more. The book covers topicsyou can put to immediate use, whether you have version 5 or version 5.5:data reports and relationships, conditional script steps, scripttroubleshooting, FileMaker and third-party software, and security issuesraised by multiuser files.

Author Biography

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.

Table of Contents

About FileMaker Pro 5.0p. 1
FileMaker 5.0: Highlights of New Featuresp. 2
FileMaker 5.0 Editionsp. 4
About Upgrading to FileMaker 5.0p. 4
Using This Bookp. 5
Organizing Data Efficientlyp. 7
About Relational Databasesp. 8
Gathering Informationp. 9
Creating a Field Listp. 11
Developing a Data Structure Strategyp. 12
Creating a Data Structure Chartp. 15
Field Design Tacticsp. 16
Implementing Relationshipsp. 19
Testing Your Databasep. 20
Layout Enhancementsp. 23
Usability, Legibility, and Logical Groupingp. 24
Cross-Platform Issuesp. 26
Using Graphic Textp. 29
Formatting Elements as Buttonsp. 31
Reusing Graphicsp. 33
Entering Data in a Standard Layoutp. 34
Creating and Formatting Value Listsp. 36
Validating Formats with Value Listsp. 37
Working with Conditional Value Listsp. 39
Using Calculated Field Labelsp. 41
Creating Field Masksp. 43
Copying Layoutsp. 48
Calculation Fieldsp. 51
Merging Fields Using Calculationsp. 52
Formatting Labels or Envelopesp. 57
Formatting Form Letter Modulesp. 60
Augmenting a Form Letterp. 65
Creating Data Reportsp. 71
Using Search Operatorsp. 72
Creating an "Inverted" Searchp. 74
Creating Summary Layout Partsp. 75
Using Counts and Averagesp. 80
Creating Running Totalsp. 82
Creating Sub-summary Reportsp. 83
Sorting Data for Sub-summary Reportsp. 85
Exporting Summary Datap. 86
Creating Relationshipsp. 89
About Relationshipsp. 90
Creating a Match Field in a Master Filep. 92
Lookup vs. Related Fieldsp. 94
Using a Match Field to Choose a Related Recordp. 97
Using Calculated Match Fieldsp. 98
Field Formatting with a Calculated Match Fieldp. 100
About Repeating vs. Related Fieldsp. 103
About Portalsp. 104
Sorting Data in Portalsp. 107
Summarizing Related Datap. 108
About Self-Relationshipsp. 110
Using a Portal for Navigationp. 112
Searching for Self-Relationship Datap. 113
Creating a Lookup with a Self-Relationshipp. 114
Creating Simple Scriptsp. 117
Planning a Simple Scriptp. 118
Storing Settings Before Scriptingp. 119
Using ScriptMakerp. 122
Creating a Basic Scriptp. 127
Creating Sub-scriptsp. 129
Combining Sub-scriptsp. 132
Retaining Multiple Settings in a Scriptp. 134
Using Sub-scripts for Multiple Export Settingsp. 137
Adding Comments to a Scriptp. 139
Using External Scriptsp. 141
Working with Conditional Script Stepsp. 145
About Conditional Stepsp. 146
Using the If Commandp. 147
Using If with Elsep. 149
About Status Functionsp. 153
Using Status Functions with If Stepsp. 154
Using Loop in a Scriptp. 159
Using Counters to Control Loopsp. 162
Controlling Scripts with User Inputp. 165
Customizing Documents with If Stepsp. 168
Extending the Interface with Scriptsp. 179
Making a Find Layout with a Scriptp. 180
Creating Script Buttonsp. 184
Deleting Records in a Related Filep. 186
Creating a Main Menu Layoutp. 188
Linking to the Main Menup. 190
Running Scripts from Fieldsp. 191
Creating Interactive Error Messagesp. 197
Script Troubleshootingp. 201
Testing Finished Scriptsp. 202
Fixing Typical Errorsp. 204
Creating an Error Trap Scriptp. 209
Debugging Scriptsp. 218
Printing Scriptsp. 220
Changing and Adapting Scriptsp. 221
FileMaker and Other Programsp. 223
Using Scripts to Send Emailp. 224
Using Scripts to Send Bulk Emailp. 227
Using a Script to Open URLsp. 231
Exporting Data to Static HTML Tablesp. 233
Exporting Formatted Textp. 234
Using Excel Data in FileMakerp. 238
Working with ODBCp. 240
Sharing Databases Using ODBCp. 243
Using AppleScript with FileMaker Scriptingp. 246
Data Importing and Repairingp. 249
Migrating to FileMaker 5.0p. 250
Importing Data from Other Sourcesp. 252
Cleaning Up Text Data Before Importingp. 256
Finding and Eliminating Duplicatesp. 258
Importing Data without Duplicationsp. 261
Troubleshooting Problem Datap. 264
Replacing Inconsistent Formattingp. 265
Separating Parts of Datap. 267
Multi-User Files on a Networkp. 273
Setting Network Protocolsp. 274
Setting Up Multi-User Filesp. 276
Hiding Related Filesp. 277
Creating an Opening Scriptp. 278
Accessing Databases Over the Internetp. 282
Testing Scripts for Access Problemsp. 284
Using FileMaker Pro Serverp. 287
Hosting Files on FileMaker Serverp. 288
Optimizing Server Settingsp. 290
Setting Up a Usage Logp. 293
Managing Server Remotelyp. 294
Web Publishingp. 297
Instant Web Publishingp. 298
Configuring Databases for Web Accessp. 299
Choosing a Layout Stylep. 301
Tracking Activity and Accessp. 303
Accessing a File with a Browserp. 304
Enabling Remote Administrationp. 305
Restricting Database Accessp. 306
Creating a Custom Home Pagep. 307
Creating a Guest Bookp. 309
Testing Your Web Databasep. 311
About Custom Web Publishingp. 312
Setting Up Custom Web Publishingp. 313
Creating a Template Format Filep. 314
Prompting User Input with CDMLp. 316
Providing Visitor Feedbackp. 318
Searching for Data with CDMLp. 320
Editing Data with CDMLp. 322
Browsing Recordsp. 326
Using the Web Security Databasep. 329
XML and JDBCp. 331
FM Developer's Editionp. 332
FileMaker 5.5 Applications and OS Additionsp. 333
FileMaker Pro 5.5: Highlights of New Featuresp. 334
FileMaker Pro Server 5.5: Highlights of New Featuresp. 338
FileMaker DE 5.5: Highlights of New Featuresp. 340
Using FileMaker 5.5's New Featuresp. 341
Validating by Number of Charactersp. 342
Using GetFieldp. 344
Updating Auto-Entry Serial Numbersp. 350
Disabling Toolbarsp. 352
Creating Interactive Buttonsp. 353
Restricting Access Privilegesp. 355
Changing Password Accessp. 358
Importing and Connectingp. 359
Import from Excel Rangesp. 360
About Improved Script Importingp. 362
Importing with Scriptsp. 363
Setting the Next Auto-Entry Serial Numberp. 365
Using Relative Pathsp. 373
Using FileMaker Mobilep. 374
About FM5.5's ODBC Functionsp. 378
Storing SQL Commands in Fieldsp. 379
Using Calculations to Build Complex Queriesp. 383
Creating Dynamic SQL Queriesp. 387
Web Publishing with FileMaker 5.5p. 391
Suppressing Built-In Navigation in IWPp. 392
Creating Web Layoutsp. 396
Creating a Web-Based Find Scriptp. 400
Switching Layouts with a Scriptp. 403
Web Display Considerationsp. 406
FileMaker and Third-Party Softwarep. 407
FileMaker Resourcesp. 411
Indexp. 413
Table of Contents provided by Syndetics. All Rights Reserved.

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.