FileMaker Pro 7 Tutorial Try for FREE
Select a tutorial category
Discounted Training Courses
Members of the VTC Online University have unlimited access to this tutorial. At the moment, you are in demo mode and only the first 3 chapters will play. But members have access to EVERY SINGLE TITLE IN OUR RANGE, i.e., over 40,000 tutorials on 400+ titles all with expert tutors. Where else can you get high quality one to one training for just $30.00 per month!
Benefits
:- 01. Unlimited viewing.
- 02. Downloadable working files.
- 03. Expert instructors.
- 04. Use at home / work or both.
- 05. Works on PC or Mac.
- 06. Telephone Tech support.
- 07. Cancel at any time.
- 08. 300+ courses for 1 low fee.
- 09. New titles added regularly.
- 10. 100% Guaranteed
Should you need any help, just call - contact details at the bottom of the page.
You are in Demo mode which only allows access to the first 3 chapters of this FileMaker Pro 7 training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining. If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, you can also cancel at any time you wish. Over 4000 hours of training for just $30.00.
Introducing FileMaker 7
Entering Data in Browse Mode
- Getting Started with FileMaker
- The Browse Mode Menus
- Working with a Data Layout
- Using the Status Area in Browse Mode
- Entering Text
- Using Container Fields
- Inserting Other Data with the Insert Menu
- Using the Records Menu and Auto-Entering Data
- Validation
- Replacing Data
- Using the Browse Mode View Menu
- Using the Toolbars
- Sorting Data
Printing and Presenting Data in Preview Mode
- Using the Status Area
- Sliding Fields
- Printing Labels
- Print Options on Windows
- Print Options on Macintosh
Designing the Interface in Layout Mode
- Using Layout Mode
- Showing Objects on a Layout pt. 1
- Showing Objects on a Layout pt. 2
- Working With Rulers
- Using the Status Area
- Using the Status Area Fill and Pen Controls
- Positioning Objects on a Layout by Alignment
- Positioning Objects on a Layout with Tools
- Adding and Formatting Fields
- Other Basic Layout Mode Features
Finding Data in Find Mode
- Finding Data the Simple Way
- Constraining and Extending Found Sets
- Using Multiple Find Criteria
- Using Find Requests (OR)
- Using the Status Area and Omitting Records
- Finding Text pt. 1
- Finding Text pt. 2
- Finding Numbers/Dates/Times
Using the Design Database Dialog
- Database Terminology
- Design Database Dialog Basics
- Creating Fields
- Working with Field Types
- Creating Relationships
- Making Databases Robust
- Creating One-to-One Relationships
- Displaying Data in Related Fields
- Displaying Data in Portals
- Using Auto-Enter Field Options
- Using Validation Field Options
- Using Storage Field Options
Putting It Together: Database Design and Layout
- Creating Join Tables and Relationships
- Building the Join Tables Layout
- Entering Data pt. 1
- Entering Data pt. 2
- Finding Data
Advanced Relationships
- Using Tables in Other Databases pt. 1
- Using Tables in Other Databases pt. 2
- Using File References
- Using Self-Joins
- Using Complex Relationships
- Using Relationships to Find Data
Working with Value Lists
- Creating Value Lists
- Creating Value Lists from Other Sources
- Using Value Lists Lists (Windows)
- Using Value Lists (Mac OS X)
- Using Value Lists for Sorting and Validation
More on Layouts
- Formatting Numbers pt. 1
- Formatting Numbers pt. 2
- Formatting Dates
- Formatting Times
- Formatting Graphics
- Formatting Buttons
- Formatting Portals
- Field Formats and Behaviors
- Formatting Borders
- Format Painter
Putting It Together: Improving Data Entry
- Using Value Lists
- Finishing Up the Layout
- Restructuring the Database File
Working with Functions and Calculations
- Using the Specify Calculation Dialog pt. 1
- Using the Specify Calculation Dialog pt. 2
- Using Functions
- Specifying Calculation Storage
- Aggregate Functions
- Date Functions
- Design Functions
- Get Functions
- Logical Functions: If/Case/Choose
- Logical Functions: Let
- Number Functions
- Repeating Functions
- Summary Functions
- Text Functions pt. 1
- Text Functions pt. 2
- Text Formatting Functions
- Time and Timestamp Functions
- Trigonometric/Custom/External Functions
Introducing Scripts
- Introducing ScriptMaker
- Using the ScriptMaker Edit Window
- Using Script Parameters
- Running Scripts Automatically
- Control
- Navigation pt. 1
- Navigation pt. 2
- Editing
- Fields
- Records
- Found Sets
- Windows
- Files
- Accounts/Spelling/Open Menu Item/Misc.
Summaries and Design
- Fleshing Out the Database
- Implementing the Relationships
- Using Summary Fields on Layouts
- Creating a Summary Layout pt. 1
- Creating a Summary Layout pt. 2
- Creating a Summary Layout pt. 3
- Creating a Summary Layout pt. 4
- Improving the Database: Joins for Searching
Setting Up Security
- The Unified Security Model
- Setting Up Accounts
- Setting Up Privileges
Instant Web Publishing
- Instant Web Publishing Overview
- Setting Up IWP
FileMaker Networking
- Using a Networked Database
- Sharing a FileMaker Database
Importing and Exporting Data
- Importing Data pt. 1
- Importing Data pt. 2
- Importing Options
- Exporting Data
ODBC
- ODBC for Import/Export (Windows) pt. 1
- ODBC for Import/Export (Windows) pt. 2
- ODBC for Import/Export (Mac OS X)
Credits
- Useful Links
- About this Author
If you would like to own this FileMaker 7 training title on CD, you may purchase it from our online store, because we don't have to use the same level of compression on the CDs as we do with the online, the audio and video playback is of a higher quality. For a single low payment you can buy this
After you have completed a tutorial, a
In order to view the training, you must have the latest version of QuickTime installed. Please note that the online movies have been compressed for quicker downloads, CDs and DVDs have far higher audio and video quality.