• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Y
• Z

In FileMaker Pro 9 Beyond the Basics, Certified Developer and Authorized Trainer Cris Ippolite offers comprehensive training in how to use FileMaker Pro 9 to its full potential. He also teaches numerous hands-on techniques for publishing FileMaker Pro 9 databases to networks and the web. The tutorials cover relationship types, external data sources, the new FileMaker Server 9, functions, objects, simple and complex reports, and even the new PHP Site Assistant. Exercise files accompany the tutorials.

Course FileMaker Pro 9 Beyond the Basics Author Cris Ippolite SKU ISBN Release Date 2007-07-18 Duration 8.40 hrs / 96 tutorials Work files Yes Price $ 49.95 Retail price $ 99.95 Language Tags

1. Data Modeling Introducing data modeling 03:29 Reviewing relationships types 03:37 Developing a list of entities 02:53 Diagramming relationships 03:51 Resolving one-to-one and many-to-many relationships 05:04 Comparing the Relationship Graph and ERD 04:38 2. Beyond Basic Relationships Understanding multi-step relationships 06:43 Working with external files 06:22 Non-equijoin relationships 09:55 Using global fields in relationships 08:17 3. Working with Number and Text Function Calculations Reviewing number functions 04:11 Floor/Ceiling functions 01:59 Round/Truncate functions 04:34 Reviewing text functions 06:28 Length functions 01:21 Pattern Count functions 01:58 Position functions 02:12 Left/Right/Middle functions 07:28 Filter and Substitute functions 03:10 4. Working with Logical Function Calculations Reviewing logical functions 02:30 Logical functions pt. 1: IsEmpty 04:50 Logical Functions pt. 2: Let 08:21 Logical Functions pt. 3: Evaluate 06:17 Self functions 03:41 5. Working with Text Formatting Function Calculations Reviewing text formatting functions 05:30 Defining fields using text formatting functions 04:16 6. Working with Aggregate Function Calculations Reviewing aggregate functions 01:49 Defining fields using aggregate functions 08:31 Using the List function 11:40 7. Working with Objects Naming objects 04:56 Using the Go to Object script step 02:34 Using the LayoutObjectNames function 05:01 Using the Get(ActiveLayoutObjectName) function 02:16 Using the GetLayoutObjectAttribute function 08:10 Putting it all together 12:29 8. Beyond Basic Reporting What is a subsummary report? 04:03 Creating subsummary reports 09:36 Subsummary reports with no body part 02:51 Ranking reports 02:21 Summarizing by multiple variables 07:50 Cross-tab reports 20:16 9. Beyond Basic Scripting Scripting for developers 00:59 The ''If'' script step 10:28 More with custom dialogs 15:22 Error capture 07:06 The Set Field script step 04:50 Script parameters 05:08 Script results 06:27

Looping scripts 08:23 Script variables 06:13 Copying and pasting scripts 01:13 10. Publishing Your Databases on a Network Peer-to-peer networking 07:45 The benefits of FileMaker Server 05:30 Mixing FileMaker 7, 8, and 9 01:41 FileMaker Server vs. FileMaker Server Advanced 02:12 Installing FileMaker Server 02:52 The Deployment Assistant 07:14 The Admin Console start page 14:55 Configuring FileMaker Server 17:06 Uploading databases 05:21 Scheduling 07:07 11. Working with External SQL Sources Connecting to external data sources 03:55 Setting up DSN (Mac) 07:15 Setting up DSN (Windows) 02:46 Managing sources 04:24 Adding to the Relationship Graph 05:53 Creating supplemental fields 10:16 Synchronizing shadow fields 02:44 Working with Flash and external data sources 03:19 12. Extending the Web Viewer Using custom URLs in the Web Viewer 12:16 Tabbing into and within the Web Viewer 01:45 Printing and previewing with the Web Viewer 01:18 Setting the Web Viewer script step 05:27 Flash in the Web Viewer 02:50 13. Publishing Your Databases on the Web FileMaker 9 web publishing options 02:58 Prepping your files for web publishing 01:56 Configuring the server for web publishing 02:41 14. Instant Web Publishing Instant web publishing (IWP) overview 04:30 Prepping your database for IWP 02:58 Hosting options for IWP 05:58 Logging in and out 03:07 Browse mode 04:28 Find mode 03:06 Edit mode 02:46 Special considerations 04:03 15. The XSLT Site Assistant Preparing your files for XSLT 04:48 Using the XSLT Site Assistant 09:19 Previewing your site 10:14 16. The PHP Site Assistant Preparing files for publishing 05:54 Choosing a layout group 01:47 Selecting a site profile 01:59 Defining the site 07:53 Previewing the PHP site 08:50 Conclusion Goodbye 00:17