FileMaker Pro 3/4
Author:Mark Vernon
Language:english
Category:Databases,
Lessons:254 | 12 hrs
Buy Now or get more information about FileMaker Pro 3/4
Create powerful relational databases that allow you to produce invoices, form letters, client contact databases, purchase order systems, and much more. Virtual Training Company's FileMaker Pro 3/4 tutorial teaches you how to create relational databases, reports, use scripts, calculations, and functions. Go ahead and get started by clicking below on any selection you want to learn about.
First 3 Lessons Free Online (Press the links below to open up the free lessons. The lessons will open in a popup window from this screen and play in Quicktime):

FileMaker Pro 3/4

Starting Out

Introduction
Installation
Opening FileMaker
Moving Around FileMaker
Files, Records, Fields
All About Layouts
Sorting Information
Finding Information
More on Modes
Previewing and Printing
Creating & Deleting Records
Adding & Modifying Fields
Intro to Buttons & Scripts
The Integrated Solution

Contact Database

Planning your structure
Defining Fields
Types of Fields
Entry Options
Working on the layout
Field Formatting
Creating a layout
Importing data
Creating a goto button
Creating Mail merge Letters
Creating Labels
Making it all look pretty
Adding Graphics
Turn Graphics into Buttons
Simple Scripting
Use full List View Button
List View Sorting button

Invoicing

Repetitive fields/page eak
Calculations
HiddenFields
Deleting records/serial numbers
Relationships and Look-ups
Sliding fields on printing
Summary Totals
Copying Layouts
Two way relationships

Product Database

More on formatting layouts
Importing Pictures
Creating catalogs
Sub-Summaries
Export/export with sum

Line Items

Product Look-ups
Create Line Items database
Three database relationship
Creating and using Portals
Calculations across databases

Creating reports

Create Invoice report
Line Item Report
Exporting information
Copy data to another app.

Refining Databases

Navigating between databases
Navigating between records
Sharing Common Data
Field Tab Order
Layout Order and Display
Using Look-ups for value
Using Replace command
Paste Special-Date & Time
Tab and Paragraph control

Even More Databases

Tech Support Database
Activities Database
Customer Database Additions

Miscellaneous

Access Privileges
Sharing and Network Access
Recover damaged Databases
FileMaker Pro Preferences
Spelling
View as Form/List
Find Symbols
Multiple Finds
Paste from Index
Control Key pop-up menu

Whats New in FileMaker Pro 4

Web Features
HTML Export
GIF & JPEG Import
Sorting Portal Records
Text and Item Rotation
Excel conversion
New Preferences
Value Lists
Find Exact Matching Fields
New Scripts & Functions

Instant Web Publishing

Setting it all Up
Changing the Views
Web Companion Configuration
Security
Remote Administration

Custom Web Publishing

CDML Tool and Basics
Adding Hidden Fields
Dynamic Scripting
Resources

Control Scripts

Script Maker Basics
Perform Script, Sub-script
Pause/Resume
If, Else, End If
Loop/End Loop
Halt, Exit, Exit Loop if
User abort/error capture

Navigation Scripts

Goto Layout
Goto record/request/page
Goto related record
Goto portal row
Goto Field
Goto Next/Previous field
Goto Browse/Find/Preview

Sort, Find and Print Scripts

Sort/Unsort
Find all, Find Omitted, Omit
Perform Find
Modify last Find
Page Setup and Print
Editing Commands

Fields and Records Scripts

Set Field
Set Literal
Paste result
Paste From Index
Paste from Last Record
Paste Date, Time, User Name
New/Duplicate/Delete/Revert
Copy record/Copy all records
Replace
Delete all Records
Re-lookup

Windows and Import/Export

Freeze/Refresh Window
Scroll Window
Toggle Window/Hide Window
Show/Hide/Lock Status Area
Show/Hide Text Ruler
Set Zoom Level
View As Form/List
Export Records
Import Records

Files Scripts

New, Open, Close
Change Password
Set Use System Formats
Save a Copy As
Recover
Spelling

Miscellaneous Scripts

Show Message
Beep and Speak
Dial Phone
Open Help
Define Fields/Relationship
Open Script maker
Perform Apple script
Comment
Flush Cache to Disk
Quit Application

Text Functions 1

Basics of Functions
Exact
Left
Left Words
Length
Lower
Middle
Middle Words
Pattern Count
Position
Proper
Replace
Right
Right Words

