FileMaker Pro 7 Tutorials
	Quantity in Basket: none Code: VTC-33495 Price:$89.95
	Quantity:
FileMaker Pro 7 Tutorials Producer: See all VTC titles Media: CD-ROM Author: Jesse Feiler ISBN: 1-932072-88-8 Duration: 8 hrs / 137 lessons Compatibility: Win XP, ME, 2000, 98, NT, Mac OS X, OS 9 Virtual Training Company author Jesse Feiler introduces you to FileMaker 7: the biggest change to FileMaker in a decade. If youÕre a beginner, youÕll see how to get started using the Starter Solution templates to manage your data. When youÕre ready to move on to creating your own database, Feiler shows you how to design effective layouts and how to use the new database design tools to create powerful yet elegant solutions. Feiler shows you how to define multi-table database files, how to manage complex relationships, how to use the new unified security model, and how to work with file references. YouÕll also see how to effortlessly publish your databases on the Web using the new Instant Web Publishing features. Try For Free Right Now To help you evaluate this training program, some of the tutorials may be viewed for free online. Listed below are all of the chapters and lessons for this title. Click on any of the linked lessons below to watch them now online! CD Contents Introducing FileMaker 7 About this Tutorial (03:13) FileMaker 7 Overview (05:14) The FileMaker Family (01:45) Starter Solutions (03:08) Entering Data in Browse Mode Getting Started with FileMaker (05:28) The Browse Mode Menus (03:56) Working with a Data Layout (05:22) Using the Status Area in Browse Mode (03:13) Entering Text (02:28) Using Container Fields (05:05) Inserting Other Data with the Insert Menu (02:57) Using the Records Menu and Auto-Entering Data (03:08) Validation (03:18) Replacing Data (01:30) Using the Browse Mode View Menu (03:23) Using the Toolbars (02:47) Sorting Data (03:54) Printing and Presenting Data in Preview Mode Using the Status Area (02:17) Sliding Fields (01:49) Printing Labels (03:18) Print Options on Windows (00:47) Print Options on Macintosh (01:00) Designing the Interface in Layout Mode Using Layout Mode (02:47) Showing Objects on a Layout pt. 1 (04:16) Showing Objects on a Layout pt. 2 (03:38) Working With Rulers (02:05) Using the Status Area (02:47) Using the Status Area Fill and Pen Controls (04:13) Positioning Objects on a Layout by Alignment (02:38) Positioning Objects on a Layout with Tools (04:18) Adding and Formatting Fields (03:04) Other Basic Layout Mode Features (03:27) Finding Data in Find Mode Finding Data the Simple Way (02:06) Constraining and Extending Found Sets (04:55) Using Multiple Find Criteria (02:40) Using Find Requests (OR) (02:08) Using the Status Area and Omitting Records (03:22) Finding Text pt. 1 (03:09) Finding Text pt. 2 (02:31) Finding Numbers/Dates/Times (04:09) Using the Design Database Dialog Database Terminology (01:45) Design Database Dialog Basics (04:08) Creating Fields (02:32) Working with Field Types (03:34) Creating Relationships (04:01) Making Databases Robust (05:31) Creating One-to-One Relationships (03:04) Displaying Data in Related Fields (02:12) Displaying Data in Portals (04:47) Using Auto-Enter Field Options (03:59) Using Validation Field Options (03:49) Using Storage Field Options (05:28) Putting It Together: Database Design and Layout Creating Join Tables and Relationships (06:18) Building the Join Tables Layout (02:44) Entering Data pt. 1 (04:29) Entering Data pt. 2 (02:33) Finding Data (02:22) Advanced Relationships Using Tables in Other Databases pt. 1 (04:02) Using Tables in Other Databases pt. 2 (03:12) Using File References (02:13) Using Self-Joins (03:07) Using Complex Relationships (04:42) Using Relationships to Find Data (04:47) Working with Value Lists Creating Value Lists (05:01) Creating Value Lists from Other Sources (02:23) Using Value Lists Lists (Windows) (02:48) Using Value Lists (Mac OS X) (02:17) Using Value Lists for Sorting and Validation (02:32) More on Layouts Formatting Numbers pt. 1 (05:55) Formatting Numbers pt. 2 (02:58) Formatting Dates (04:30) Formatting Times (02:16) Formatting Graphics (02:18) Formatting Buttons (05:19) Formatting Portals (04:28) Field Formats and Behaviors (02:08) Formatting Borders (01:41) Format Painter (03:03) Putting It Together: Improving Data Entry Using Value Lists (06:06) Finishing Up the Layout (04:23) Restructuring the Database File (03:06) Working with Functions and Calculations Using the Specify Calculation Dialog pt. 1 (01:40) Using the Specify Calculation Dialog pt. 2 (02:08) Using Functions (03:30) Specifying Calculation Storage (01:59) Aggregate Functions (04:54) Date Functions (03:59) Design Functions (02:27) Get Functions (03:08) Logical Functions: If/Case/Choose (04:04) Logical Functions: Let (05:06) Number Functions (03:32) Repeating Functions (04:29) Summary Functions (03:57) Text Functions pt. 1 (03:12) Text Functions pt. 2 (01:08) Text Formatting Functions (01:41) Time and Timestamp Functions (02:26) Trigonometric/Custom/External Functions (01:19) Introducing Scripts Introducing ScriptMaker (03:00) Using the ScriptMaker Edit Window (04:15) Using Script Parameters (02:28) Running Scripts Automatically (02:26) Control (06:35) Navigation pt. 1 (05:04) Navigation pt. 2 (02:10) Editing (01:26) Fields (01:07) Records (04:26) Found Sets (04:26) Windows (05:03) Files (02:31) Accounts/Spelling/Open Menu Item/Misc. (04:39) Summaries and Design Fleshing Out the Database (04:16) Implementing the Relationships (04:31) Using Summary Fields on Layouts (03:56) Creating a Summary Layout pt. 1 (02:34) Creating a Summary Layout pt. 2 (05:20) Creating a Summary Layout pt. 3 (06:54) Creating a Summary Layout pt. 4 (02:17) Improving the Database: Joins for Searching (04:01) Setting Up Security The Unified Security Model (01:54) Setting Up Accounts (04:59) Setting Up Privileges (05:23) Instant Web Publishing Instant Web Publishing Overview (04:06) Setting Up IWP (03:53) FileMaker Networking Using a Networked Database (03:42) Sharing a FileMaker Database (01:11) Importing and Exporting Data Importing Data pt. 1 (03:39) Importing Data pt. 2 (03:27) Importing Options (01:57) Exporting Data (04:30) ODBC ODBC for Import/Export (Windows) pt. 1 (06:18) ODBC for Import/Export (Windows) pt. 2 (02:20) ODBC for Import/Export (Mac OS X) (07:12) Credits Useful Links (00:27) About this Author (02:25) To view the Free Tutorials you must have Quicktime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality. Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.