After teaching the fundamentals of this powerful application in FileMaker Pro 8.5 Essential Training, author Cris Ippolite continues his comprehensive training with FileMaker 8.5 Beyond the Basics. Taking it beyond the program's essentials, this set of tutorials covers topics as varied as data modeling, defining fields using aggregate functions, summarizing with multiple variables, and networking with FileMaker Server. We recommend that users new to FileMaker complete FileMaker Pro 8.5 Essential Training before watching this title. Exercise files are included with the tutorial.

Introduction
    
       
    
       Welcome      
    
0:37
    
0.7 MB
   
     
    
       Using the exercise files      
    
0:24
    
0.8 MB
   
  
    
1. Data Modeling
    
       
    
       Introduction to data modeling      
    
3:29
    
3.7 MB
   
     
    
       Reviewing relationships types      
    
3:47
    
3.8 MB
   
     
    
       Developing a list of entities      
    
3:01
    
2.7 MB
   
     
    
       Diagramming relationships      
    
3:52
    
3.5 MB
   
     
    
       Resolving one-to-one and many-to-many relationships      
    
5:11
    
4.6 MB
   
     
    
       The Relationship Graph vs. ERDs      
    
3:15
    
3.5 MB
   
  
    
2. Beyond Basic Relationships
    
       
    
       Multi-step relationships      
    
6:44
    
9.3 MB
   
     
    
       Working with external files      
    
4:25
    
6.4 MB
   
     
    
       Non-equijoin relationships      
    
11:33
    
17.1 MB
   
     
    
Using global fields in relationships
    
8:34
    
14 MB
   
  
    
3. Using Calculation Functions
    
       
    
Reviewing calculation syntax
    
8:59
    
13.1 MB
   
     
    
Number functions
    
8:59
    
12.1 MB
   
     
    
Text function essentials
    
18:57
    
26.9 MB
   
     
    
Defining fields using text functions
    
5:24
    
8.8 MB
   
     
    
The Date, Time, and Timestamp functions
    
5:21
    
7.3 MB
   
     
    
Working with the Date, Time, and Timestamp functions
    
4:42
    
7.8 MB
   
     
    
Introduction to logical functions
    
1:40
    
2.7 MB
   
     
    
Logical function: IsEmpty
    
1:39
    
2.2 MB
   
     
    
Logical function: If
    
3:40
    
4.4 MB
   
     
    
Logical function: Case
    
3:19
    
3.8 MB
   
     
    
Logical function: Let
    
7:51
    
9 MB
   
     
    
Logical function: Evaluate
    
4:03
    
5 MB
   
     
    
Working with logical functions
    
9:37
    
13.4 MB
   
     
    
Text formatting function essentials
    
4:29
    
6.5 MB
   
     
    
Defining fields using text formatting functions
    
10:29
    
17.4 MB
   
     
    
Get functions
    
5:01
    
6.4 MB
   
     
    
Aggregate function essentials
    
4:02
    
4.8 MB
   
     
    
Defining fields using aggregate functions
    
8:00
    
14.3 MB
   
     
    
Using the List function
    
5:13
    
8.8 MB
   
  
    
4. Working with Objects
    
       
    
Naming objects
    
4:35
    
7.1 MB
   
     
    
Using the Go to Object script step
    
2:19
    
3.6 MB
   
     
    
Using the LayoutObjectNames function
    
4:18
    
7.7 MB
   
     
    
Using the Get(ActiveLayoutObjectName) function
    
2:08
    
3.6 MB
   
     
    
Using the GetLayoutObjectAttribute function
    
6:13
    
7.3 MB
   
     
    
Putting it all together
    
12:26
    
19.8 MB
   
  
    
5. Beyond Basic Reports 
    
       
    
What is a subsummary report?
    
2:53
    
4.3 MB
   
     
    
Creating subsummary reports
    
9:41
    
13.6 MB
   
     
    
Subsummary reports with no body part
    
3:50
    
4.5 MB
   
     
    
Ranking reports
    
2:49
    
3.2 MB
   
     
    
Summarizing by multiple variables
    
5:59
    
8.1 MB
   
     
    
Crosstab reports
    
13:38
    
20.5 MB
   
  
    
6. Beyond Basic Scripting
    
       
    
Scripting for developers
    
0:42
    
0.6 MB
   
     
    
The If script step
    
8:58
    
13 MB
   
     
    
More with custom dialogs
    
13:21
    
20 MB
   
     
    
Error capturing
    
5:34
    
7.1 MB
   
     
    
The Set Field script step
    
4:22
    
6.3 MB
   
     
    
Script parameters
    
8:54
    
15.2 MB
   
     
    
Script results
    
5:18
    
7.2 MB
   
     
    
Looping scripts
    
9:16
    
12.1 MB
   
     
    
Set variables
    
8:57
    
13.1 MB
   
  
    
7. Beyond Basic Searching
    
       
    
Date and time searching
    
8:29
    
9.1 MB
   
     
    
Fast Match
    
2:26
    
3.1 MB
   
  
    
8. Converting Older Files to 8.5
    
       
    
Benefits of converting
    
10:12
    
8.2 MB
   
     
    
Mechanics of conversion
    
5:19
    
6 MB
   
     
    
Security issues during conversion
    
9:29
    
12.3 MB
   
     
    
Scripting issues during conversion
    
8:58
    
13 MB
   
     
    
Data issues during conversion
    
11:06
    
19.8 MB
   
  
    
9. Sharing a Database on a Network
    
       
    
Peer-to-peer networking
    
7:27
    
8.6 MB
   
     
    
Benefits of FileMaker Server
    
4:36
    
3.8 MB
   
     
    
Mixing FileMaker 7 and 8
    
3:12
    
3.3 MB
   
     
    
FileMaker Server vs. FileMaker Server Advanced
    
2:31
    
2.1 MB
   
     
    
Installing FileMaker Server
    
1:19
    
1.2 MB
   
     
    
The Server Administration tool
    
1:48
    
2.4 MB
   
     
    
Configuring FileMaker Server
    
12:37
    
16.3 MB
   
     
    
Scheduling backups
    
7:21
    
9.6 MB
   
  
    
Conclusion
               
Goodbye
    
0:13
    
0.3 MB

More info : http://movielibrary.lynda.com/html/modPage.asp?ID=281

Download:

http://rapidshare.com/files/18950123/lnd-fmp85btb.exe
http://rapidshare.com/files/18951995/lnd-fmp85btb.rar.1
http://rapidshare.com/files/18953448/lnd-fmp85btb.rar.2
http://rapidshare.com/files/18955324/lnd-fmp85btb.rar.3
http://rapidshare.com/files/18957109/lnd-fmp85btb.rar.4
http://rapidshare.com/files/18957268/lnd-fmp85btb.rar.5