Text Functions 2

Substitute
Text To Date
Text To Num
Text To Time
Trim
Upper
Word Count

Number Functions

Abs
Exp
Int.
Mod
Num To Text
Random
Round
Sign
Sqrt
Truncate

Date Functions

Date
Date To Text
Day & Day Name
Day of Week, Day of Year
Month & Month Name
Today
Week of Year
Week of Year Fiscal
Year

Time Functions

Hour, Minute, Seconds
Time
Time To Text

Aggregate Functions

Average
Count
Max
Min
StDev
StDevP
Sum
Get Summary

Repeating Functions

Extend
Get Repetition
Last

Financial Functions

FV
NPV
PMT
PV

Trigonometric Functions

Atan
Cos
Degrees
Ln
Log
PI
Radians
Sin

Logical Functions

Case
Choose
If
Is Empty
Is Valid

Status Functions 1

Current App. Version
Current Date
Current Error
Current Field Name
Current File Name
Current File Size
Current Found Count
Current Host Name
Current Language
Current Layout Count
Current Layout Name
Current Layout Number
Current Message Choice
Current Mode

Status Functions 2

Current Multi-User Status
Current Page Number
Current Platform
Current Portal Row
Current Printer Name
Current Record Count
Current Record Number
Current Repetition Number
Current Request Count
Current Screen Depth
Current Screen Height/Width
Current Script Name
Current Sort Status
Current System Version

Status Functions 3

Current Time
Current User Count
Current User Name

01 Starting Out
0101 Introduction
0102 Installation
0103 Opening FileMaker
0104 Moving Around FileMaker
0105 Files, Records, Fields
0106 All About Layouts
0107 Sorting Information
0108 Finding Information
0109 More on Modes
0110 Previewing and Printing
0111 Creating & Deleting Records
0112 Adding & Modifying Fields
0113 Intro to Buttons & Scripts
0114 The Integrated Solution

02 Contact Database
0201 Planning your structure
0202 Defining Fields
0203 Types of Fields
0204 Entry Options
0205 Working on the layout
0206 Field Formatting
0207 Creating a layout
0208 Importing data
0209 Creating a goto button
0210 Creating Mail merge Letters
0211 Creating Labels
0212 Making it all look pretty
0213 Adding Graphics
0214 Turn Graphics into Buttons
0215 Simple Scripting
0216 Use full List View Button
0217 List View Sorting button

03 Invoicing
0301 Repetitive fields/page eak
0302 Calculations
0303 HiddenFields
0304 Deleting records/serial numbers
0305 Relationships and Look-ups
0306 Sliding fields on printing
0307 Summary Totals
0308 Copying Layouts
0309 Two way relationships

04 Product Database
0401 More on formatting layouts
0402 Importing Pictures
0403 Creating catalogs
0404 Sub-Summaries
0405 Export/export with sum

05 Line Items
0501 Product Look-ups
0502 Create Line Items database
0503 Three database relationship
0504 Creating and using Portals
0505 Calculations across databases

06 Creating reports
0601 Create Invoice report
0602 Line Item Report
0603 Exporting information
0604 Copy data to another app.

07 Refining Databases
0701 Navigating between databases
0702 Navigating between records
0703 Sharing Common Data
0704 Field Tab Order
0705 Layout Order and Display
0706 Using Look-ups for value
0707 Using Replace command
0708 Paste Special-Date & Time
0709 Tab and Paragraph control

08 Even More Databases
0801 Tech Support Database
0802 Activities Database
0803 Customer Database Additions

09 Miscellaneous
0901 Access Privileges
0902 Sharing and Network Access
0903 Recover damaged Databases
0904 FileMaker Pro Preferences
0905 Spelling
0906 View as Form/List
0907 Find Symbols
0908 Multiple Finds
0909 Paste from Index
0910 Control Key pop-up menu

10 Whats New in FileMaker Pro 4
1001 Web Features
1002 HTML Export
1003 GIF & JPEG Import
1004 Sorting Portal Records
1005 Text and Item Rotation
1006 Excel conversion
1007 New Preferences
1008 Value Lists
1009 Find Exact Matching Fields
1010 New Scripts & Functions

11 Instant Web Publishing
1101 Setting it all Up
1102 Changing the Views
1103 Web Companion Configuration
1104 Security
1105 Remote Administration

