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.
Starting OutIntroductionInstallationOpening FileMakerMoving Around FileMakerFiles, Records, FieldsAll About LayoutsSorting InformationFinding InformationMore on ModesPreviewing and PrintingCreating && Deleting RecordsAdding && Modifying FieldsIntro to Buttons && ScriptsThe Integrated SolutionContact DatabasePlanning your structureDefining FieldsTypes of FieldsEntry OptionsWorking on the layoutField FormattingCreating a layoutImporting dataCreating a goto buttonCreating Mail merge LettersCreating LabelsMaking it all look prettyAdding GraphicsTurn Graphics into ButtonsSimple ScriptingUse full List View ButtonList View Sorting buttonInvoicingRepetitive fields/page eakCalculationsHiddenFieldsDeleting records/serial numbersRelationships and Look-upsSliding fields on printingSummary TotalsCopying LayoutsTwo way relationshipsProduct DatabaseMore on formatting layouts
Importing Pictures
Creating catalogs
Sub-Summaries
Export/export with sum
Line ItemsProduct Look-ups
Create Line Items database
Three database relationship
Creating and using Portals
Calculations across databases
Creating reportsCreate Invoice report
Line Item Report
Exporting information
Copy data to another app.
Refining DatabasesNavigating 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 DatabasesTech Support Database
Activities Database
Customer Database Additions
MiscellaneousAccess 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 4Web 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 PublishingSetting it all Up
Changing the Views
Web Companion Configuration
Security
Remote Administration
Custom Web PublishingCDML Tool and Basics
Adding Hidden Fields
Dynamic Scripting
Resources
Control ScriptsScript 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 ScriptsGoto 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 ScriptsSort/Unsort
Find all, Find Omitted, Omit
Perform Find
Modify last Find
Page Setup and Print
Editing Commands
Fields and Records ScriptsSet 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/ExportFreeze/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 ScriptsNew, Open, Close
Change Password
Set Use System Formats
Save a Copy As
Recover
Spelling
Miscellaneous ScriptsShow 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 1Basics of Functions
Exact
Left
Left Words
Length
Lower
Middle
Middle Words
Pattern Count
Position
Proper
Replace
Right
Right Words
Text Functions 2Substitute
Text To Date
Text To Num
Text To Time
Trim
Upper
Word Count
Number FunctionsAbs
Exp
Int.
Mod
Num To Text
Random
Round
Sign
Sqrt
Truncate
Date FunctionsDate
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 FunctionsHour, Minute, Seconds
Time
Time To Text
Aggregate FunctionsAverage
Count
Max
Min
StDev
StDevP
Sum
Get Summary
Repeating FunctionsExtend
Get Repetition
Last
Financial FunctionsFV
NPV
PMT
PV
Trigonometric FunctionsAtan
Cos
Degrees
Ln
Log
PI
Radians
Sin
Logical FunctionsCase
Choose
If
Is Empty
Is Valid
Status Functions 1Current 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 2Current 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 3Current Time
Current User Count
Current User Name
Click here to find out more about the FileMaker Pro 3/4 Training CD 
