To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.
Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.
лл Hide This
|
Starting Out
|
 |
Introduction |
(00:53) |
|
Installation |
(02:11) |
|
Opening FileMaker |
(03:47) |
|
Moving Around FileMaker |
(01:53) |
|
Files, Records, Fields |
(03:13) |
|
All About Layouts |
(04:20) |
|
Sorting Information |
(01:15) |
|
Finding Information |
(01:44) |
|
More on Modes |
(00:53) |
|
Previewing and Printing |
(01:22) |
|
Creating & Deleting Records |
(00:48) |
|
Adding & Modifying Fields |
(03:00) |
|
Intro to Buttons & Scripts |
(02:14) |
|
The Integrated Solution |
(05:49) |
Contact Database
|
|
Planning your structure |
(02:12) |
|
Defining Fields |
(04:07) |
|
Types of Fields |
(05:21) |
|
Entry Options |
(11:49) |
|
Working on the layout |
(14:22) |
|
Field Formatting |
(11:42) |
|
Creating a layout |
(04:58) |
|
Importing data |
(07:20) |
|
Creating a goto button |
(04:32) |
|
Creating Mail merge Letters |
(08:10) |
|
Creating Labels |
(04:12) |
|
Making it all look pretty |
(12:33) |
|
Adding Graphics |
(05:04) |
|
Turn Graphics into Buttons |
(04:40) |
|
Simple Scripting |
(04:49) |
|
Use full List View Button |
(03:58) |
|
List View Sorting button |
(03:29) |
Invoicing
|
|
Repetitive fields/page eak |
(10:58) |
|
Calculations |
(05:53) |
|
HiddenFields |
(01:32) |
|
Deleting records/serial numbers |
(00:44) |
|
Relationships and Look-ups |
(06:39) |
|
Sliding fields on printing |
(02:10) |
|
Summary Totals |
(05:51) |
|
Copying Layouts |
(09:25) |
|
Two way relationships |
(03:07) |
Product Database
|
 |
