Tutorials and Online Training Videos

FileMaker Pro 8: Beginner Tutorial


FileMaker Pro 8 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 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 begin learning today, simply click on one of the FileMaker Pro 8: Beginner lessons.

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 one 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?
What is a Database?
Planning your Solution

Creating a Database

Templates
New Empty File
Creating Fields
Housekeeping Fields
Modifying Fields
Organizing Fields
Other Tabs

Working with the Database

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

Finding and Sorting

Basic Find
How the Index Works pt. 1
How the Index Works pt. 2
New Requests
Symbols pt. 1
Symbols pt. 2
Constrain and Extend
Found Sets without Find Mode
Sorting Records
New Window

Modifying Layouts

Status Area
Arrow Tool
Text Tool
Line Tool
Rectangle Tool

Modifying Layouts Advanced

Tab Control Setup
Tab Control Creation
Field/Control and Lists
Field/Control and Others
Parts Overview
Parts Creation
Layouts Menu
Format Menu
Arrange Menu
View Menu

Working with Container Fields

Creating Container Fields
Inserting a Picture
Inserting a PDF
Insert Other Files
Miscellaneous

Auto-Entry

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

Validation

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

Printing

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

Scripting and Calculations

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

Importing and Exporting

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

Miscellaneous Features

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

Working with John Mark Osborne

Free Resources
Training
Consulting and Meta-Consulting
Solutions
Contact Information


Related Books on FileMaker Pro 8: 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