Home
Username:
Password:
FileMaker Pro 8: Intermediate Training

CD Contents For This Title

 All the chapters and lesson contents of FileMaker Pro 8: Intermediate are listed below.

To help you evaluate our training, we have made some of the tutorials for FileMaker Pro 8: Intermediate freely available. Click on any of the linked lesson listings below to preview FREE!

FileMaker Pro is powerful enough to handle most database jobs yet easy enough to create simple solutions in minutes. This practical \"how to\" course by FileMaker expert, John Mark Osborne, starts from intermediate level and uses a single invoicing example to demonstrate FileMaker Pro features and techniques including interface design, relational database design, relationship operators, multiple predicates, table occurrences, portal filters, security, scripts, calculations, FileMaker Pro Advanced, multi-user solutions, record locking, multi-keys and deleting duplicate records. Examples of the invoice file are provided at every stage of the creation process so the user can easily review one section without starting from the beginning. To being learning FileMaker Pro 8 today, simply click on one of the links below.

The completed invoicing solution included on the beginner, intermediate and advanced FileMaker Pro 8 training is provided as a visual goal. Upon completion of all three titles, you will have created the exact same invoicing solution. If you would like to purchase the completed invoicing solution, please visit the www.databasepros.com web site.

* Most techniques used in these videos are applicable to both FileMaker 8 and 7. Substitute techniques for FileMaker 7 users will be discussed when necessary.

** This tutorial is part two in a 3-part FileMaker Pro 8 series.


Choose your media type:


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.

Introduction
  About John Mark Osborne (01:44)
  FileMaker 8 Family of Products (04:49)
  About the Tutorial Series (04:14)
  Why an Invoicing Example? (03:03)
Interface Design
  Screen Size (05:29)
  Background (06:18)
  Tabs / Bars / Buttons (05:23)
  Field Outlines (06:12)
  Sub-Areas (06:58)
  Finishing Touches pt. 1 (06:22)
  Finishing Touches pt. 2 (02:29)
  Tabbed Layouts pt. 1 (05:46)
  Tabbed Layouts pt. 2 (03:46)
  List View (06:21)
  List View without Status Area (06:35)
  Design Considerations (03:42)
Relationships
  Relational Theory (04:31)
  Data Modeling (05:39)
  Entity-Relationship Diagrams (05:56)
  Creating a Relationship (04:40)
  Related Fields pt. 1 (04:31)
  Related Fields pt. 2 (04:37)
  Many-To-Many Relationship pt. 1 (05:11)
  Many-To-Many Relationship pt. 2 (02:55)
  Creating a Portal (06:33)
  Portal Improvements (06:47)
  Two-Way Relationships (05:14)
  Completing the Interface (04:53)
Table Occurrences
  What are Table Occurrences? pt. 1 (05:09)
  What are Table Occurrences? pt. 2 (04:53)
  Filtered Portals (07:21)
  Calculated Portals (06:50)
  Date Range Portals pt. 1 (05:51)
  Date Range Portals pt. 2 (03:14)
  Self-Relationships (06:49)
  Table Occurrence Tricks (06:52)
  Conditional Value Lists pt. 1 (03:59)
  Conditional Value Lists pt. 2 (03:45)
  Scripts and Calculations pt. 1 (04:37)
  Scripts and Calculations pt. 2 (03:32)
  Organizing the Graph pt. 1 (05:06)
  Organizing the Graph pt. 2 (03:22)
Security
  Complete Approach pt. 1 (04:42)
  Complete Approach pt. 2 (04:41)
  Accounts (05:31)
  Privilege Sets pt. 1 (04:20)
  Privilege Sets pt. 2 (06:20)
  Extended Privileges (03:14)
  No Access Layout (04:45)
  Overdue Invoices pt. 1 (04:32)
  Overdue Invoices pt. 2 (04:24)
  Capturing Errors pt. 1 (04:54)
  Capturing Errors pt. 2 (03:52)
  Tracking Accounts pt. 1 (05:42)
  Tracking Accounts pt. 2 (02:02)
  Random Passwords (05:45)
  Override Account pt. 1 (06:17)
  Override Account pt. 2 (01:46)
Scripting
  Menu Button (07:15)
  Script Parameters (04:40)
  Find Rolodex (06:55)
  Dynamic Messages (07:04)
  Duplicate Invoices (07:09)
  Dynamic Layouts (03:39)
  Print Invoice Layout pt. 1 (06:48)
  Print Invoice Layout pt. 2 (02:56)
  Print Invoice Script (04:14)
  Inventory Control (07:16)
  Transitions (05:43)
Calculations
  Grand Total pt. 1 (06:39)
  Grand Total pt. 2 (04:36)
  Basic Phone Filter pt. 1 (07:12)
  Basic Phone Filter pt. 2 (00:49)
  Phone Number Validation (04:34)
  Remove Text Formatting (07:00)
  Overdue Invoice Display (05:33)
  Parsing Text pt. 1 (04:28)
  Parsing Text pt. 2 (06:22)
  Field Level Tracking pt. 1 (04:41)
  Field Level Tracking pt. 2 (04:58)
  Parent and Child Tracking (03:53)
FileMaker Pro Advanced
  Advanced Features (04:03)
  Recover (05:36)
  Configuring Plug-Ins (06:07)
  Plug-In Examples pt. 1 (04:05)
  Plug-In Examples pt. 2 (04:17)
  Database Design Report (03:49)
  Developer Utilities (06:50)
  File Maintenance (02:56)
  Debugging Script pt. 1 (06:21)
  Debugging Script pt. 2 (03:58)
  Custom Functions pt. 1 (05:40)
  Custom Functions pt. 2 (06:37)
  Custom Menus pt. 1 (06:25)
  Custom Menus pt. 2 (07:28)
Multi-User Solutions
  Setup (06:53)
  FileMaker Server Sharing (05:14)
  Record Locking (05:20)
  Testing for Locked Records (06:27)
  Looping and Replace Scripts (05:07)
  Marking Records pt. 1 (04:49)
  Marking Records pt. 2 (05:05)
  Save a Found Set (07:32)
Working with John Mark Osborne
  Free Resources (03:40)
  Training (02:32)
  Consulting and Meta-Consulting (01:52)
  Solutions (06:13)
  Contacting Me (00:38)

Title Information / Pricing

Title: FileMaker Pro 8: Intermediate
Author: John Mark Osborne
SKU: 33671
ISBN: 1-933736-07-0
Release Date: 2006-02-21
Price:
Duration: 11 hrs / 108 lessons
Work Files: Yes
Captions: No
Compatibility: Vista/XP/2000, OS X, Linux
QuickTime 7

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)


Related Titles

 

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. The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

* Bandwidth selection only available for QuickTime versions of tutorials, not Flash.


Select:

Now Shipping

Autodesk Sketchbook Pro 6 for Desktop and iPad

Autodesk Sketchbook Pro 6 for Desktop and iPad

View the first three chapters of this tutorial FREE!


Client Testimonials

I'm 300% satisfied with the training material you have on site right now. My wife has been able to study many things from your site, Microsoft...

Luis Hernandez