FileMaker Pro 7 Tutorials - Online Training Course

Course Title: FileMaker Pro 7

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.

Course Author/Expert: Jesse Feiler

Language: english

Full Online Training Available: Yes

Number of Course Movies: 137

Course Duration: 8 hours

Never has it been so easy to learn FileMaker Pro 7.
No expensive classroom training courses.
No boring hard to follow books to read.
Learn from your own desk at a pace that suits you.
High quality affordable training that is easy to use and follow.
Use unique training methods, it makes learning easy no matter what your learning style.

Course Outline:

Straight away, you can go through the first three chapters of this tutorial. If you need all the lessons, then join the Online University - complete access to over five hundred and fifty courses right now for as long as you need them and even get an online university certificate. See below for details.

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

To continue your learning, Click Here for the Online University and get access to all of the training courses, that's over 550 software programmes including 60,000 tutorial videos, for editing, image manipulation and graphics programmes. All for just $30 (approx £16) month. Unlimited access for as long as you need, cancel when you're finished, no contract, no minimum period, no hassle.

or

Click Here and we'll send you the training CD itself for FileMaker Pro 7 at £79.95

Home Find Software Courses Login Categories About SiteMap Contact

Add latest courses to Google Toolbar | After Effects Projects |

Introducing FileMaker 7

Entering Data in Browse Mode

Printing and Presenting Data in Preview Mode