Lynda.com FileMaker Pro 10 Essential Training DVD

Table of contents Introduction Welcome 1:26 19.9 MB Understanding the FileMaker family 1:58 1.9 MB The FileMaker Quick Start screen 3:25 4.5 MB Using the exercise files 0:44 0.6 MB 1. Getting Started What is a database? 2:40 2.1 MB Flat files vs. relational databases 1:06 1.1 MB How FileMaker works 2:36 2.6 MB Essential preferences 2:35 4.1 MB Touring the interface 6:34 6.3 MB 2. Database Creation Essentials Creating databases from templates 3:01 2.7 MB Creating databases from scratch 2:54 3.1 MB Creating databases from existing files 4:57 5.1 MB 3. Managing Fields Managing the Fields window 2:21 3.3 MB Using text fields 1:40 2.5 MB Using number fields 1:53 2.8 MB Using date fields 2:36 2.7 MB Using time/timestamp fields 2:15 1.9 MB Using container fields 5:15 5.0 MB Using calculation and summary fields 3:03 5.6 MB Modifying and organizing fields 3:28 5.6 MB 4. Auto-Enter Field Options Understanding auto-entry field options 4:35 7.7 MB Using the auto-enter serial options 5:30 8.3 MB Using the auto-enter calculated values 2:22 2.8 MB Setting field filter options 4:50 5.7 MB Looking up values from other fields 4:24 5.7 MB 5. Validation and Storage Field Options Setting field validation and custom messages 6:29 9.5 MB Understanding always vs. data entry validation options 3:30 5.7 MB Reviewing storage options (global fields) 4:41 5.5 MB Indexing options for fields 7:01 10.5 MB 6. Working with Records Creating and duplicating records 3:23 2.8 MB Editing and locking records 2:57 2.9 MB Deleting records 1:57 1.7 MB Committing records 2:46 2.8 MB Recovering files 4:51 6.2 MB 7. Creating Layouts Creating layouts 2:01 2.1 MB Using the Layout Assistant to create forms, lists, labels, and envelopes 7:41 10.4 MB 8. Working with Layouts The Layout Setup dialog 5:15 9.2 MB Layout parts overview 4:57 6.3 MB Exploring the layout tools and Status toolbar in Layout mode 4:34 4.5 MB Arranging and aligning layout options 5:46 5.4 MB Managing layouts 1:58 3.4 MB 9. Formatting Layout Objects Formatting text 3:20 3.5 MB Placing and formatting objects and graphics 3:26 3.5 MB Formatting fields and applying field attributes 7:01 9.4 MB Setting field behaviors 3:32 5.3 MB Using auto-complete 3:40 4.5 MB Using the Tab Control feature 7:45 11.6 MB Setting tab order 4:12 5.0 MB Resizing layout objects 6:18 7.0 MB 10. Web Viewer Essentials Introducing the Web Viewer layout object 5:03 7.3 MB Adding a Web Viewer to a layout 5:51 8.1 MB 11. Finding Data Using the basic Find options 4:20 3.3 MB Reviewing new requests in Find mode 3:37 2.9 MB Establishing search operators 2:46 2.2 MB Constraining or extending a Find request 2:12 1.8 MB Finding a date/time or time stamp 6:32 6.2 MB Saved Find requests 3:48 3.9 MB Finding matching records without Find mode 1:58 1.9 MB 12. Sorting Data Sorting with one criterion 3:22 3.2 MB Sorting with related fields 1:18 1.9 MB Sorting with multiple criteria 2:10 2.6 MB Sorting with custom values 2:54 6.5 MB Sorting with buttons 2:49 3.8 MB Maintaining a record sort order 3:15 6.6 MB 13. Value Lists Creating static value lists 2:33 3.1 MB Creating a value list from a field 3:10 4.2 MB Displaying second values and only second fields 4:33 6.2 MB Setting up field controls 11:09 14.6 MB 14. Printing and Saving Previewing pages and print options 1:46 2.1 MB Printing from List view 2:13 2.7 MB Printing from Detail view 2:19 3.2 MB Sliding objects 4:28 7.7 MB Printing merge letters 3:30 3.5 MB Saving as a PDF 2:48 3.8 MB Saving as an Excel file 3:05 3.4 MB 15. Reports Creating subsummary reports 7:51 10.0 MB Creating subsummary reports with no body part 5:01 5.3 MB Building dynamic reports 2:52 3.0 MB 16. Importing/Exporting Importing data 7:59 11.7 MB Exporting data 3:40 4.8 MB Integrating a Bento database 2:01 2.2 MB 17. Calculation Essentials Defining calculations 2:17 1.7 MB Exploring the Calculation dialog window 3:00 4.6 MB Using number functions 4:16 5.9 MB Using date and time functions 3:51 4.8 MB Using text functions 7:06 9.6 MB Using Get functions 3:27 4.9 MB Using logical functions 9:21 12.4 MB 18. Script Essentials Understanding scripts and script steps 2:21 1.8 MB Assigning script steps to buttons 3:02 4.3 MB Using the ScriptMaker dialog window 5:14 4.5 MB Creating multi-line scripts 6:39 9.1 MB Building a subsummary script using If statements 3:57 5.2 MB Setting print options 4:27 6.8 MB Adding Find criteria to a script 6:42 9.4 MB Using Set Field and Set Field by Name 4:47 5.4 MB Using script parameters 3:54 4.2 MB Building Send Mail script steps 5:43 8.4 MB Executing server-activated scripts 3:34 3.4 MB 19. Script Triggers Understanding script triggers 2:50 3.0 MB Using object-based triggers 5:09 5.9 MB Using layout-based triggers 3:02 4.2 MB Using file-based triggers 1:27 2.3 MB 20. Relationships Diagramming relationships (with ER diagrams) 3:03 2.2 MB Setting Primary and foreign keys 8:47 11.2 MB Creating relationships with the FileMaker relationships graph and table occurrences 4:08 5.3 MB Using related fields 9:05 10.3 MB Using Go to Related Records script steps 10:23 13.3 MB Understanding multi-predicate relationships 9:27 12.2 MB 21. Portals Creating portals 4:31 5.2 MB Creating and deleting records via portals 3:55 4.7 MB Using globals to filter portals 9:04 12.2 MB 22. Using Multiple Windows Creating a new window manually or with a script 5:20 5.8 MB Understanding new window limitations 2:19 2.3 MB 23. Securing Files Understanding security issues 1:53 1.3 MB Understanding default accounts 2:29 2.8 MB Setting up privilege sets and external privileges 8:28 12.8 MB Managing accounts 3:54 4.1 MB Setting file options 1:05 1.5 MB Conclusion Goodbye 0:11 0.3 MB