FileMaker Pro 7

Introducing FileMaker 7

About this Tutorial
FileMaker 7 Overview
The FileMaker Family
Starter Solutions

Entering Data in Browse Mode

Getting Started with FileMaker
The Browse Mode Menus
Working with a Data Layout
Using the Status Area in Browse Mode
Entering Text
Using Container Fields
Inserting Other Data with the Insert Menu
Using the Records Menu and Auto-Entering Data
Validation
Replacing Data
Using the Browse Mode View Menu
Using the Toolbars
Sorting Data

Printing and Presenting Data in Preview Mode

Using the Status Area
Sliding Fields
Printing Labels
Print Options on Windows
Print Options on Macintosh

Designing the Interface in Layout Mode

Using Layout Mode
Showing Objects on a Layout pt. 1
Showing Objects on a Layout pt. 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 pt. 1
Finding Text pt. 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 pt. 1
Entering Data pt. 2
Finding Data

Advanced Relationships

Using Tables in Other Databases pt. 1
Using Tables in Other Databases pt. 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 pt. 1
Formatting Numbers pt. 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 pt. 1
Using the Specify Calculation Dialog pt. 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 pt. 1
Text Functions pt. 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 pt. 1
Navigation pt. 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 pt. 1
Creating a Summary Layout pt. 2
Creating a Summary Layout pt. 3
Creating a Summary Layout pt. 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 pt. 1
Importing Data pt. 2
Importing Options
Exporting Data

ODBC

ODBC for Import/Export (Windows) pt. 1
ODBC for Import/Export (Windows) pt. 2
ODBC for Import/Export (Mac OS X)

Credits

Useful Links
About this Author