Tutorials and Online Training Videos

FileMaker Pro 6 Tutorial


FileMaker Pro 6 is a powerful cross-platform database application that takes the headache out of organizing your business and information. With FileMaker Pro 6, you can create powerful relational databases that will allow you to produce invoices, form letters, client contact databases, purchase order systems, and much more. In this Virtual Training Company tutorial, master trainer and FileMaker developer David Bylund will not only teach you to use FileMaker Pro 6 to work with existing databases, but will also help you learn to create your own customized databases. He begins by going over the basics of FileMaker, such as screen orientation and preferences. He then guides you into the use of databases, including creating new records and how to find text, numbers, and ranges. You will learn how to create a database to fit your needs by learning layout options, formatting, and creating reports. You will even learn about relational databases, and will be introduced to calculations and scripts, so that you will be able to automate many tasks. To get started with FileMaker Pro 6, just click one of the movie topics below.

Introduction

Why FileMaker Is Powerful
What Is & Is Not Covered
Previous Versions & Help

FileMaker Basics

About Databases
Screen Orientation - Part 1
Screen Orientation - Part 2
Working with Files - Part 1
Working with Files - Part 2
Records and Fields - Part 1
Records and Fields - Part 2
Modes - Part 1
Modes - Part 2
Layouts
Preferences - Application
Preferences - Document

Using Databases

Viewing Records
Adding and Deleting Records
Entering Data - Part 1
Entering Data - Part 2
Moving Data
Value Lists
Inserting Data
Multimedia - Part 1
Multimedia - Part 2
Replacing Data - Part 1
Replacing Data - Part 2
Spell Checking
Find Basics - Part 1
Find Basics - Part 2
Finding Text - Part 1
Finding Text - Part 2
Finding Numbers and More
Finding Ranges
Omitting, Finding Empty
Multiple Find Criteria
Find & Omit
Extend & Constrain
Find & Replace
Sorting - Part 1
Sorting - Part 2
Contextual Sorting
Printing
Preview Mode

Creating Databases for You

Planning Your Database
New Database & Templates
Import from File
Import Actions
Import Field Mapping
Import Continued
Import from Folder - Part 1
Import from Folder - Part 2
Defining Fields
Auto-Enter Options
Validation Options
Repeating Fields & Indexing
Global Fields
Summary Fields
Calculation Fields
Changing Field Definitions

Layouts and Reports

Layout Strategies
Layout Mode Overview
Managing Layouts
Layout Templates
Standard Form
Columnar List - Part 1
Columnar List - Part 2
Columnar List - Part 3
Table
Labels & Envelopes - Part 1
Labels & Envelopes - Part 2
Labels & Envelopes - Part 3
Custom Layout
Layout Parts - Part 1
Layout Parts - Part 2
Fields - Part 1
Fields - Part 2
Merge Fields
Standard & Merge Fields
Layout Objects - Part 1
Layout Objects - Part 2
Adding Objects - Part 1
Adding Objects - Part 2
Fill and Line - Part 1
Fill and Line - Part 2
Fill and Line - Part 3
Text Formatting - Part 1
Text Formatting - Part 2
Field Formatting - Part 1
Field Formatting - Part 2
Field Formatting - Part 3
Field Format - Part 1
Field Format - Part 2
Field Borders
Format Painter & Show
Arranging Objects - Part 1
Arranging Objects - Part 2
Aligning Objects
Forward/Back, Group, Lock
Tab Order
Value Lists - Part 1
Value Lists - Part 2
Value Lists - Part 3
Value Lists - Part 4
Layout Clean-up - Part 1
Layout Clean-up - Part 2
Printing Layout - Part 1
Printing Layout - Part 2
Printing Layout - Part 3
Sliding/Printing - Part 1
Sliding/Printing - Part 2
Non-Printing Objects
Page Numbering
Subsummary Part - Part 1
Subsummary Part - Part 2

Relational Databases

Related Databases - Part 1
Related Databases - Part 2
Terminology
Tips & Notes
Planning
One-to-Many - Part 1
One-to-Many - Part 2
One-to-Many - Part 3
Portals - Part 1
Portals - Part 2
Many-to-Many - Part 1
Many-to-Many - Part 2
Many-to-Many - Part 3
Many-to-Many - Part 4
Self-Joining - Part 1
Self-Joining - Part 2
Related Field in Layout
Data Conduit - Part 1
Data Conduit - Part 2
Data Conduit - Part 3
Lookups - Part 1
Lookups - Part 2

Introducing Calculations

Using Calculations
Specify Calculation Dialog
Syntax & Conventions
Text Examples - Part 1
Text Examples - Part 2
Text Examples - Part 3
Number Examples - Part 1
Number Examples - Part 2
Aggregate & Summary - 1
Aggregate & Summary - 2
Logical Examples
Status Examples - Part 1
Status Examples - Part 2

Introducing Scripts

What Are Scripts
Scriptmaker - Part 1
Scriptmaker - Part 2
Script Steps
Planning Scripts
Storing Settings - Part 1
Storing Settings - Part 2
Storing Settings - Part 3
Buttons - Part 1
Buttons - Part 2
Advanced Script - Part 1
Advanced Script - Part 2
Advanced Script - Part 3
Advanced Script - Part 4
Advanced Script - Part 5
Advanced Script - Part 6
Advanced Script - Part 7
Advanced Script - Part 8
Advanced Script - Part 9

Creating Databases for Others

Access Privileges - Part 1
Access Privileges - Part 2
Access Privileges - Part 3
Sharing Files on Network

Credits

About the Author


Related Books on FileMaker Pro 6







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