FileMaker Pro 8:
Advanced

Topic-Level Outline

Days: 1

Prerequisites: FileMaker Pro 8: Basic or equivalent experience

Unit 1 : Field options

Topic A: 0 Advanced value lists

A-1: Creating a value list based on field contents

A-2: Creating a value list from a related field

Topic B: 0 Advanced calculations

B-1: Creating an If calculation

B-2: Creating a multiple criteria If calculation

B-3: Creating a Case calculation

B-4: Concatenating text

Topic C: 0 Field auto-entry

C-1: Auto-entering serial numbers and dates

C-2: Entering calculated values automatically

Topic D: 0 Field validation

D-1: Validating field entry

Topic E: 0 Container fields

E-1: Creating and populating container fields

Unit 2 : Many-to-many relationships

Topic A: 0 Relationship types

A-1: Determining relationship types

Topic B: 0 Many-to-many relationship formation

B-1: Creating a many-to-many relationship

B-2: Placing many-to-many related fields on layouts

Topic C: 0 Lookups

C-1: Looking up data via a relationship

Topic D: 0 Related table summary

D-1: Summarizing data across a many-to-many relationship

Unit 3 : Advanced layouts

Topic A: 0 Layout efficiency boosters

A-1: Adjusting margins

A-2: Precisely adjusting items

A-3: Setting layout preferences

Topic B: 0 Layout parts

B-1: Creating a summary only layout

B-2: Editing a report script

Topic C: 0 Object appearance

C-1: Hiding and sliding objects for printing

C-2: Adding field effects

Topic D: 0 Merge fields

D-1: Displaying multiple fields in one box

Topic E: 0 Field entry behavior

E-1: Controlling field entry behavior

E-2: Setting the tab order

Unit 4 : Complex scripts

Topic A: 0 Chained scripts

A-1: Performing one script from within others

Topic B: 0 Related record scripts

B-1: Creating a script to display related records

Topic C: 0 Intercepting errors

C-1: Determining an error code

C-2: Conditionally responding to an error code

Topic D: 0 Script parameters

D-1: Passing parameters to scripts

Topic E: 0 Script problems

E-1: Preventing closing the only open window

E-2: Displaying only related records

E-3: Organizing the Scripts menu

Unit 5 : Networking databases

Topic A: 0 Database security

A-1: Creating privilege sets

A-2: Creating accounts

A-3: Testing accounts

Topic B: 0 Multiple user access

B-1: Enabling multiple user access

B-2: Using a shared database

Topic C: 0 Web publishing

C-1: Enabling Instant Web Publishing

C-2: Accessing databases via a Web browser

C-3: Linking to databases from another Web page

C-4: Viewing Web activity logs

Appendix A : Complex relationships

Topic A: 0 Self-joining relationships

Topic B: 0 Dependent value lists

Topic C: 0 Multiple relationships to one table

Topic D: 0 Complex criteria relationships