FileMaker Pro 7 Advanced for Windows and Macintosh Visual QuickPro Guide

by ;
Edition: 1st
Format: Paperback
Pub. Date: 2005-04-26
Publisher(s): Peachpit Press
List Price: $29.99

Rent Book

Select for Price
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

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

For database software, FileMaker Pro has always been almost shockingly easy to use. However, somewhere along the way it also became incredibly powerful-so much so, in fact, that's it's no longer about just creating small-scale relational databases. If you're ready to move beyond the basics and take advantage of FileMaker Pro 7's advanced features, this task-based guide provides the key. By applying the same visual approach, step-by-step instructions, and concise explanations employed by the popular Visual QuickStart Guides to complex topics like creating and managing links between fields in multiple tables and employing the advanced security features to define which fields are editable by different user categories, this handy guide represents the most efficient way for experienced FileMaker users to take their skills to the next level. By the end of the volume, you'll be creating custom databases, using advanced querying features, and managing huge volumes of complex data (text, video, images, audio, PDFs, and more) with FileMaker Pro 7!

Author Biography

Cynthia Baron is a designer and typographer who teaches computer-related design courses at Northeastern University in Boston. Daniel Peck is a FileMaker developer and computer consultant specializing in the graphic arts industry. Together, Cynthia and Daniel have written a number of books, including the Digital Photography Field Guide and the three previous editions of this volume.

Table of Contents

