FileMaker Pro 5

Using Filemaker Pro 5

Introduction
Files
Layouts
Creating and Deleting Records
Finding Information
Find Symbols
Sorting Information
Printing Information

Contact Database

Defining Fields
Types of Fields
Entry Options
Value Field
Changing the Layout
Alignment Options
Altering Layout Text
Text
Field Formatting
Creating a Layout
Table Views
Opening or importing Data
Create a Goto Button
Create a Mail Merge Letter
Labels
Making it all look pretty
Adding Graphics
Turn Graphics into Buttons
Simple Scripting

Invoicing Database

Creating the Invoicing Database
Tab order
Repetitive Fields
Calculations on Fields
Hidden Fields
Summary Totals
Lookups & One to Many Relationship
Client Code Lookup

Product Database

Value Lists
Importing Pictures
Replace Command
Create Price Catalog for Print
Exporting Data

Line Items for Invoicing

Product Lookups
One to One Relationship
Create and use Portals
Calculations across Databases
Product Lookup (Again!)
Modifying Portals
Script for Printing Invoice

Reports

Unpaid Invoices Report
Line Items Report
Exporting Summary Information
Copy Data to another Application

Refining your databases

Create a Navigation Window
Startup Scripts and Zoom Window
Sharing Common Data
Using a Close Button to Close Windows
Portals and Go to Related Record
Sort Related Records
Self Join Relationship

Exercises

Bills/Purchase Database
Contact History Database
Cashbook Database

Sharing Databases

Sharing your databases
Filemaker on the Web
Access Priveleges

Miscellaneous Stuff

Backup / Save a Copy As
Recovering Damaged Databases
Field Borders
Filemaker Pro 5 Preferences

Fun with Scripting and Functions

Introduction to Scripting & Functions
Copying Scripts
External Scripts
If Then Else Script
If Then Else in Calculations
Loop
Capture On/Off
Open Web and Send Email
Import/Export Scripts
Backup Script