Cover image for FileMaker Pro 5 for Windows and Macintosh
FileMaker Pro 5 for Windows and Macintosh
Hester, Nolan.
Personal Author:
Publication Information:
Berkeley, CA : Peachpit Press, [2000]

Physical Description:
x, 334 pages : illustrations ; 23 cm.
General Note:
Coverage includes: Microsoft Windows 95/98/NT4, and Mac OC 7.6.1 or later.

Includes index.
Subject Term:
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.9.D3 H4892 2000 Adult Non-Fiction Central Closed Stacks

On Order



FileMaker is a popular, flexible, and powerful tool that makes people more productive and saves them hours of grunt work. So is Peachpits FileMaker Pro 5 for Windows and Macintosh: Visual QuickStart Guide. Whether youre new to FileMaker, upgrading to version 5, or a Web developer looking for a simple way to serve databases, this book will have you up and running in no time. In the tradition of Peachpits other Visual QuickStart Guides, FileMaker Pro 5: VQS is loaded with screenshots and clear, concise explanations of critical database publishing tasks. Start with basics like working with records and files, and move on to more advanced tasks such as creating and designing databases. Or, use the handy tabbed format to page straight to the specific topics that interest you, such as printing and networking or Web publishing with FileMaker. Platform: MAC WIN

Author Notes

Nolan Hester wrote the previous edition of this book, FileMaker Pro 4 for Windows and Macintosh: Visual QuickStart Guide ; as well as FrontPage 2000 for Windows: Visual QuickStart Guide and DeBabelizer: Visual QuickStart Guide . A former development and acquisitions editor at Peachpit Press, he also managed the launch of its award-wining Web site. He currently works as a freelance writer, editor, and Web consultant.

Table of Contents

