Tutorials and Online Training Videos

FileMaker Pro 8: Intermediate Tutorial


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.

* 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.

Introduction

About John Mark Osborne
FileMaker 8 Family of Products
About the Tutorial Series
Why an Invoicing Example?

Interface Design

Screen Size
Background
Tabs / Bars / Buttons
Field Outlines
Sub-Areas
Finishing Touches pt. 1
Finishing Touches pt. 2
Tabbed Layouts pt. 1
Tabbed Layouts pt. 2
List View
List View without Status Area
Design Considerations

Relationships

Relational Theory
Data Modeling
Entity-Relationship Diagrams
Creating a Relationship
Related Fields pt. 1
Related Fields pt. 2
Many-To-Many Relationship pt. 1
Many-To-Many Relationship pt. 2
Creating a Portal
Portal Improvements
Two-Way Relationships
Completing the Interface

Table Occurrences

What are Table Occurrences? pt. 1
What are Table Occurrences? pt. 2
Filtered Portals
Calculated Portals
Date Range Portals pt. 1
Date Range Portals pt. 2
Self-Relationships
Table Occurrence Tricks
Conditional Value Lists pt. 1
Conditional Value Lists pt. 2
Scripts and Calculations pt. 1
Scripts and Calculations pt. 2
Organizing the Graph pt. 1
Organizing the Graph pt. 2

Security

Complete Approach pt. 1
Complete Approach pt. 2
Accounts
Privilege Sets pt. 1
Privilege Sets pt. 2
Extended Privileges
No Access Layout
Overdue Invoices pt. 1
Overdue Invoices pt. 2
Capturing Errors pt. 1
Capturing Errors pt. 2
Tracking Accounts pt. 1
Tracking Accounts pt. 2
Random Passwords
Override Account pt. 1
Override Account pt. 2

Scripting

Menu Button
Script Parameters
Find Rolodex
Dynamic Messages
Duplicate Invoices
Dynamic Layouts
Print Invoice Layout pt. 1
Print Invoice Layout pt. 2
Print Invoice Script
Inventory Control
Transitions

Calculations

Grand Total pt. 1
Grand Total pt. 2
Basic Phone Filter pt. 1
Basic Phone Filter pt. 2
Phone Number Validation
Remove Text Formatting
Overdue Invoice Display
Parsing Text pt. 1
Parsing Text pt. 2
Field Level Tracking pt. 1
Field Level Tracking pt. 2
Parent and Child Tracking

FileMaker Pro Advanced

Advanced Features
Recover
Configuring Plug-Ins
Plug-In Examples pt. 1
Plug-In Examples pt. 2
Database Design Report
Developer Utilities
File Maintenance
Debugging Script pt. 1
Debugging Script pt. 2
Custom Functions pt. 1
Custom Functions pt. 2
Custom Menus pt. 1
Custom Menus pt. 2

Multi-User Solutions

Setup
FileMaker Server Sharing
Record Locking
Testing for Locked Records
Looping and Replace Scripts
Marking Records pt. 1
Marking Records pt. 2
Save a Found Set

Working with John Mark Osborne

Free Resources
Training
Consulting and Meta-Consulting
Solutions
Contacting Me


Related Books on FileMaker Pro 8: Intermediate







Save $80 on the
DROID BIONIC
by Motorola with Verizon Wireless service for less than from Verizon Wireless directly.
Save $80 on DROID BIONIC
More Cell Phone Discounts