Lynda com FileMaker Pro 9 Essential Training

Feb

21

Lynda com FileMaker Pro 9 Essential Training

edit 20079cattachment.phpfid594 Lynda com FileMaker Pro 9 Essential Training
FileMaker Pro 9 represents a significant upgrade over previous versions, with many new and enhanced features. These include support for external SQL (ODBC) data sources with supplemental fields, an enhanced Web Viewer, toolbar improvements, multiple script editing windows, and new calculation functions. In FileMaker Pro 9 Essential Training, instructor Cris Ippolite covers each of FileMaker 9’s features in detail. He demonstrates how to build a database from scratch for a thorough understanding of FileMaker from start to finish. Exercise files accompany the tutorials.

Released on: 7/10/2007

Introduction
Welcome   0:17   0.3 MB
Using the exercise files   1:03   1.1 MB
1. Getting Started
What is a database?   3:08   3.5 MB
Flat files vs. relational databases   1:52   2.6 MB
How FileMaker works   3:24   3.5 MB
Activation   1:17   1.2 MB
Essential preferences   3:18   3.1 MB
Interface tour   11:16   16.3 MB
Using the Help system   3:16   4.1 MB
2. Database Creation Essentials
Creating databases from templates   6:14   10.2 MB
Creating databases from scratch   4:55   5.9 MB
Ramifications of deleting tables   2:37   3.2 MB
3. Managing Fields
Managing fields   2:52   3.9 MB
Using text fields   3:01   3.8 MB
Using number fields   0:56   1.0 MB
Using date fields   2:20   3.1 MB
Using time/timestamp fields   2:35   3.5 MB
Using container fields   5:34   7.9 MB
Using calculation fields   1:23   2.5 MB
Using summary fields   2:13   2.9 MB
Organizing fields   4:06   6.2 MB
4. Auto-Enter Field Options
Creating auto-entry fields   6:16   9.0 MB
Creating serial fields   8:19   12.7 MB
Auto-entering previous values or data   2:53   3.4 MB
Auto-entering calculated values   4:17   5.1 MB
Field filtering   4:02   6.5 MB
Looking up values from other fields   5:42   7.3 MB
5. Validation and Storage Field Options
Field validation and custom messages   8:37   11.8 MB
Always vs. data entry validation options   4:36   7.2 MB
Storage options for global fields   7:52   12.4 MB
Indexing options for fields   10:32   15.0 MB
6. Working with Records
Creating and duplicating records   5:23   6.2 MB
Editing and locking records   4:25   6.0 MB
Deleting records and backing up files   2:48   4.0 MB
Committing and restoring data   5:52   8.4 MB
7. Creating Layouts
Layout overview   2:19   1.8 MB
Creating layouts   2:08   2.8 MB
Creating a standard form   5:46   7.2 MB
Creating a list/report view   11:42   13.2 MB
Creating a table view   3:14   5.7 MB
Creating labels   5:00   6.6 MB
Creating envelopes   4:00   4.2 MB
8. Working with Layouts
The Layout Setup dialog window   6:42   8.5 MB
Layout parts overview   6:41   7.6 MB
Exploring layout tools and status area   8:56   10.8 MB
Arrange, Group, and Lock layout objects   11:33   16.4 MB
9. Formatting Layout Objects
Text formatting   5:45   8.5 MB
Placing and formatting objects and graphics   4:40   5.4 MB
Formatting fields and applying field attributes   9:21   17.3 MB
Conditional formatting   8:35   16.0 MB
Field behaviors   5:40   11.1 MB
Using Auto-Complete   4:44   6.9 MB
Creating and using the Tab Control feature   8:55   15.9 MB
Setting the tab order   7:39   9.8 MB
Resizing layout objects   9:48   18.2 MB
10. Web Viewer Essentials
Using the FileMaker Web Viewer   8:21   16.5 MB
Adding Web Viewer to your layouts   5:33   6.4 MB
Setting up the Web Viewer using templates   8:58   17.7 MB
11. Finding Data
Basic find   7:38   7.1 MB
New requests in find mode   6:54   6.5 MB
Search symbols   6:11   6.5 MB
Constraining and extending a find request   3:10   3.4 MB
Finding date/time and timestamp data   5:47   6.8 MB
Finding matching records without find mode   2:03   3.0 MB
Find and Replace   2:04   2.4 MB
12. Sorting Data
Sorting with one criterion   4:21   4.4 MB
Sorting with related fields   2:26   3.6 MB
Sorting with multiple criteria   4:59   10.3 MB
Sorting using custom values   3:20   6.7 MB
Sorting using buttons   5:00   8.9 MB
13. Value Lists
Creating static value lists   3:10   6.0 MB
Creating a value list from a field   3:15   5.8 MB
Using value lists from other files   2:49   4.1 MB
Displaying second values and second fields   3:23   4.3 MB
Field control setup   9:57   16.8 MB
Additional uses of value lists   3:55   7.3 MB
14. Printing
Print layouts   1:02   0.7 MB
Previewing pages and print options   2:58   5.3 MB
Print and paper options   3:40   4.4 MB
Printing lists   2:50   4.9 MB
Printing detail   3:15   6.1 MB
Sliding objects   3:39   6.6 MB
Printing merge letters   6:06   8.2 MB
Printing labels and envelopes   3:01   4.7 MB
Summary reports   4:53   8.4 MB
Subsummary reports   10:57   16.4 MB
Saving as an Excel file   4:30   7.2 MB
Saving as a PDF   6:14   9.4 MB
15. Importing and Exporting
Importing data   12:21   19.2 MB
Exporting data   3:24   6.1 MB
16. Calculation Essentials
Defining a calculation   2:36   1.9 MB
Exploring the Calculation dialog window   8:55   13.0 MB
Date and Time functions   7:55   12.4 MB
Text functions   9:55   15.8 MB
Number functions   3:19   5.7 MB
Get functions   2:53   3.9 MB
Logic functions   16:18   23.4 MB
Summary fields and functions   5:40   9.7 MB
17. Script Essentials
Understanding scripts   2:25   2.1 MB
Understanding script steps   4:45   7.0 MB
Assigning script steps to buttons   2:47   4.5 MB
The ScriptMaker dialog window   8:04   12.4 MB
Creating multi-line scripts   6:15   9.4 MB
Subsummary scripts   8:00   12.0 MB
Open scripts   3:39   5.4 MB
Adding Find criteria to a script   8:08   14.3 MB
Using script parameters   6:37   11.1 MB
18. Relationships
ER diagrams   3:34   3.0 MB
Primary and foreign keys   8:57   11.0 MB
Creating relationships using the FileMaker Relationship Graph   4:00   5.2 MB
Tables vs. table occurrences   2:26   3.4 MB
Using related fields   10:11   15.5 MB
Going to related records   8:14   12.1 MB
19. Portals
Creating portals   9:38   13.2 MB
Creating and deleting records via portals   11:48   17.6 MB
20. Using Multiple Windows
Creating a new window   5:25   9.5 MB
Scripting a new window   2:37   4.1 MB
New window limitations   1:58   3.0 MB
21. Securing Your files
Security overview   2:18   1.6 MB
Understanding default accounts   2:27   3.3 MB
Setting up accounts, privilege sets, and external privileges   9:47   13.1 MB
Managing accounts   5:00   5.2 MB
File options   1:16   1.5 MB
Conclusion
Goodbye   0:17   0.3 MB