Title Language  : 

Find a Course... Try for Free!

 

View Cart

FileMaker Pro 7 Tutorials

Course Content
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.
QT To view the Free Tutorials listed below, 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.

«« Hide This
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)

Email this Page     Send us Feedback
Tutorial Information / Pricing
Title: FileMaker Pro 7
Author: Jesse Feiler
SKU: 33495
ISBN: 1-932072-88-8
Duration: 8 hrs / 137 Lessons
Compatibility: Win XP, 2000, 98, NT, Mac OS X, OS 9

Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP LEARN MORE »

Get this title on CD
Single User: US$ 99.95 - Purchase CD / Add to Cart

Multi User (10): US$ 500.00 - Purchase CD / Add to Cart

Select Bandwidth
Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

Select:

Select Category

Special Groups

Publisher or Products