|
Getting Started | What is FileMaker Pro?
What is a database?
Starting up the Program
Displaying the Program elements
Changing the Program Setting
Quick Tour of FileMaker Pro
Browse, Layout, Find and Preview Mode
Standard Toolbars
Navigating the Three Views
Quitting FileMaker Pro |
|
Creating a Database | Starting a new Database
Creating a new file
Defining the fields
Applying entry options
Field types |
|
Layout | Working With Positioning and Layout Tools
Creating Calculation and Summary Fields
Printing the Database
Standard layouts
Layout tips (usability)
Simple list
Tables
Labels
Envelopes |
|
Advanced Layouts | Creating a Summary Report
Creating Sub and Grand Totals
Using Dynamic Symbols
Using the New Layout/Report Assistant |
|
Import, Export, copy Database | Importing Data
Exporting data
Copy as clone
Copy compressed |
|
Calculation fields | Totals
If..then
Text functions
Date and time functions |
|
Exploring a Relational Database | Creating a Relational Database
Creating the Master File
Creating a Related File
Relationships versus Lookups
One to One and One to Many relationships
Portals
Internal Relationships |
|
Scripting | Basic scripts
Find Sort Print
Buttons
Create a "toolbar" |
|
Advanced Scripting | Script nesting
If...then scripts
Looping |
|
Security | Sharing files
Passwords
Protecting fields
Protecting layouts
Restricting actions |
