Home Products New Titles Shop Online Contact
test Software - MAC INCH Software - rosetta stone Software - ISO Software - adobe Software - quark Software - Crystal Software - Crystal Software - Quark Software - quick Software - fireworks Software - photoshop Software - audio Software -

FileMaker Pro 3/4 Training

More FileMaker Pro 3/4 Categories Filemaker training - Database training -
FileMaker Pro 3/4 Tutorials Online
Product FileMaker Pro 3/4 Details
Total Time : 9.99 hrs
Number of Movies : 254
Number of Discs : 1
Catalogue Number : 33016
Language : english
Author : Mark Vernon
Sale Price : $99.95

BUY this item NOW


View simillar products Filemaker training - Database training -
Description 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.
Sample - Preview the First 3 chapters of FileMaker Pro 3/4 video free. Free learning FileMaker Pro 3/4 online.

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

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

Invoicing
movie image Repetitive fields/page eak
movie image Calculations
movie image HiddenFields
movie image Deleting records/serial numbers
movie image Relationships and Look-ups
movie image Sliding fields on printing
movie image Summary Totals
movie image Copying Layouts
movie image 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