FileMaker Pro 7 Tutorial

Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left

FileMaker 7 Tutorial Intro
Tutorial Intro
FileMaker 7 Overview
The FileMaker Family Explained
Starter Solutions

Entering Data in Browse Mode
Starting to use FileMaker
The Browse Mode Menus Explained
Using a Data Layout - with surrounding issues
Using the Status Area in Browse Mode
Entering Text
Working with Container Fields
Inserting Further Data Using the Insert Menu
Make use of the Records Menu & Auto-Entering Data
Validation - Overview
Replacing Data
Using the Browse Mode View Menu
Using the Toolbars
Sorting Data in FileMaker

Printing and Presenting Data in Preview Mode
Using the Status Area
Sliding Fields Explored
Printing Labels
Print Options - Win
Print Options - Mac

We hope you enjoyed the FREE lessons above. To view the complete contents, including the chapters below, please purchase the CD.
CLICK HERE TO BUY THIS CD

Designing the Interface in Layout Mode
Using Layout Mode
Showing Objects on a Layout - Lesson 1
Showing Objects on a Layout - Lesson 2
Working With Rulers
Using the Status Area
Using the Status Area Fill and Pen Controls
Positioning Objects on a Layout by Alignment and with Tools
How to Add and Format Fields
Further Simple Layout Mode Features

Finding Data in Find Mode
Chapter Overview
Constraining and Extending Found Sets
Using Multiple Find Criteria
Using Find Requests (OR)
Using the Status Area and Omitting Records
Finding Text - Lesson 1
Finding Text - Lesson 2
Finding Numbers
Finding Dates
Finding Times

Using the Design Database Dialog
Database (D/B) Terminology
Design D/B Dialog Basics
The Creation of Fields
Using Field Types
The Creation of Relationships Explained
Making D/B Robust
How to Create One-to-One Relationships
Displaying Data in Related Fields, Portals
Using Auto-Enter, Validation Field Options
Working with Storage Field Options

Putting It Together: Database Design and Layout
How to Create Join Tables and Relationships
Building the Join Tables Layout
Entering Data - Lesson 1
Entering Data - Lesson 2
Finding Data

Advanced Relationships
Using Tables in Other Databases - Lesson 1
Using Tables in Other Databases - Lesson 2
Using File References and Self-Joins
Using Complex Relationships
How to Use Relationships for Finding Data

Working with Value Lists
Creating Value Lists and from other sources
Using Value Lists - PC and Mac
Using Value Lists for Sorting and Validation

More on Layouts
Formatting:
• Numbers - Lesson 1
• Numbers - Lesson 2
• Dates
• Times
• Graphics
• Buttons
• Portals
• Borders
Field Formats and Behaviours
Using the Format Painter

Putting It Together: Improving Data Entry
Working with Value Lists
Finishing Up the Layout
How to Restructure the Database File

Working with Functions and Calculations
Using the Specify Calculation Dialog - Lesson 1
Using the Specify Calculation Dialog - Lesson 2
Working with Functions
Specifying Calculation Storage
Functions Explained:
• Aggregate
• Date
• Design
• Get
• Logical Functions: If/Case/Choose
• Logical Functions: Let
• Number
• Repeating
• Summary
• Text - Lesson
• Text - Lesson
• Text Formatting
• Time and Timestamp
• Trigonometric/Custom/External

Introducing Scripts
ScriptMaker Overview
Using the ScriptMaker Edit Window
Working with Script Parameters
Running Scripts Automatically
Control
Navigation - Lesson 1
Navigation - Lesson 2
Editing
Fields
Records
Found Sets
Windows
Files
Accounts/Spelling
Open Menu Item/Misc.

Summaries and Design
Cleaning the Database
How to Implement the Relationships
Using Summary Fields on Layouts
The Creation of a Summary Layout - Lesson 1
The Creation of a Summary Layout - Lesson 2
The Creation of a Summary Layout - Lesson 3
The Creation of a Summary Layout - Lesson 4
Improving the D/B: Joins for Searching

Setting Up Security
The Unified Security Model Explained
Setting Up Accounts and Privileges

Instant Web Publishing
Chapter Overview
Setting Up IWP

FileMaker Networking
How to Use a Networked Database
How to Share a FileMaker Database

Importing and Exporting Data
Importing Data - Lesson 1
Importing Data - Lesson 2
Importing Options
Exporting Data

ODBC
ODBC for Import/Export - Mac and PC - Lesson 1
ODBC for Import/Export - Mac and PC - Lesson 2
ODBC for Import/Export - Mac and PC - Lesson 3

Credits
Useful Links
Author Details