FileMaker Pro 7 Training - FREE Tutorials

We hope you enjoyed the free lessons above. To view the complete contents including the chapters below, please purchase the CD. Alternatively you can sign up to the Online University and gain full, instant access to this, and all 450+ tutorials for only $30/£15 per month by clicking here
CLICK HERE TO BUY THIS TUTORIAL ON CD

Designing the Interface in Layout Mode
Using Layout Mode
Showing Objects on a Layout - Tuition 1
Showing Objects on a Layout - Tuition 2
Working With Rulers
Using the Status Area
Using the Status Area Fill and Pen Controls
Positioning Objects on a Layout by Alignment
Positioning Objects on a Layout with Tools
Adding and Formatting Fields
Other Basic Layout Mode Features

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

Using the Design Database Dialog
Database Terminology
Design Database Dialog Basics
Creating Fields
Working with Field Types
Creating Relationships
Making Databases Robust
Creating One-to-One Relationships
Displaying Data in Related Fields
Displaying Data in Portals
Using Auto-Enter Field Options
Using Validation Field Options
Using Storage Field Options

Putting It Together: Database Design and Layout
Creating Join Tables and Relationships
Building the Join Tables Layout
Entering Data - Tuition 1
Entering Data - Tuition 2
Finding Data

Advanced Relationships
Using Tables in Other Databases - Tuition 1
Using Tables in Other Databases - Tuition 2
Using File References
Using Self-Joins
Using Complex Relationships
Using Relationships to Find Data

Working with Value Lists
Creating Value Lists
Creating Value Lists from Other Sources
Using Value Lists Lists (Windows)
Using Value Lists (Mac OS X)
Using Value Lists for Sorting and Validation

More on Layouts
Formatting Numbers - Tuition 1
Formatting Numbers - Tuition 2
Formatting Dates
Formatting Times
Formatting Graphics
Formatting Buttons
Formatting Portals
Field Formats and Behaviors
Formatting Borders
Format Painter

Putting It Together: Improving Data Entry
Using Value Lists
Finishing Up the Layout
Restructuring the Database File

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

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

Summaries and Design
Fleshing Out the Database
Implementing the Relationships
Using Summary Fields on Layouts
Creating a Summary Layout - Tuition 1
Creating a Summary Layout - Tuition 2
Creating a Summary Layout - Tuition 3
Creating a Summary Layout - Tuition 4
Improving the Database: Joins for Searching

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

Instant Web Publishing
Instant Web Publishing Overview
Setting Up IWP

FileMaker Networking
Using a Networked Database
Sharing a FileMaker Database

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

ODBC
ODBC for Import/Export (Windows) - Tuition 1
ODBC for Import/Export (Windows) - Tuition 2
ODBC for Import/Export (Mac OS X)

Credits
Useful Links
About this Author

CLICK HERE TO BUY THIS TUTORIAL ON CD