FlieMaker Pro Video Tutorials
| FileMaker Video Tutorials |
 |
|
Developer FileMaker Inc Latest Release version 8.5 v1 Operating System Mac OS X, Microsoft Windows Website FileMaker Inc (Database Managment System) Description FileMaker Pro is a cross-platform database application from FileMaker Inc. (a subsidiary of Apple Inc.), known for its combination of power and ease of use. It is also noted for the integration of the database engine with its GUI-based interface, which allows users to modify the database by dragging new elements into the layouts/screens/forms that provide the user interface. This results in a "quasi-object" development environment of a kind that is still largely unique in the "industrial strength" database world. FileMaker was one of a handful of database applications released for the Apple Macintosh in the 1980s. FileMaker has compatible versions for both the Mac OS X and Microsoft Windows operating systems and can be networked simultaneously to a mixed Windows and Mac OS X user base. FileMaker is also scalable, being offered in desktop, server, web-delivery and mobile configurations. |
Introduction
Introduction to the FileMaker Web Viewer (Lynda.com)
Using the Web Viewer (Lynda.com)
What is a database (Lynda.com)
Flat vs. relational databases (Lynda.com)
Essential Preferences (Lynda.com)
Interface Tour (Lynda.com)
Interface (VTC.com)
New Features for 8.5
Overview pt. 1 (VTC.com)
Overview pt. 2 (VTC.com)
Layout Object Naming pt. 1 (VTC.com)
Layout Object Naming pt. 2 (VTC.com)
Go To Object Ideas pt. 1 (VTC.com)
Go To Object Ideas pt. 2 (VTC.com)
New Functions pt. 1 (VTC.com)
New Functions pt. 2 (VTC.com)
List Function pt. 1 (VTC.com)
List Function pt. 2 (VTC.com)
Web Viewer Basics pt. 1 (VTC.com)
Web Viewer Basics pt. 2 (VTC.com)
Set Web Viewer (VTC.com)
Scraping (VTC.com)
Paths (VTC.com)
Database Basics
Creating databases from templates (Lynda.com)
Creating databases from scratch (Lynda.com)
Ramifications of deleting tables (Lynda.com)
Defining fields and field types (Lynda.com)
Data Entry (VTC.com)
Status Area (VTC.com)
The 4 Modes (VTC.com)
Records Menu (VTC.com)
Previewing Pages (VTC.com)
New Layout pt. 1 (VTC.com)
New Layout pt. 2 (VTC.com)
Creating a Database
Templates (VTC.com)
New Empty File (VTC.com)
Creating Fields (VTC.com)
Housekeeping Fields (VTC.com)
Modifying Fields (VTC.com)
Organizing Fields (VTC.com)
Other Tabs (VTC.com)
Data Modeling
Introduction to data modeling (lynda.com)
Reviewing relationships types (lynda.com)
Developing a list of entities (lynda.com)
Diagramming relationships (lynda.com)
Resolving one-to-one and many-to-many relationships (lynda.com)
The Relationship Graph vs. ERDs (lynda.com)
Entering Data
Get Started with FileMaker (VTC.com)
The Browse Mode Menus (VTC.com)
Working with a Data Layout (VTC.com)
Using the Status Area in Browse Mode (VTC.com)
Entering Text (VTC.com)
Using Container Fields (VTC.com)
Inserting Other Data with the Insert Menu (VTC.com)
Using the Records Menu and Auto-Entering Data (VTC.com)
Replacing Data (VTC.com)
Using the Browse Mode View Menu (VTC.com)
Using the Toolbars (VTC.com)
Sorting Data (VTC.com)
Auto-Entry
Creating auto entry fields (Lynda.com)
Auto-entering calculated values (Lynda.com)
Finding and Sorting
Looking up values from other fields (Lynda.com)
Save Found Set
Organization pt. 1 (VTC.com)
Organization pt. 2 (VTC.com)
Loop with Global (VTC.com)
Loop with Variable pt. 1 (VTC.com)
Loop with Variable pt. 2 (VTC.com)
GetNthRecord (VTC.com)
Tail Recursion (VTC.com)
Compare and Contrast (VTC.com)
Save Multiple Found Sets pt. 1 (VTC.com)
Save Multiple Found Sets pt. 2 (VTC.com)
Duplicate Set Names (VTC.com)
Restore Multiple Found Sets pt. 1 (VTC.com)
Restore Multiple Found Sets pt. 2 (VTC.com)
New Window pt. 1 (VTC.com)
New Window pt. 2 (VTC.com)
Ultimate Find
Why Script a Find (VTC.com)
Find Layout (VTC.com)
Continue and Cancel (VTC.com)
Modular Scripting (VTC.com)
Error Capture pt. 1 (VTC.com)
Error Capture pt. 2 (VTC.com)
Modify Find (VTC.com)
Dynamic Scripting (VTC.com)
Finishing Touches pt. 1 (VTC.com)
Finishing Touches pt. 2 (VTC.com)
Filtering
Field Filtering (Lynda.com)
Validation
Validation (VTC.com)
Inspector
Inspector : What is Inspector (Lynda.com)
Inspector : Who would use Inspector (Lynda.com)
Inspector : What is required to run Inspector (Lynda.com)
Inspector : Inspector overview and preferences (Lynda.com)
Inspector : Generating and importing a DDR (Lynda.com)
Inspector : Navigation essentials (Lynda.com)
Inspector : Filtering essentials (Lynda.com)
Inspector : Exporting metadata (Lynda.com)
Inspector : Generating reports (Lynda.com)
Inspector : Attaching notes to elements (Lynda.com)
Inspector : Attaching notes to problems (Lynda.com)
Inspector : References and dependencies (Lynda.com)
Inspector : Finding and fixing problems (Lynda.com)
Inspector : Comparing differences (Lynda.com)
Inspector : Searching (Lynda.com)
Inspector : Security perspective (Lynda.com)
Inspector : Conclusion (Lynda.com)
Printing and Presentation
Using the Status Area (VTC.com)
Sliding Fields (VTC.com)
Printing Labels (VTC.com)
Print Options on Windows (VTC.com)
Print Options on Macintosh (VTC.com)
Relational Structure
Tables (VTC.com)
Fields (VTC.com)
Relationships (VTC.com)
Generate Days Script pt. 1 (VTC.com)
Generate Days Script pt. 2 (VTC.com)
Generate Days Script pt. 3 (VTC.com)
Variables For Speed (VTC.com)
Generate Events Script pt. 1 (VTC.com)
Generate Events Script pt. 2 (VTC.com)
Import For Speed pt. 1 (VTC.com)
Import For Speed pt. 2 (VTC.com)
Relationships
Relational Theory (VTC.com)
Data Modeling (VTC.com)
Entity-Relationship Diagrams (VTC.com)
Creating a Relationship (VTC.com)
Related Fields pt. 1 (VTC.com)
Related Fields pt. 2 (VTC.com)
Multi-step relationships (lynda.com)
Working with external files (lynda.com)
Non-equijoin relationships (lynda.com)
Interface Design
Screen Size (VTC.com)
Background (VTC.com)
Tabs, Bars, Buttons (VTC.com)
Field Outlines (VTC.com)
Sub-Areas (VTC.com)
Finishing Touches pt. 1 (VTC.com)
Finishing Touches pt. 2 (VTC.com)
Tabbed Layouts pt. 1 (VTC.com)
Tabbed Layouts pt. 2 (VTC.com)
List View (VTC.com)
List View without Status Area (VTC.com)
Design Considerations (VTC.com)
Web Publishing
Defining FileMaker products (lynda.com)
Static publishing (lynda.com)
What is Instant Web Publishing (Part 1) (lynda.com)
Instant Web Publishing options and browser requirements (Part 2) (lynda.com)
Preparing files for Instant Web Publishing (Part 3) (lynda.com)
Configuring FileMaker Pro to host Instant Web Publishing (Part 4) (lynda.com)
Previous Versions of FileMaker
FileMaker 8.0
What is a Database (VTC.com)
Planning your Solution (VTC.com)
Accounts and Passwords (VTC.com)
FileMaker 7.0
FileMaker 7 Overview (VTC.com)
The FileMaker Family (VTC.com)
Starter Solutions (VTC.com)
The history of FileMaker (Lynda.com)
Flat vs. relational (Lynda.com)
Example: flat vs. relational (Lynda.com)
Context and perspective (Lynda.com)
General preferences (Lynda.com)
Browse mode (Lynda.com)
Layout mode (Lynda.com)
Find mode (Lynda.com)
Preview mode (Lynda.com)
FileMaker 6.0
Why FileMaker Is Powerful (VTC.com)
What Is and Is Not Covered (VTC.com)
Previous Versions and Help (VTC.com)
About Databases (VTC.com)
Screen Orientation - Part 1 (VTC.com)
Screen Orientation - Part 2 (VTC.com)
Working with Files - Part 1 (VTC.com)
Working with Files - Part 2 (VTC.com)
Records and Fields - Part 1 (VTC.com)
Records and Fields - Part 2 (VTC.com)
Modes - Part 1 (VTC.com)
Modes - Part 2 (VTC.com)
Layouts (VTC.com)
Preferences - Application (VTC.com)
Preferences - Document (VTC.com)
Viewing Records (VTC.com)
Adding and Deleting Records (VTC.com)
Entering Data - Part 1 (VTC.com)
Entering Data - Part 2 (VTC.com)
Moving Data (VTC.com)
Value Lists (VTC.com)
Inserting Data (VTC.com)
Multimedia - Part 1 (VTC.com)
Multimedia - Part 2 (VTC.com)
Replacing Data - Part 1 (VTC.com)
Replacing Data - Part 2 (VTC.com)
Spell Checking (VTC.com)
Find Basics - Part 1 (VTC.com)
Find Basics - Part 2 (VTC.com)
Finding Text - Part 1 (VTC.com)
Finding Text - Part 2 (VTC.com)
Finding Numbers and More (VTC.com)
Finding Ranges (VTC.com)
Omitting, Finding Empty (VTC.com)
Multiple Find Criteria (VTC.com)
Find and Omit (VTC.com)
Extend and Constrain (VTC.com)
Find and Replace (VTC.com)
Sorting - Part 1 (VTC.com)
Sorting - Part 2 (VTC.com)
Contextual Sorting (VTC.com)
Printing (VTC.com)
Preview Mode (VTC.com)
FileMaker 3 and 4
Introduction (VTC.com)
Installation (VTC.com)
Opening FileMaker (VTC.com)
Moving Around FileMaker (VTC.com)
Files, Records, Fields (VTC.com)
All About Layouts (VTC.com)
Sorting Information (VTC.com)
Finding Information (VTC.com)
More on Modes (VTC.com)
Previewing and Printing (VTC.com)
Creating and Deleting Records (VTC.com)
Adding and Modifying Fields (VTC.com)
Intro to Buttons and Scripts (VTC.com)
The Integrated Solution (VTC.com)
Planning your structure (VTC.com)
Defining Fields (VTC.com)
Types of Fields (VTC.com)
Entry Options (VTC.com)
Working on the layout (VTC.com)
Field Formatting (VTC.com)
Creating a layout (VTC.com)
Importing data (VTC.com)
Creating a goto button (VTC.com)
Creating Mail merge Letters (VTC.com)
Creating Labels (VTC.com)
Making it all look pretty (VTC.com)
Adding Graphics (VTC.com)
Turn Graphics into Buttons (VTC.com)
Simple Scripting (VTC.com)
Use full List View Button (VTC.com)
List View Sorting button (VTC.com)
Repetitive fields, page eak (VTC.com)
Calculations (VTC.com)
HiddenFields (VTC.com)
Deleting records or serial numbers (VTC.com)
Relationships and Look-ups (VTC.com)
Sliding fields on printing (VTC.com)
Summary Totals (VTC.com)
Copying Layouts (VTC.com)
Two way relationships (VTC.com)