I. GETTING STARTED.
1. Using FileMaker Pro 5.
Why FileMaker? What's New in FileMaker 5? Using This Book. One Program, One Book for Windows and Macintosh.
2. Database Basics.
Content vs Form. Anatomy of a Database.
3. FileMaker Basics.
FileMaker's Screen and Modes. FileMaker's Menus. FileMaker's Toolbars. Opening, Closing, and Saving Files.
II. WORKING WITH RECORDS AND FILES.
4. Viewing Records.
Opening a File. Viewing Multiple or Single Records. Moving from Record to Record. Moving within a Record.
5. Finding and Sorting Records.
Finding Records. Doing a Simple Search. Doing Multiple Criteria Searches. Refining Searches. Modifying Find Requests. Adding a New Request. Duplicating and Changing a Request. Deleting a Request. Reverting Requests. Omitting Records. Deleting Records. Sorting Records. Running Multiple Sorts. Setting Sort Orders.
6. Using Spell Check and Dictionaries.
Checking Spelling. Creating a User Dictionary. Selecting or Switching Dictionaries. Editing a User Dictionary. Importing or Exporting a Text File.
7. Converting Files.
Converting Earlier FileMaker versions. Importing Data into FileMaker. Importing Data into a New Database. Importing Data into an Existing Database. Importing from a FileMaker 5 Database. Exporting FileMaker Data. Recovering Damaged Files.
III. CREATING & DESIGNING DATABASES.
8. Planning Databases.
How about a SlowStart? Follow the Paper. You Must Remember This.
9. Defining Fields.
Choosing a Field Type. Defining and Changing Fields. Setting Field Entry Options. Auto Enter Options. Validation Options. Storage Options (Indexing). Using Value Lists. Formatting Value List Fields. Using Repeating Fields. Formatting Repeating Fields. Understanding Formulas. Using Predefined Formulas. Using Calculation and Summary Fields. Editing Formulas. Displaying and Repeating Calculations. Storing Calculation Results. Defining Summary Fields.
10. Creating Layouts.
Choosing a Layout Type. Working with Layouts. Creating New Layouts. Renaming and Deleting Layouts. Duplicating Layouts. Choosing a Layout View. Reordering Layouts. Adding and Removing Layouts. Changing the Layout Setup. Creating Label Layouts. Creating Envelope Layouts. Creating a Return Address. Creating Form Letter Layouts. Using Variable Fields in Layouts. Working with Parts. Adding Layout Parts. Deleting, Reordering, and Resizing Parts. Changing a Part's Type and Options. Working with Fields in Layouts. Adding and Deleting Fields in Layouts. Resizing Fields in Layouts. Adding Scroll Bars to Fields. Setting the Field Tab Order.
11. Working with Objects in Layouts.
Moving Objects within Layouts. Copying and Deleting Objects. Grouping Objects. Ungrouping, Locking, and Unlocking Objects. Changing the Object Stacking Order. Rotating Objects. Aligning Objects. Using Layout Guides. Using Layout Rulers. Using T-Squares and Object Grids. Using the Size Palette. Changing Ruler and Grid Units.
12. Formatting and Graphics in Layouts.
Working with Text. Selecting Text. Setting Format Defaults. Formatting Fields or Objects. Setting Multiple Text Attributes. Setting Text Tabs. Setting Fonts, Text Sizes, and Styles. Setting Text Alignment and Line Spacing. Setting Text Colors. Formatting Numbers. Formatting Date Fields. Formatting Time Fields. Formatting Graphic Fields. Working with Graphics. Drawing Objects. Selecting and Moving Objects. Deselecting and Resizing Objects. Changing Fill Colors, Patterns, and Effects. Changing Lines. Changing Borders, Fills, and Baselines.
13. Using Templates and Scripts.
Working with Templates. Working with Scripts. Preparing to Create a Script. Defining Scripts. Changing Scripts. Copying Scripts. Importing Scripts. Deleting Scripts. Reordering, Changing Script Shortcuts. Defining Buttons for Scripts. Setting or Changing a Button's Appearance. Copying or Deleting Buttons. Resizing and Moving Buttons. Changing Button Definitions.
14. Creating Relational Databases.
Understanding Relational Jargon. Lookups vs. Portals. Defining a Lookup. Creating Multiple Lookups. Updating Lookups. Defining Relationships. Changing or Editing Relationships. Creating a Portal.
IV. PRINTING, NETWORKING, AND THE WEB.
15. Printing.
Selecting a Printer. Setting Page Margins. Removing Unwanted Spaces. Previewing and Printing.
16. Networking.
Controlling File Sharing. Hosting a Database. Opening a Database as a Guest. Controlling File Access. Setting a Master Password. Defining Passwords. Creating a Blank Password. Changing or Deleting Passwords. Defining Groups. Changing and Deleting Group Definitions.
17. Exchanging Data via ODBC.
Turning on Data Access Companions. Using FileMaker Data in ODBC Applications. Importing ODBC Data into FileMaker.
18. Publishing on the Web.
How It Works and What You'll Need. Setting Up and Configuring the Web Companion. Web Companion Options. Sharing and Viewing Web Files. Testing Your Web Database Locally. Once You Publish the Database.
V. APPENDICES.
Appendix A. Installing and Configuring FileMaker.
Appendix B. Functions.
Appendix C. Script Commands.
Appendix D. Keyboard Shortcuts.
