Title Language  : 

Find a Course... Try for Free!

 

FileMaker Pro 5 Tutorials

Course Content
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 5 tutorial teaches you this application by taking you through the creation of a complete business system. With author Mark Vernon, you will build databases for customers, products, orders, invoicing, and more. You will also learn to make them all interact seamlessly. Soon you will learn how to create relational databases, reports, use scripts, calculations and functions. Get started by clicking below on any selection you want to learn about.
QT 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
Using Filemaker Pro 5
 Introduction (01:52)
 Files (04:33)
 Layouts (03:01)
 Creating and Deleting Records (01:12)
 Finding Information (05:39)
 Find Symbols (07:43)
 Sorting Information (02:15)
 Printing Information (01:05)
Contact Database
 Defining Fields (05:25)
 Types of Fields (03:42)
 Entry Options (07:32)
 Value Field (05:10)
 Changing the Layout (09:23)
 Alignment Options (04:25)
 Altering Layout Text (03:52)
 Text (06:41)
 Field Formatting (06:52)
 Creating a Layout (06:39)
 Table Views (02:38)
 Opening or importing Data (07:30)
 Create a Goto Button (03:43)
 Create a Mail Merge Letter (09:05)
 Labels (03:51)
 Making it all look pretty (17:58)
 Adding Graphics (06:58)
 Turn Graphics into Buttons (09:06)
 Simple Scripting (06:59)
Invoicing Database
 Creating the Invoicing Database (10:10)
 Tab order (01:21)
 Repetitive Fields (03:45)
 Calculations on Fields (06:10)
 Hidden Fields (00:55)
 Summary Totals (13:31)
 Lookups & One to Many Relationship (06:02)
 Client Code Lookup (02:18)
Product Database
 Value Lists (06:43)
 Importing Pictures (03:02)
 Replace Command (01:36)
 Create Price Catalog for Print (12:07)
 Exporting Data (03:32)
Line Items for Invoicing
 Product Lookups (07:10)
 One to One Relationship (06:32)
 Create and use Portals (05:15)
 Calculations across Databases (01:44)
 Product Lookup (Again!) (01:00)
 Modifying Portals (04:46)
 Script for Printing Invoice (01:52)
Reports
 Unpaid Invoices Report (05:48)
 Line Items Report (09:52)
 Exporting Summary Information (06:12)
 Copy Data to another Application (00:37)
Refining your databases
 Create a Navigation Window (04:11)
 Startup Scripts and Zoom Window (05:13)
 Sharing Common Data (08:33)
 Using a Close Button to Close Windows (01:30)
 Portals and Go to Related Record (07:56)
 Sort Related Records (00:53)
 Self Join Relationship (04:11)
Exercises
 Bills/Purchase Database (08:36)
 Contact History Database (03:47)
 Cashbook Database (15:54)
Sharing Databases
 Sharing your databases (05:21)
 Filemaker on the Web (14:59)
 Access Priveleges (05:08)
Miscellaneous Stuff
 Backup / Save a Copy As (01:25)
 Recovering Damaged Databases (02:15)
 Field Borders (01:24)
 Filemaker Pro 5 Preferences (06:40)
Fun with Scripting and Functions
 Introduction to Scripting & Functions (03:02)
 Copying Scripts (02:13)
 External Scripts (02:07)
 If Then Else Script (08:38)
 If Then Else in Calculations (02:11)
 Loop (05:58)
 Capture On/Off (01:11)
 Open Web and Send Email (05:27)
 Import/Export Scripts (02:34)
 Backup Script (05:03)
Credits
 About the Author (05:03)


Email this Page     Send us Feedback
Tutorial Information / Pricing
Title: FileMaker Pro 5
Author: Mark Vernon
SKU: 33104
ISBN: 1889347876
Duration: 7 hrs / 80 Lessons
Compatibility: Win XP, 2000, 98, NT, Mac OS X, OS 9

Online University Access all our Training for only 30
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)
SIGNUP LEARN MORE »

Get this title on CD
Single User: US$ 99.95 - Purchase CD / Add to Cart

Multi User (10): US$ 500.00 - Purchase CD / Add to Cart

Select Bandwidth
Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

Select:

Select Category

Special Groups

Publisher or Products