Tutorials and Online Training Videos

FileMaker Pro 9: Beginner 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 beginner level and uses a single invoicing example to demonstrate all the features in FileMaker Pro 7, 8, 8.5 and 9 including: field creation, finding, sorting, layout mode, container fields, auto-entry, validation, printing, scripts, calculations, importing, exporting and interface design. 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 today, simply click on one of the FileMaker Pro 9: Beginner links.

The completed invoicing solution included on the beginner, intermediate (soon-to-be-released) and advanced (soon-to-be-released) FileMaker Pro 9 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 one in an upcoming 3-part FileMaker Pro 9 series.

Introduction

About John Mark Osborne
FileMaker 9 Family of Products pt. 1
FileMaker 9 Family of Products pt. 2
New FileMaker Pro 9 Features pt. 1
New FileMaker Pro 9 Features pt. 2
New FileMaker Pro 9 Features pt. 3
New FileMaker Pro 9 Advanced Features pt. 1
New FileMaker Pro 9 Advanced Features pt. 2
About the Tutorial Series pt. 1
About the Tutorial Series pt. 2
Why an Invoicing Solution? pt. 1
Why an Invoicing Solution? pt. 2
What is a Database? pt. 1
What is a Database? pt. 2
Planning Your Solution

Creating a Database

Templates
New Empty File
Creating Fields
Housekeeping Fields pt. 1
Housekeeping Fields pt. 2
Modifying Fields
Organizing Fields
Other Tabs

Working With the Database

Data Entry pt. 1
Data Entry pt. 2
Status Area
The Four Modes
Records Menu pt. 1
Records Menu pt. 2
Previewing Pages
New Layout pt. 1
New Layout pt. 2

Finding & Sorting

Basic Find
How the Index Works pt. 1
How the Index Works pt. 2
New Requests
Symbols pt. 1
Symbols pt. 2
Wildcards & More On Symbols pt. 1
Wildcards & More On Symbols pt. 2
Found Sets Without Find Mode
Constrain & Extend
Sorting Records
New Window

Modifying Layouts

Status Area
Arrow Tool
Text Tool pt. 1
Text Tool pt. 2
Line Tool
Rectangle Tool

Modifying Layouts Advanced

Tab Control pt. 1
Tab Control pt. 2
Field Control pt. 1
Field Control pt. 2
Parts pt. 1
Parts pt. 2
Layout Menu pt. 1
Layout Menu pt. 2
Format Menu pt. 1
Format Menu pt. 2
Arrange Menu pt. 1
Arrange Menu pt. 2
View Menu pt. 1
View Menu pt. 2

Working With Container Fields

Creating Container Fields
Inserting a Picture
Inserting a PDF pt. 1
Inserting a PDF pt. 2
Insert Other Files
Miscellaneous

Auto-Entry

Serial Numbers pt. 1
Serial Numbers pt. 2
Value from Last Visited
Calculated Auto-Enter pt. 1
Calculated Auto-Enter pt. 2
Lookups pt. 1
Lookups pt. 2

Validation

Strict Data Type
Not Empty / Unique / Existing
Ranges
Custom Messages pt. 1
Custom Messages pt. 2
Always vs. Data Entry

Printing

Print Layouts pt. 1
Print Layouts pt. 2
Contact List pt. 1
Contact List pt. 2
Labels pt. 1
Labels pt. 2
Merge Letters pt. 1
Merge Letters pt. 2
Merge Letters pt. 3
Sub-Summary Reports pt. 1
Sub-Summary Reports pt. 2
Improved Contact List pt. 1
Improved Contact List pt. 2

Scripting & Calculations

Definition of a Script pt. 1
Definition of a Script pt. 2
Definition of a Script pt. 3
Definition of a Calculation pt. 1
Definition of a Calculation pt. 2
Navigation pt. 1
Navigation pt. 2
Advanced Navigation pt. 1
Advanced Navigation pt. 2
Advanced Navigation pt. 3
Open Script pt. 1
Open Script pt. 2
Recreate the Status Area
Billing or Shipping Labels pt. 1
Billing or Shipping Labels pt. 2
Billing or Shipping Labels pt. 3
Birthdays pt. 1
Birthdays pt. 2

Importing & Exporting

Import & Export Defined
Importing FileMaker Files pt. 1
Importing FileMaker Files pt. 2
Importing a Folder
Data Sources pt. 1
Data Sources pt. 2
Exporting Files
Group By
Export to HTML
Importing Schema pt. 1
Importing Schema pt. 2

Miscellanneous Features

Global Field pt. 1
Global Field pt. 2
Repeating Field pt. 1
Repeating Field pt. 2
Furigana
Spell Checking
Find & Replace
Engraving & Embossing pt. 1
Engraving & Embossing pt. 2
Send Email pt. 1
Send Email pt. 2
Improved Print Script
Tooltips pt. 1
Tooltips pt. 2

Working With John Mark Osborne

Free Resources pt. 1
Free Resources pt. 2
Training
Consulting & Meta-Consulting
Solutions
Contacting John Mark Osborne


Related Books on FileMaker Pro 9: Beginner







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