About FileMaker Pro 7
1(8)
FileMaker 7: Highlights of New Features
2(5)
FileMaker Editions and Their Functions
7(1)
Using This Book
7(1)
Windows and Macintosh
8(1)
Organizing Data Efficiently
9(16)
About Relational Databases
10(1)
Gathering Information
11(2)
Creating a Field List
13(1)
Developing a Data Structure Strategy
14(3)
Creating a Data Structure Chart
17(1)
Field Design Tactics
18(3)
Implementing Relationships
21(3)
Testing Your Database
24(1)
Layout Enhancements
25(34)
Usability, Legibility, and Logical Grouping
26(2)
Cross-Platform Issues
28(3)
Using Format Painter
31(2)
Using Graphics as Layout Elements
33(3)
Formatting Elements as Buttons
36(2)
Entering Data in a Standard Layout
38(2)
Moving Through Fields
40(3)
Cleaning Up a Layout for Printing
43(2)
Creating and Formatting Value Lists
45(1)
Validating Formats with Value Lists
46(2)
Working with Conditional Value Lists
48(3)
Using Calculated Field Labels
51(2)
Creating Field Masks
53(4)
Validating by Number of Characters
57(2)
Calculation Fields
59(26)
Combining Fields Using Calculations
60(4)
Formatting Labels or Envelopes
64(2)
Formatting Form-Letter Modules
66(4)
Augmenting a Form Letter
70(4)
Using GetField
74(5)
Styling Text with Calculations
79(2)
Updating Auto-Entry Serial Numbers
81(4)
Creating Data Reports
85(24)
Extending a Found Set
86(2)
Using Search Operators
88(2)
Creating an ``Inverted'' Search
90(1)
Creating Summary Layout Parts
91(5)
Using Counts and Averages
96(2)
Creating a Page Count
98(4)
Creating Running Totals
102(1)
Creating Sub-Summary Reports
103(2)
Sorting Data for Sub-Summary Reports
105(2)
Exporting Summary Data
107(2)
Creating Relationships
109(32)
About Relationships
110(1)
Relationship Terminology in FileMaker Pro 7
111(2)
Defining a Match Field
113(2)
External File References
115(2)
Creating a Match Field in the Current Table
117(2)
Lookup vs. Related Fields
119(3)
Using a Match Field to Choose a Related Record
122(1)
Repeating vs. Related Fields
123(1)
Creating Portals
124(2)
Creating Related Data with Portals
126(2)
Sorting Data in Portals
128(1)
Summarizing Related Data
129(2)
About Self-Relationships
131(2)
Using a Portal for Navigation
133(1)
Searching for Self-Relationship Data
134(1)
Creating a Lookup with a Self-Relationship
135(3)
Using Multi-criteria Relationships
138(3)
Creating Simple Scripts
141(26)
Planning a Simple Script
142(1)
Using ScriptMaker
143(2)
Creating a Basic Script
145(3)
Editing Scripts
148(1)
Managing Scripts
149(2)
Creating Sub-Scripts
151(2)
Combining Sub-Scripts
153(2)
Extending or Constraining Found Sets in a Script
155(2)
Exporting Records in a Script
157(3)
Adding Comments to a Script
160(2)
Using External Scripts
162(5)
Working with Conditional Script Steps
167(40)
About Conditional Steps
168(1)
Using the If Command
169(2)
Using If with Else
171(4)
About Get Functions
175(1)
Using Get Functions with If Steps
176(4)
Using Loop in a Script
180(2)
Using Counters to Control Loops
182(3)
Controlling Scripts with User Input
185(3)
Creating Custom Dialog Boxes
188(7)
Customizing Documents with If Steps
195(12)
Extending the Interface with Scripts
207(26)
Making a Find Layout with a Script
208(3)
Creating Script Buttons
211(2)
Creating Interactive Buttons
213(1)
Deleting Records in a Related File
214(2)
Creating a Main Menu Layout
216(2)
Linking to the Main Menu
218(1)
Running Scripts from Fields
219(5)
Creating Interactive Error Messages
224(4)
Disabling Toolbars
228(1)
Using Script Parameters for Multipurpose Scripts
229(4)
Script Troubleshooting
233(20)
Testing Finished Scripts
234(1)
Fixing Typical Errors
235(5)
Debugging Scripts
240(2)
Creating an Error Trap Script
242(9)
Importing Scripts
251(2)
FileMaker and Other Programs
253(28)
Using Scripts to Send Email
254(3)
Using Scripts to Send Bulk Email
257(5)
Using a Script to Open URLs
262(2)
Exporting Data to Static HTML Tables
264(1)
Exporting Formatted Text
265(5)
Using Excel Data in FileMaker
270(2)
Import from Excel Ranges
272(2)
Using AppleScript with FileMaker Scripting
274(2)
Exporting Field Contents
276(4)
Copying the Contents of Records
280(1)
Importing Data
281(36)
Importing Data from Text Sources
282(5)
Batch-Importing
287(2)
Batch-Importing from a Digital Camera (Mac OS X Only)
289(3)
Importing with Scripts
292(2)
Setting the Next Auto-Entry Serial Number
294(9)
About FileMaker Mobile
303(1)
Setting Up or Upgrading FileMaker Mobile
303(4)
Synchronizing from Mobile to Pro
307(2)
About XML
309(1)
Exporting from FileMaker with XML
310(3)
Importing into FileMaker with XML
313(2)
FileMaker, XML, and the Web
315(2)
ODBC/JDBC Import and Export
317(22)
About FileMaker's ODBC/JDBC Functions
318(1)
Sharing FileMaker Data Using ODBC in Windows
319(4)
Using Windows to Access ODBC Data
323(1)
Using a Mac to Access ODBC Data
324(2)
About Importing ODBC Data
326(1)
Storing SQL Commands in Scripts
327(7)
Creating Dynamic SQL Queries
334(5)
Data Importing and Repairing
339(20)
Cleaning Up Text Data Before Importing
340(2)
Finding Duplicates
342(3)
Importing Data Without Duplications
345(5)
Troubleshooting Problem Data
350(1)
Replacing Inconsistent Formatting
351(3)
Separating Parts of Data
354(5)
Migrating to Version 7
359(18)
FileMaker Editions
360(1)
Pre-Conversion Issues
361(2)
Cleaning Up a Database Before Conversion
363(3)
Converting a Simple Database
366(2)
Consolidating Multiple Related Files
368(4)
Cleaning Up After Conversion
372(2)
Sorting Case-Sensitive Data
374(1)
Security Settings for Converted Files
375(2)
Multiuser Files on a Network
377(18)
Setting Up Multiuser Files
378(1)
Hiding Related Files
379(1)
Creating an Opening Script
380(3)
About Security Settings
383(1)
Creating a User Account
384(2)
Restricting Access with Privilege Sets
386(4)
Setting Access Privileges by Password
390(2)
Changing Password Access
392(1)
Accessing Databases over the Internet
393(2)
Instant Web Publishing
395(28)
About IWP
396(1)
Converting Pre-v.7 Web Databases
396(1)
Configuring Databases for Web Access
397(1)
Accessing a Database with a Browser
398(1)
Managing Database Access
399(3)
Limiting Web User Options
402(2)
Setting an Initial Layout
404(2)
Linking to IWP Databases
406(1)
Tracking Activity and Access
407(1)
Disconnecting Inactive Users
408(1)
Adapting Scripts for Web Users
409(6)
Suppressing the Built-In IWP Interface
415(1)
Creating Web Layouts
416(2)
Creating a Web-Based Find Script
418(2)
Web Display Considerations
420(1)
Testing Your Web Database
421(1)
About Custom Web Publishing
422(1)
Appendix A: FileMaker and Third-Party Software 423(4)
Appendix B: FileMaker Resources 427(2)
Index 429

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.