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