FileMaker Pro 11 Essentials

Introduction
Welcome
Understanding the FileMaker family
Using the FileMaker Quick Start screen
Using the exercise files

1. Getting Started
What is a database?
Flat vs. relational databases
How FileMaker works
Understanding the essential preferences
Touring the interface

2. Database Creation Essentials
Creating databases from templates
Creating new databases in the spreadsheet-like format
Importing tables

3. Creating Tables
Determining which tables you will need
Creating tables in the Managing Tables window

4. Creating Relationships
Understanding relationship types
Diagramming relationships (with ER diagrams)
Determining which key fields you need
Defining primary and foreign keys
Creating relationships using the relationships graph and table occurrences

5. Working with Fields
Deciding what fields you will need
Understanding field types
Defining fields
Using Auto Enter options in fields
Reviewing field validation options
Building with container fields

6. Working with Records
Creating and duplicating records
Editing and locking records
Deleting records and backing up files

7. Importing and Exporting
Importing data
Importing records to refresh data
Exporting data

8. Creating Layouts
Understanding layouts
Using the Layout Assistant to create List views
Using the Layout Assistant to create labels and envelopes

9. Working with Layouts
Using the Layout Setup dialog box
Understanding layout parts
Understanding the new Inspector
Exploring the Status Area in Layout mode
Managing layouts and layout folders

10. Formatting Layout Objects
Arranging, aligning, grouping, and locking layout objects
Placing and formatting objects, parts, and graphics
Formatting fields and applying field attributes
Setting field behaviors
Using the Tab Control feature
Setting tab order

11. Finding Data
Using the basic find functions
Reviewing new requests in the Find mode
Establishing search operators
Constraining or extending found sets
Finding records using date, time, or timestamp criteria
Using Fast Match and Quick Find
Working with saved finds

12. Sorting Data
Sorting with one criterion
Sorting with related fields
Sorting with multiple criteria
Sorting using custom values
Sorting using buttons

13. Value Lists
Reviewing Field/Control styles
Creating and applying static value lists
Creating and applying dynamic value lists

14. Printing and Saving
Previewing pages and print options
Printing in different views
Sliding objects
Printing merge letters
Saving as a PDF or Excel file

15. Reports
Building simple reports with summary fields
Creating subsummary reports
Creating subsummary reports in Table view

16. Calculation Essentials
Defining calculations
Exploring the Calculation dialog box
Using number functions
Using date and time functions
Using text functions
Using get functions
Using logic functions

17. Script Essentials
Understanding scripts and script steps
Assigning script steps to buttons
Understanding the ScriptMaker dialog box
Creating multi-line scripts
Adding find criteria to a script
Understanding the If script step
Using script parameters
Reviewing the Send Mail option

18. Script Triggers
Understanding script triggers
Using object-based triggers
Using layout-based triggers
Using file-based triggers (Open and Close scripts)

19. Using Relationships
Using related fields
Creating portals and using portal filtering
Using related fields in calculations
Understanding multi-predicate relationships
Using the Go to Related Record script step
Creating a chart

Conclusion
Goodbye