United States
FileMaker Pro 7 Tutorials
Online Contents For This Course
We have made some of the video tutorials for FileMaker Pro 7 freely available to help you evaluate our training.
Click on any of the linked lesson listings below to preview FREE!
Course Description
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. To get started today, simply click on one of the links below.
Choose your media type:
|
Introducing FileMaker 7
|
|||
| About this Tutorial | (03:13) | T | |
| FileMaker 7 Overview | (05:14) | T | |
| The FileMaker Family | (01:45) | T | |
| Starter Solutions | (03:08) | T | |
|
Entering Data in Browse Mode
|
|||
| Getting Started with FileMaker | (05:28) | T | |
| The Browse Mode Menus | (03:56) | T | |
| Working with a Data Layout | (05:22) | T | |
| Using the Status Area in Browse Mode | (03:13) | T | |
| Entering Text | (02:28) | T | |
| Using Container Fields | (05:05) | T | |
| Inserting Other Data with the Insert Menu | (02:57) | T | |
| Using the Records Menu and Auto-Entering Data | (03:08) | T | |
| Validation | (03:18) | T | |
| Replacing Data | (01:30) | T | |
| Using the Browse Mode View Menu | (03:23) | T | |
| Using the Toolbars | (02:47) | T | |
| Sorting Data | (03:54) | T | |
|
Printing and Presenting Data in Preview Mode
|
|||
| Using the Status Area | (02:17) | T | |
| Sliding Fields | (01:49) | T | |
| Printing Labels | (03:18) | T | |
| Print Options on Windows | (00:47) | T | |
| Print Options on Macintosh | (01:00) | T | |
|
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) | ||
Email this Page
Send us FeedbackCourse Information
| Course: | FileMaker Pro 7 |
| Author: | Jesse Feiler |
| SKU: | 33495 |
| ISBN: | 1-932072-88-8 |
| Release Date: | 2004-05-28 |
| Duration: | 8 hrs / 137 tutorials |
| Captions: | For Online University members only |
Subscription / Purchase Information
This course is just part of the entire VTC collection of over 650 courses, 70,000 video tutorials (14,250+ free), available to you for just $30 a month.
View All Courses Subscribe Learn More