Lynda.COM FileMaker Pro 11 Essential Training

Author:
Cris Ippolite

Duration:
09h 11m

Released on:
6/25/2010

Exercise files:
Yes

Software works on:
Windows only


In FileMaker Pro 11 Essential Training, Cris Ippolite demonstrates the principal features and functions of this popular database software, including creating tables and relationships, managing fields and records, and working with layouts. The course shows FileMaker developers how to find, sort, and share data as well as how to create reports, calculations, and scripts. It also covers brand new features in FileMaker Pro 11 such as the Inspector tool, charting, and portal filtering. Exercise files accompany the course.
Topics include:

    Creating databases from templates
    Creating fields in spreadsheet format
    Creating tables and relationships
    Defining key fields
    Adding validation and auto-enter values to fields
    Managing records, including duplicating, locking, and deleting records
    Creating and managing layouts
    Formatting layout objects
    Finding and sorting data
    Creating calculation fields
    Building reports
    Printing and saving as PDF or Excel
    Writing and triggering scripts
    Using relationships throughout a database




Introduction
Welcome           01m 08s
Understanding the FileMaker family           02m 15s
Using the FileMaker Quick Start screen           02m 52s
Using the exercise files           01m 07s

1. Getting Started
What is a database?           02m 26s
Flat vs. relational databases           02m 29s
How FileMaker works           04m 48s
Understanding the essential preferences           03m 13s
Touring the interface           08m 13s

2. Database Creation Essentials
Creating databases from templates           02m 29s
Creating new databases in the spreadsheet-like format           05m 35s
Importing tables           03m 40s

3. Creating Tables
Determining which tables you will need           05m 10s
Creating tables in the Managing Tables window           03m 59s

4. Creating Relationships
Understanding relationship types           06m 58s
Diagramming relationships (with ER diagrams)           08m 50s
Determining which key fields you need           05m 18s
Defining primary and foreign keys           07m 56s
Creating relationships using the relationships graph and table occurrences           05m 45s

5. Working with Fields
Deciding what fields you will need           05m 34s
Understanding field types           07m 54s
Defining fields           09m 56s
Using Auto Enter options in fields           09m 33s
Reviewing field validation options           08m 16s
Building with container fields           09m 21s

6. Working with Records
Creating and duplicating records           05m 40s
Editing and locking records           04m 42s
Deleting records and backing up files           03m 46s

7. Importing and Exporting
Importing data           09m 57s
Importing records to refresh data           07m 02s
Exporting data           04m 07s

8. Creating Layouts
Understanding layouts           04m 15s
Using the Layout Assistant to create List views           07m 59s
Using the Layout Assistant to create labels and envelopes           06m 16s

9. Working with Layouts
Using the Layout Setup dialog box           04m 54s
Understanding layout parts           04m 40s
Understanding the new Inspector           02m 26s
Exploring the Status Area in Layout mode           06m 46s
Managing layouts and layout folders           08m 25s

10. Formatting Layout Objects
Arranging, aligning, grouping, and locking layout objects           11m 05s
Placing and formatting objects, parts, and graphics           04m 10s
Formatting fields and applying field attributes           08m 26s
Setting field behaviors           04m 04s
Using the Tab Control feature           09m 08s
Setting tab order           04m 16s

11. Finding Data
Using the basic find functions           07m 31s
Reviewing new requests in the Find mode           05m 54s
Establishing search operators           06m 43s
Constraining or extending found sets           03m 24s
Finding records using date, time, or timestamp criteria           05m 18s
Using Fast Match and Quick Find           04m 41s
Working with saved finds           03m 17s

12. Sorting Data
Sorting with one criterion           06m 04s
Sorting with related fields           02m 18s
Sorting with multiple criteria           01m 36s
Sorting using custom values           03m 14s
Sorting using buttons           04m 16s

13. Value Lists
Reviewing Field/Control styles           05m 43s
Creating and applying static value lists           05m 20s
Creating and applying dynamic value lists           06m 11s

14. Printing and Saving
Previewing pages and print options           06m 20s
Printing in different views           02m 54s
Sliding objects           03m 26s
Printing merge letters           04m 53s
Saving as a PDF or Excel file           06m 19s

15. Reports
Building simple reports with summary fields           04m 36s
Creating subsummary reports           06m 51s
Creating subsummary reports in Table view           03m 34s

16. Calculation Essentials
Defining calculations           02m 31s
Exploring the Calculation dialog box           05m 08s
Using number functions           12m 41s
Using date and time functions           04m 58s
Using text functions           11m 43s
Using get functions           04m 00s
Using logic functions           11m 18s

17. Script Essentials
Understanding scripts and script steps           02m 23s
Assigning script steps to buttons           03m 54s
Understanding the ScriptMaker dialog box           08m 28s
Creating multi-line scripts           06m 44s
Adding find criteria to a script           04m 58s
Understanding the If script step           08m 36s
Using script parameters           04m 42s
Reviewing the Send Mail option           07m 11s

18. Script Triggers
Understanding script triggers           02m 41s
Using object-based triggers           11m 58s
Using layout-based triggers           07m 51s
Using file-based triggers (Open and Close scripts)           05m 30s

19. Using Relationships
Using related fields           07m 18s
Creating portals and using portal filtering           10m 38s
Using related fields in calculations           07m 06s
Understanding multi-predicate relationships           11m 11s
Using the Go to Related Record script step           07m 26s
Creating a chart           13m 03s

Conclusion
Goodbye           00m 30s