FileMaker Pro 3-4 Tutorials - Online Training Course

Course Title: 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.

Course Author/Expert: Mark Vernon

Language: english

Full Online Training Available: Yes

Number of Course Movies: 254

Course Duration: 12 hours

Never has it been so easy to learn FileMaker Pro 3-4.
No expensive classroom training courses.
No boring hard to follow books to read.
Learn from your own desk at a pace that suits you.
High quality affordable training that is easy to use and follow.
Use unique training methods, it makes learning easy no matter what your learning style.

Course Outline:

Straight away, you can go through the first three chapters of this tutorial. If you need all the lessons, then join the Online University - complete access to over five hundred and fifty courses right now for as long as you need them and even get an online university certificate. See below for details.

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

To continue your learning, Click Here for the Online University and get access to all of the training courses, that's over 550 software programmes including 60,000 tutorial videos, for editing, image manipulation and graphics programmes. All for just $30 (approx £16) month. Unlimited access for as long as you need, cancel when you're finished, no contract, no minimum period, no hassle.

or

Click Here and we'll send you the training CD itself for FileMaker Pro 3-4 at £79.95

Home Find Software Courses Login Categories About SiteMap Contact

Add latest courses to Google Toolbar | After Effects Projects |

Starting Out

Contact Database

Invoicing