FileMaker Pro 3/4 Tutorial - Training Videos

Training CDs > Databases Tutorial Videos > FILEMAKER 3

Affordable Training you can depend on
This FileMaker Pro 3/4 video tutorial utilizes an easy to follow training format that is both engaging and informative. Created to assist the beginners to intermediate users, the author uses a unique training method that brings a high degree of visual clarity to even the most complex applications. Being over 12 hours long these FileMaker Pro 3/4 tutorials are extremely comprehensive and easy to follow. Video Training by Experts - Low Cost.

Not sure which Training CDs to buy?
The Online University allows unlimited access to the entire range of training titles for one low fee of only $30 per month. There is no fixed term, no limits, and you can cancel at any time. For corporate users and schools we also offer multi user accounts.
Find out more about the online video tutorials »

About the Free Video Online Training Course Demos
To allow you to evaluate the quality of the FileMaker 3 training course we have made the first 3 chapters of this tutorial available for free viewing online, the purchased version of this training course contains all the topics listed below. The free demos below have been compressed for faster playback over the internet, the audio and video quality of the purchased CD / DVD is far greater. To play the free demo videos you will need QuickTime,

THIS TUTORIAL COVERS THE FOLLOWING SUBJECTS

Description

This FileMaker tutorial uses working examples and narrated QuickTime videos to deliver training that is ideal for the beginner, users have total control over the speed of the videos and the training can be stopped, rewound or fast forwarded at any time. By the conclusion of this training course users will have a firm working knowledge of creating databases, using scripts, running reports and carrying out calculations within FileMaker. You may also be intrested in our FileMaker 8 tutorial .

FileMaker Pro 3/4 Related Groups

Hide Description

The Blue Links below are free demos, when you purchase the video training CD / DVD the enitre content listings below are included , not just the free demo videos.

Starting Out

Contact Database

Invoicing

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

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

FileMaker 3 Tutorials - VIDEO INFO

» Studio quality audio and video
» Works on Pc or Mac
» Ideal for people that learn quicker by being shown
» Master complex application in days

Title	:	FileMaker Pro 3/4
Instructor	:	Mark Vernon
Price	:	US$ 99.95
Duration	:	12 hours - 254 Movies
OS	:	Win Vista XP 98,2000,ME. Mac OS 9, OS X
Delivery Options	:	Ground / 2 day / Next Day
Product Code	:	33016

BENEFITS OF THIS TRAINING COURSE

Master FileMaker 3 in the shortest time possible
Self paced tutorial, training on video, at your own pace
Just sit back and watch, no books to read, just easy to follow lessons
Training can be viewed from any location, on PC or Mac
All training is self-contained; you don’t even need the application you are learning loaded on your machine
The most affordable way to learn, benefit from a world-leading expert
High quality content for a fraction of the cost of a classroom training course
The Tutorials can be rewound, fast forwarded or stopped at any time
Learn from the comfort of your own desk.