United States
FileMaker Pro 3/4 Tutorials
Online Contents For This Course
We have made some of the video tutorials for FileMaker Pro 3/4 freely available to help you evaluate our training.
Click on any of the linked lesson listings below to preview FREE!
Course Description
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 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) | ||
Email this Page
Send us FeedbackCourse Information
| Course: | FileMaker Pro 3/4 |
| Author: | Mark Vernon |
| SKU: | 33016 |
| ISBN: | 1889347450 |
| Release Date: | 2000-01-03 |
| Duration: | 12 hrs / 254 tutorials |
| Work Files: |
Yes |
| Captions: | No |
Subscription / Purchase Information
This course is just part of the entire VTC collection of over 650 courses, 70,000 video tutorials (14,250+ free), available to you for just $30 a month.
View All Courses Subscribe Learn More