12 Custom Web Publishing
1201 CDML Tool and Basics
1202 Adding Hidden Fields
1203 Dynamic Scripting
1204 Resources

13 Control Scripts
1301 Script Maker Basics
1302 Perform Script, Sub-script
1303 Pause/Resume
1304 If, Else, End If
1305 Loop/End Loop
1306 Halt, Exit, Exit Loop if
1307 User abort/error capture

14 Navigation Scripts
1401 Goto Layout
1402 Goto record/request/page
1403 Goto related record
1404 Goto portal row
1405 Goto Field
1406 Goto Next/Previous field
1407 Goto Browse/Find/Preview

15 Sort, Find and Print Scripts
1501 Sort/Unsort
1502 Find all, Find Omitted, Omit
1503 Perform Find
1504 Modify last Find
1505 Page Setup and Print
1506 Editing Commands

16 Fields and Records Scripts
1601 Set Field
1602 Set Literal
1603 Paste result
1604 Paste From Index
1605 Paste from Last Record
1606 Paste Date, Time, User Name
1607 New/Duplicate/Delete/Revert
1608 Copy record/Copy all records
1609 Replace
1610 Delete all Records
1611 Re-lookup

17 Windows and Import/Export
1701 Freeze/Refresh Window
1702 Scroll Window
1703 Toggle Window/Hide Window
1704 Show/Hide/Lock Status Area
1705 Show/Hide Text Ruler
1706 Set Zoom Level
1707 View As Form/List
1708 Export Records
1709 Import Records

18 Files Scripts
1801 New, Open, Close
1802 Change Password
1803 Set Use System Formats
1804 Save a Copy As
1805 Recover
1806 Spelling

19 Miscellaneous Scripts
1901 Show Message
1902 Beep and Speak
1903 Dial Phone
1904 Open Help
1905 Define Fields/Relationship
1906 Open Script maker
1907 Perform Apple script
1908 Comment
1909 Flush Cache to Disk
1910 Quit Application

20 Text Functions 1
2001 Basics of Functions
2002 Exact
2003 Left
2004 Left Words
2005 Length
2006 Lower
2007 Middle
2008 Middle Words
2009 Pattern Count
2010 Position
2011 Proper
2012 Replace
2013 Right
2014 Right Words

21 Text Functions 2
2101 Substitute
2102 Text To Date
2103 Text To Num
2104 Text To Time
2105 Trim
2106 Upper
2107 Word Count

22 Number Functions
2201 Abs
2202 Exp
2203 Int.
2204 Mod
2205 Num To Text
2206 Random
2207 Round
2208 Sign
2209 Sqrt
2210 Truncate

23 Date Functions
2301 Date
2302 Date To Text
2303 Day & Day Name
2304 Day of Week, Day of Year
2305 Month & Month Name
2306 Today
2307 Week of Year
2308 Week of Year Fiscal
2309 Year

24 Time Functions
2401 Hour, Minute, Seconds
2402 Time
2403 Time To Text

25 Aggregate Functions
2501 Average
2502 Count
2503 Max
2504 Min
2505 StDev
2506 StDevP
2507 Sum
2508 Get Summary

26 Repeating Functions
2601 Extend
2602 Get Repetition
2603 Last

27 Financial Functions
2701 FV
2702 NPV
2703 PMT
2704 PV

28 Trigonometric Functions
2801 Atan
2802 Cos
2803 Degrees
2804 Ln
2805 Log
2806 PI
2807 Radians
2808 Sin

29 Logical Functions
2901 Case
2902 Choose
2903 If
2904 Is Empty
2905 Is Valid

30 Status Functions 1
3001 Current App. Version
3002 Current Date
3003 Current Error
3004 Current Field Name
3005 Current File Name
3006 Current File Size
3007 Current Found Count
3008 Current Host Name
3009 Current Language
3010 Current Layout Count
3011 Current Layout Name
3012 Current Layout Number
3013 Current Message Choice
3014 Current Mode

31 Status Functions 2
3101 Current Multi-User Status
3102 Current Page Number
3103 Current Platform
3104 Current Portal Row
3105 Current Printer Name
3106 Current Record Count
3107 Current Record Number
3108 Current Repetition Number
3109 Current Request Count
3110 Current Screen Depth
3111 Current Screen Height/Width
3112 Current Script Name
3113 Current Sort Status
3114 Current System Version

32 Status Functions 3
3201 Current Time
3202 Current User Count
3203 Current User Name

Sponsors