Become a member

Online Access to 1000+ Courses!

FileMaker Pro 5 Course

Author : Mark Vernon

7hrs (78 Lessons) 1999-12-03

This Course can only be played using a subscription. You can play only first 3 chapters for free. Click Here to avail a subscription
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.

Transcription not available

Course: FileMaker Pro 5
Author: Mark Vernon
SKU: 33104
ISBN: 1889347876
Work Files: Yes
Captions: No
Subject: Databases
The first 3 chapters of courses are available to play for FREE (first chapter only for QuickStart! and MasterClass! courses). Just click on the movie link to play a lesson.

Download WorkFiles

Pricing & availability

Lifetime online access to this course

US$ 39.00

Download for offline access

US$ 79.95

Subscribe to 1000+ courses

Starting at $30/month

Course outline

Using Filemaker Pro 5

Introduction (01:52)

Files (04:34)

Layouts (03:02)

Creating and Deleting Records (01:13)

Finding Information (05:40)

Find Symbols (07:44)

Sorting Information (02:16)

Printing Information (01:05)

Contact Database

Defining Fields (05:25)

Types of Fields (03:43)

Entry Options (07:32)

Value Field (05:11)

Changing the Layout (09:23)

Alignment Options (04:25)

Altering Layout Text (03:53)

Text (06:41)

Field Formatting (06:53)

Creating a Layout (06:40)

Table Views (02:38)

Opening or importing Data (07:31)

Create a Goto Button (03:44)

Create a Mail Merge Letter (09:06)

Labels (03:52)

Making it all look pretty (17:59)

Adding Graphics (06:58)

Turn Graphics into Buttons (09:06)

Simple Scripting (06:59)

Invoicing Database

Creating the Invoicing Database (10:11)

Tab order (01:22)

Repetitive Fields (03:45)

Calculations on Fields (06:10)

Hidden Fields (00:56)

Summary Totals (13:31)

Lookups & One to Many Relationship (06:02)

Client Code Lookup (02:19)

Product Database

Value Lists (06:43)

Importing Pictures (03:02)

Replace Command (01:36)

Create Price Catalog for Print (12:07)

Exporting Data (03:33)

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:01)

Modifying Portals (04:46)

Script for Printing Invoice (01:52)

Reports

Unpaid Invoices Report (05:49)

Line Items Report (09:52)

Exporting Summary Information (06:13)

Copy Data to another Application (00:38)

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:31)

Portals and Go to Related Record (07:56)

Sort Related Records (00:53)

Self Join Relationship (04:12)

Exercises

Bills/Purchase Database (08:36)

Contact History Database (03:48)

Cashbook Database (15:55)

Sharing Databases

Sharing your databases (05:21)

Filemaker on the Web (15:00)

Access Priveleges (05:09)

Miscellaneous Stuff

Backup / Save a Copy As (01:25)

Recovering Damaged Databases (02:15)

Field Borders (01:25)

Filemaker Pro 5 Preferences (06:41)

Fun with Scripting and Functions

Introduction to Scripting & Functions (03:03)

Copying Scripts (02:13)

External Scripts (02:08)

If Then Else Script (08:38)

If Then Else in Calculations (02:12)

Loop (05:59)

Capture On/Off (01:12)

Open Web and Send Email (05:27)

Import/Export Scripts (02:35)

Backup Script (05:04)

Credits

About the Author (05:04)