Part I Getting Started
Chapter 1 Using FileMaker Pro5p. 3
Why FileMaker?p. 4
What's New in FileMaker 5?p. 5
Using this Bookp. 8
One program, one book for Windows and Macintoshp. 9
Chapter 2 Database Basicsp. 11
Content vs. Formp. 13
Anatomy of a Databasep. 14
Chapter 3 FileMaker Basicsp. 17
FileMaker's Screen and Modesp. 17
FileMaker's Menusp. 22
FileMaker's Toolbarsp. 29
Opening, Closing, and Saving Filesp. 32
Part II Working with Records and Files
Chapter 4 Viewing Recordsp. 37
Opening a Filep. 38
Viewing Multiple or Single Recordsp. 40
Moving from Record to Recordp. 41
Moving within a Recordp. 44
Chapter 5 Finding and Sorting Recordsp. 45
Finding Recordsp. 46
Doing a Simple Searchp. 48
Doing Multiple Criteria Searchesp. 50
Refining Searchesp. 51
Modifying Find Requestsp. 53
Adding a New Requestp. 54
Duplicating and Changing a Requestp. 55
Deleting a Requestp. 56
Reverting Requestsp. 57
Omitting Recordsp. 58
Deleting Recordsp. 61
Sorting Recordsp. 63
Running Multiple Sortsp. 65
Setting Sort Ordersp. 67
Chapter 6 Using Spell Check and Dictionariesp. 69
Checking Spellingp. 70
Creating a User Dictionaryp. 71
Selecting or Switching Dictionariesp. 72
Editing a User Dictionaryp. 73
Importing or Exporting a Text Filep. 74
Chapter 7 Converting Filesp. 75
Converting Earlier FileMaker versionsp. 76
Importing Data into FileMakerp. 77
Importing Data into a New Databasep. 78
Importing Data into an Existing Databasep. 80
Importing from a FileMaker 5 Databasep. 82
Exporting FileMaker Datap. 83
Recovering Damaged Filesp. 86
Part III Creating and Designing Databases
Chapter 8 Planning Databasesp. 89
How about a SlowStart?p. 90
Follow the Paperp. 91
You Must Remember Thisp. 92
Chapter 9 Defining Fieldsp. 95
Choosing a Field Typep. 96
Defining and Changing Fieldsp. 98
Setting Field Entry Optionsp. 100
Auto Enter Optionsp. 102
Validation Optionsp. 104
Storage Options (Indexing)p. 106
Using Value Listsp. 107
Formatting Value List Fieldsp. 110
Using Repeating Fieldsp. 112
Formatting Repeating Fieldsp. 113
Understanding Formulasp. 114
Using Predefined Formulasp. 118
Using Calculation and Summary Fieldsp. 119
Editing Formulasp. 121
Displaying and Repeating Calculationsp. 122
Storing Calculation Resultsp. 123
Defining Summary Fieldsp. 124
Chapter 10 Creating Layoutsp. 125
Choosing a Layout Typep. 126
Working with Layoutsp. 128
Creating New Layoutsp. 129
Renaming and Deleting Layoutsp. 131
Duplicating Layoutsp. 132
Choosing a Layout Viewp. 132
Reordering Layoutsp. 133
Adding and Removing Layoutsp. 134
Changing the Layout Setupp. 135
Creating Label Layoutsp. 136
Creating Envelope Layoutsp. 138
Creating a Return Addressp. 139
Creating Form Letter Layoutsp. 140
Using Variable Fields in Layoutsp. 142
Working with Partsp. 144
Adding Layout Partsp. 146
Deleting, Reordering, and Resizing Partsp. 147
Changing a Part's Type and Optionsp. 148
Working with Fields in Layoutsp. 150
Adding and Deleting Fields in Layoutsp. 151
Resizing Fields in Layoutsp. 152
Adding Scroll Bars to Fieldsp. 153
Setting the Field Tab Orderp. 154
Chapter 11 Working with Objects in Layoutsp. 155
Moving Objects within Layoutsp. 157
Copying and Deleting Objectsp. 158
Grouping Objectsp. 159
Ungrouping, Locking, and Unlocking Objectsp. 160
Changing the Object Stacking Orderp. 161
Rotating Objectsp. 162
Aligning Objectsp. 163
Using Layout Guidesp. 164
Using Layout Rulersp. 165
Using T-Squares and Object Gridsp. 166
Using the Size Palettep. 167
Changing Ruler and Grid Unitsp. 168
Chapter 12 Formatting and Graphics in Layoutsp. 169
Working with Textp. 170
Selecting Textp. 171
Setting Format Defaultsp. 172
Formatting Fields or Objectsp. 175
Setting Multiple Text Attributesp. 175
Setting Text Tabsp. 176
Setting Fonts, Text Sizes, and Stylesp. 177
Setting Text Alignment and Line Spacingp. 178
Setting Text Colorsp. 179
Formatting Numbersp. 180
Formatting Date Fieldsp. 181
Formatting Time Fieldsp. 182
Formatting Graphic Fieldsp. 183
Working with Graphicsp. 184
Drawing Objectsp. 186
Selecting and Moving Objectsp. 187
Deselecting and Resizing Objectsp. 188
Changing Fill Colors, Patterns, and Effectsp. 189
Changing Linesp. 190
Changing Borders, Fills, and Baselinesp. 191
Chapter 13 Using Templates and Scriptsp. 193
Working with Templatesp. 194
Working with Scriptsp. 198
Preparing to Create a Scriptp. 200
Defining Scriptsp. 202
Changing Scriptsp. 205
Copying Scriptsp. 206
Importing Scriptsp. 207
Deleting Scriptsp. 208
Reordering, Changing Script Shortcutsp. 209
Defining Buttons for Scriptsp. 210
Setting or Changing a Button's Appearancep. 212
Copying or Deleting Buttonsp. 213
Resizing and Moving Buttonsp. 214
Changing Button Definitionsp. 214
Chapter 14 Creating Relational Databasesp. 215
Understanding Relational Jargonp. 218
Lookups vs. Portalsp. 220
Defining a Lookupp. 221
Creating Multiple Lookupsp. 222
Updating Lookupsp. 223
Defining Relationshipsp. 224
Changing or Editing Relationshipsp. 226
Creating a Portalp. 227
Part IV Printing, Networking, and the Web
Chapter 15 Printingp. 231
Selecting a Printerp. 231
Setting Page Marginsp. 232
Removing Unwanted Spacesp. 233
Previewing and Printingp. 234
Chapter 16 Networkingp. 235
Controlling File Sharingp. 237
Hosting a Databasep. 238
Opening a Database as a Guestp. 239
Controlling File Accessp. 240
Setting a Master Passwordp. 241
Defining Passwordsp. 242
Creating a Blank Passwordp. 243
Changing or Deleting Passwordsp. 244
Defining Groupsp. 245
Changing and Deleting Group Definitionsp. 247
Chapter 17 Exchanging Data via ODBCp. 249
Turning on Data Access Companionsp. 250
Using FileMaker Data in ODBC Applicationsp. 252
Importing ODBC Data into FileMakerp. 255
Chapter 18 Publishing on the Webp. 261
How It Works and What You'll Needp. 263
Setting Up and Configuring the Web Companionp. 265
Web Companion Optionsp. 267
Sharing and Viewing Web Filesp. 270
Testing Your Web Database Locallyp. 275
Once You Publish the Databasep. 279
Part V Appendices
Appendix A Installing and Configuring FileMakerp. 283
Appendix B Functionsp. 297
Appendix C Script Commandsp. 305
Appendix D Keyboard Shortcutsp. 311
Indexp. 321