Home     Introduction    Advanced

FileMaker Pro

 
Title Introduction to FileMaker
Length Two Days  
Topics    

What is a database?

Fields, records, and tables

Parts of the screen

Moving within a record

Moving between records

Modes

Define fields

Sorting

Adding new records

Layouts

Copying parts of a record

Finding records

Working in the layout screen  

Using rulers

Creating layouts

Aligning field blocks

Placing text on a layout

Drawing lines on a layout

Making boxes

Formatting multiple selections

Sliding objects together

Creating a database

Booleans

Importing data

Buttons

Advanced formatting

Lookups                      

Establishing tab order

Formulas

Order of operations

Creating a summary report

Creating a grand summary

Useful items on a printed page

Changing the setup of the page

Printing

Printing mailing labels
Title Advanced FileMaker
Length Two Days  
Topics    

Flat-File vs. relational databases

Review of sorting and finding

Calculated fields

The Round function

The IF function

Logical operations

Text operators

Nested IF statements

Today's Date calculation

The PMT function

Repeating fields

The SUM Function

The PROPER Function

The Right Function

The COUNT function

The AVERAGE function

The MAX function

The MIN function

The DAYNAME function

The MONTHNAME function

The YEAR function

Summary reports

Layout options

Rulers

Serial numbers

Importing records (from Excel)

Exporting records (to Excel)

Scripting

Creating buttons

Lookups

Changing tab order

Preferences

Passwords

RETURN TO TOP