• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Y
• Z

From organization comes efficiency, and with efficiency, creativity can flourish. To help users create more efficient workflows, Cris Ippolite introduces the new features and basic functions of FileMaker Pro 10. In FileMaker Pro 10 Essential Training, Cris explains why this desktop database application is used by everyone from Fortune 500 companies to individuals. He demonstrates how databases work, how to manage information and understand its relationships, and how to work with calculated fields. Cris also shows how to import and export information, share results, and build interesting and attractive reports. Exercise files accompany the course.

Course FileMaker Pro 10 Essential Training Author Cris Ippolite SKU ISBN Release Date 2009-01-05 Duration 8.14 hrs / 120 tutorials Work files Yes Price $ 49.95 Retail price $ 99.95 Language Tags

1. Getting Started What is a database? 02:40 Flat files vs. relational databases 01:06 How FileMaker works 02:36 Essential preferences 02:35 Touring the interface 06:34 2. Database Creation Essentials Creating databases from templates 03:01 Creating databases from scratch 02:54 Creating databases from existing files 04:57 3. Managing Fields Managing the Fields window 02:21 Using text fields 01:40 Using number fields 01:53 Using date fields 02:36 Using time/timestamp fields 02:15 Using container fields 05:15 Using calculation and summary fields 03:03 Modifying and organizing fields 03:28 4. Auto-Enter Field Options Understanding auto-entry field options 04:35 Using the auto-enter serial options 05:30 Using the auto-enter calculated values 02:22 Setting field filter options 04:50 Looking up values from other fields 04:24 5. Validation and Storage Field Options Setting field validation and custom messages 06:29 Understanding always vs. data entry validation options 03:30 Reviewing storage options (global fields) 04:41 Indexing options for fields 07:01 6. Working with Records Creating and duplicating records 03:23 Editing and locking records 02:57 Deleting records 01:57 Committing records 02:46 Recovering files 04:51 7. Creating Layouts Creating layouts 02:01 Using the Layout Assistant to create forms, lists, labels, and envelopes 07:41 8. Working with Layouts The Layout Setup dialog 05:15 Layout parts overview 04:57 Exploring the layout tools and Status toolbar in Layout mode 04:34 Arranging and aligning layout options 05:46 Managing layouts 01:58 9. Formatting Layout Objects Formatting text 03:20 Placing and formatting objects and graphics 03:26 Formatting fields and applying field attributes 07:01 Setting field behaviors 03:32 Using auto-complete 03:40 Using the Tab Control feature 07:45 Setting tab order 04:12 Resizing layout objects 06:18 10. Web Viewer Essentials Introducing the Web Viewer layout object 05:03 Adding a Web Viewer to a layout 05:51 11. Finding Data Using the basic Find options 04:20 Reviewing new requests in Find mode 03:37 Establishing search operators 02:46 Constraining or extending a Find request 02:12 Finding a date/time or time stamp 06:32 Saved Find requests 03:48 Finding matching records without Find mode 01:58 12. Sorting Data Sorting with one criterion 03:22 Sorting with related fields 01:18 Sorting with multiple criteria 02:10 Sorting with custom values 02:54 Sorting with buttons 02:49 Maintaining a record sort order 03:15

14. Printing and Saving Previewing pages and print options 01:46 Printing from List view 02:13 Printing from Detail view 02:19 Sliding objects 04:28 Printing merge letters 03:30 Saving as a PDF 02:48 Saving as an Excel file 03:05 15. Reports Creating subsummary reports 07:51 Creating subsummary reports with no body part 05:01 Building dynamic reports 02:52 16. Importing/Exporting Importing data 07:59 Exporting data 03:40 Integrating a Bento database 02:01 17. Calculation Essentials Defining calculations 02:17 Exploring the Calculation dialog window 03:00 Using number functions 04:16 Using date and time functions 03:51 Using text functions 07:06 Using Get functions 03:27 Using logical functions 09:21 18. Script Essentials Understanding scripts and script steps 02:21 Assigning script steps to buttons 03:02 Using the ScriptMaker dialog window 05:14 Creating multi-line scripts 06:39 Building a subsummary script using If statements 03:57 Setting print options 04:27 Adding Find criteria to a script 06:42 Using Set Field and Set Field by Name 04:47 Using script parameters 03:54 Building Send Mail script steps 05:43 Executing server-activated scripts 03:34 19. Script Triggers Understanding script triggers 02:50 Using object-based triggers 05:09 Using layout-based triggers 03:02 Using file-based triggers 01:27 20. Relationships Diagramming relationships (with ER diagrams) 03:03 Setting Primary and foreign keys 08:47 Creating relationships with the FileMaker relationships graph and table occurrences 04:08 Using related fields 09:05 Using Go to Related Records script steps 10:23 Understanding multi-predicate relationships 09:27 21. Portals Creating portals 04:31 Creating and deleting records via portals 03:55 Using globals to filter portals 09:04 22. Using Multiple Windows Creating a new window manually or with a script 05:20 Understanding new window limitations 02:19 23. Securing Files Understanding security issues 01:53 Understanding default accounts 02:29 Setting up privilege sets and external privileges 08:28 Managing accounts 03:54 Setting file options 01:05 Conclusion Goodbye 00:11