More on formatting layouts |
(06:59) |
|
Importing Pictures |
(02:27) |
|
Creating catalogs |
(05:28) |
|
Sub-Summaries |
(04:22) |
|
Export/export with sum |
(04:22) |
Line Items
|
|
Product Look-ups |
(05:44) |
|
Create Line Items database |
(01:17) |
|
Three database relationship |
(03:10) |
|
Creating and using Portals |
(04:21) |
|
Calculations across databases |
(06:09) |
Creating reports
|
|
Create Invoice report |
(15:16) |
|
Line Item Report |
(08:10) |
|
Exporting information |
(02:32) |
|
Copy data to another app. |
(01:14) |
Refining Databases
|
|
Navigating between databases |
(07:45) |
|
Navigating between records |
(03:53) |
|
Sharing Common Data |
(10:40) |
|
Field Tab Order |
(03:38) |
|
Layout Order and Display |
(00:45) |
|
Using Look-ups for value |
(06:00) |
|
Using Replace command |
(01:37) |
|
Paste Special-Date & Time |
(02:52) |
|
Tab and Paragraph control |
(03:36) |
Even More Databases
|
|
Tech Support Database |
(03:34) |
|
Activities Database |
(01:37) |
|
Customer Database Additions |
(04:37) |
Miscellaneous
|
|
Access Privileges |
(04:34) |
|
Sharing and Network Access |
(01:33) |
|
Recover damaged Databases |
(02:02) |
|
FileMaker Pro Preferences |
(04:52) |
|
Spelling |
(04:19) |
|
View as Form/List |
(01:39) |
|
Find Symbols |
(04:57) |
|
Multiple Finds |
(02:15) |
|
Paste from Index |
(01:10) |
|
Control Key pop-up menu |
(00:58) |
Whats New in FileMaker Pro 4
|
|
Web Features |
(03:38) |
|
HTML Export |
(01:43) |
|
GIF & JPEG Import |
(01:37) |
|
Sorting Portal Records |
(00:47) |
|
Text and Item Rotation |
(00:59) |
|
Excel conversion |
(01:10) |
|
New Preferences |
(01:34) |
|
Value Lists |
(00:52) |
|
Find Exact Matching Fields |
(00:45) |
|
New Scripts & Functions |
(10:37) |
Instant Web Publishing
|
|
Setting it all Up |
(03:21) |
|
Changing the Views |
(02:55) |
|
Web Companion Configuration |
(05:24) |
|
Security |
(07:48) |
|
Remote Administration |
(02:52) |
Custom Web Publishing
|
|
CDML Tool and Basics |
(11:12) |
|
Adding Hidden Fields |
(01:22) |
|
Dynamic Scripting |
(14:50) |
|
Resources |
(03:18) |
Control Scripts
|
|
Script Maker Basics |
(01:44) |
|
Perform Script, Sub-script |
(03:01) |
|
Pause/Resume |
(02:24) |
|
If, Else, End If |
(03:04) |
|
Loop/End Loop |
(07:04) |
|
Halt, Exit, Exit Loop if |
(01:43) |
|
User abort/error capture |
(01:07) |
Navigation Scripts
|
|
Goto Layout |
(01:29) |
|
Goto record/request/page |
(02:09) |
|
Goto related record |
(01:31) |
|
Goto portal row |
(03:32) |
|
Goto Field |
(00:19) |
|
Goto Next/Previous field |
(00:20) |
|
Goto Browse/Find/Preview |
(00:57) |
Sort, Find and Print Scripts
|
|
Sort/Unsort |
(01:17) |
|
Find all, Find Omitted, Omit |
(03:17) |
|
Perform Find |
(01:34) |
|
Modify last Find |
(01:12) |
|
Page Setup and Print |
(01:36) |
|
Editing Commands |
(00:46) |
Fields and Records Scripts
|
|
Set Field |
(00:49) |
|
Set Literal |
(01:09) |
|
Paste result |
(00:15) |
|
Paste From Index |
(01:09) |
|
Paste from Last Record |
(00:54) |
|
Paste Date, Time, User Name |
(01:42) |
|
New/Duplicate/Delete/Revert |
(01:58) |
|
Copy record/Copy all records |
(01:04) |
|
Replace |
(01:18) |
|
Delete all Records |
(00:13) |
|
Re-lookup |
(02:16) |
Windows and Import/Export
|
|
Freeze/Refresh Window |
(00:26) |
|
Scroll Window |
(01:16) |
|
Toggle Window/Hide Window |
(00:51) |
|
Show/Hide/Lock Status Area |
(01:18) |
|
Show/Hide Text Ruler |
(00:20) |
|
Set Zoom Level |
(00:44) |
|
View As Form/List |
(00:42) |
|
Export Records |
(02:41) |
|
Import Records |
(02:32) |
Files Scripts
|
|
New, Open, Close |
(01:33) |
|
Change Password |
(00:51) |
|
Set Use System Formats |
(00:12) |
|
Save a Copy As |
(01:07) |
|
Recover |
(00:12) |
|
Spelling |
(00:14) |
Miscellaneous Scripts
|
|
Show Message |
(00:49) |
|
Beep and Speak |
(01:04) |
|
Dial Phone |
(00:25) |
|
Open Help |
(00:09) |
|
Define Fields/Relationship |
(00:51) |
|
Open Script maker |
(00:41) |
|
Perform Apple script |
(01:17) |
|
Comment |
(00:20) |
|
Flush Cache to Disk |
(00:11) |
|
Quit Application |
(00:21) |
Text Functions 1
|
|
Basics of Functions |
(00:57) |
|
Exact |
(01:46) |
|
Left |
(00:26) |
|
Left Words |
(00:34) |
|
Length |
(00:18) |
|
Lower |
(00:20) |
|
Middle |
(00:37) |
|
Middle Words |
(00:25) |
|
Pattern Count |
(00:59) |
|
Position |
(03:02) |
|
Proper |
(00:27) |
|
Replace |
(01:17) |
|
Right |
(00:38) |
|
Right Words |
(00:35) |
Text Functions 2
|
|
Substitute |
(00:42) |
|
Text To Date |
(00:44) |
|
Text To Num |
(00:25) |
|
Text To Time |
(00:21) |
|
Trim |
(00:26) |
|
Upper |
(00:15) |
|
Word Count |
(00:19) |
Number Functions
|
|
Abs |
(00:23) |
|
Exp |
(00:29) |
|
Int. |
(00:18) |
|
Mod |
(00:31) |
|
Num To Text |
(00:27) |
|
Random |
(00:52) |
|
Round |
(00:45) |
|
Sign |
(00:30) |
|
Sqrt |
(00:21) |
|
Truncate |
(00:32) |
Date Functions
|
|
Date |
(01:04) |
|
Date To Text |
(00:38) |
|
Day & Day Name |
(00:27) |
|
Day of Week, Day of Year |
(00:35) |
|
Month & Month Name |
(00:29) |
|
Today |
(00:29) |
|
Week of Year |
(00:24) |
|
Week of Year Fiscal |
(00:48) |
|
Year |
(00:21) |
Time Functions
|
|
Hour, Minute, Seconds |
(00:34) |
|
Time |
(00:44) |
|
Time To Text |
(00:24) |
Aggregate Functions
|
|
Average |
(01:05) |
|
Count |
(00:30) |
|
Max |
(00:19) |
|
Min |
(00:21) |
|
StDev |
(00:15) |
|
StDevP |
(00:15) |
|
Sum |
(01:27) |
|
Get Summary |
(02:16) |
Repeating Functions
|
|
Extend |
(01:15) |
|
Get Repetition |
(00:36) |
|
Last |
(00:16) |
Financial Functions
|
|
FV |
(01:40) |
|
NPV |
(00:40) |
|
PMT |
(01:37) |
|
PV |
(00:38) |
Trigonometric Functions
|
|
Atan |
(00:24) |
|
Cos |
(00:22) |
|
Degrees |
(00:13) |
|
Ln |
(00:18) |
|
Log |
(00:24) |
|
PI |
(00:25) |
|
Radians |
(00:12) |
|
Sin |
(00:17) |
Logical Functions
|
|
Case |
(01:37) |
|
Choose |
(00:52) |
|
If |
(01:26) |
|
Is Empty |
(00:41) |
|
Is Valid |
(00:56) |
Status Functions 1
|
|
Current App. Version |
(00:08) |
|
Current Date |
(00:08) |
|
Current Error |
(01:22) |
|
Current Field Name |
(00:44) |
|
Current File Name |
(00:08) |
|
Current File Size |
(00:45) |
|
Current Found Count |
(01:09) |
|
Current Host Name |
(00:26) |
|
Current Language |
(00:22) |
|
Current Layout Count |
(00:26) |
|
Current Layout Name |
(00:25) |
|
Current Layout Number |
(00:27) |
|
Current Message Choice |
(01:12) |
|
Current Mode |
(01:22) |
Status Functions 2
|
|
Current Multi-User Status |
(00:45) |
|
Current Page Number |
(00:40) |
|
Current Platform |
(00:24) |
|
Current Portal Row |
(00:29) |
|
Current Printer Name |
(00:23) |
|
Current Record Count |
(00:39) |
|
Current Record Number |
(00:29) |
|
Current Repetition Number |
(00:37) |
|
Current Request Count |
(00:18) |
|
Current Screen Depth |
(00:34) |
|
Current Screen Height/Width |
(00:38) |
|
Current Script Name |
(00:25) |
|
Current Sort Status |
(00:44) |
|
Current System Version |
(00:23) |
Status Functions 3
|
|
Current Time |
(00:28) |
|
Current User Count |
(00:28) |
|
Current User Name |
(00:33) |
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)