Course Title: FileMaker Pro 6



FileMaker Pro 6 is a powerful cross-platform database application that takes the headache out of organizing your business and information. With FileMaker Pro 6, you can create powerful relational databases that will allow you to produce invoices, form letters, client contact databases, purchase order systems, and much more. In this Virtual Training Company tutorial, master trainer and FileMaker developer David Bylund will not only teach you to use FileMaker Pro 6 to work with existing databases, but will also help you learn to create your own customized databases. He begins by going over the basics of FileMaker, such as screen orientation and preferences. He then guides you into the use of databases, including creating new records and how to find text, numbers, and ranges. You will learn how to create a database to fit your needs by learning layout options, formatting, and creating reports. You will even learn about relational databases, and will be introduced to calculations and scripts, so that you will be able to automate many tasks. To get started with FileMaker Pro 6, just click one of the movie topics below.


Course Author/Expert: David Bylund

Language: english

Full Online Training Available: Yes

Number of Course Movies: 165

Course Duration: 10 hours



Never has it been so easy to learn FileMaker Pro 6.
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.




Introduction


Why FileMaker Is Powerful

What Is & Is Not Covered

Previous Versions & Help


FileMaker Basics


About Databases

Screen Orientation - Part 1

Screen Orientation - Part 2

Working with Files - Part 1

Working with Files - Part 2

Records and Fields - Part 1

Records and Fields - Part 2

Modes - Part 1

Modes - Part 2

Layouts

Preferences - Application

Preferences - Document


Using Databases


Viewing Records

Adding and Deleting Records

Entering Data - Part 1

Entering Data - Part 2

Moving Data

Value Lists

Inserting Data

Multimedia - Part 1

Multimedia - Part 2

Replacing Data - Part 1

Replacing Data - Part 2

Spell Checking

Find Basics - Part 1

Find Basics - Part 2

Finding Text - Part 1

Finding Text - Part 2

Finding Numbers and More

Finding Ranges

Omitting, Finding Empty

Multiple Find Criteria

Find & Omit

Extend & Constrain

Find & Replace

Sorting - Part 1

Sorting - Part 2

Contextual Sorting

Printing

Preview Mode


Creating Databases for You


Planning Your Database

New Database & Templates

Import from File

Import Actions

Import Field Mapping

Import Continued

Import from Folder - Part 1

Import from Folder - Part 2

Defining Fields

Auto-Enter Options

Validation Options

Repeating Fields & Indexing

Global Fields

Summary Fields

Calculation Fields

Changing Field Definitions


Layouts and Reports


Layout Strategies

Layout Mode Overview

Managing Layouts

Layout Templates

Standard Form

Columnar List - Part 1

Columnar List - Part 2

Columnar List - Part 3

Table

Labels & Envelopes - Part 1

Labels & Envelopes - Part 2

Labels & Envelopes - Part 3

Custom Layout

Layout Parts - Part 1

Layout Parts - Part 2

Fields - Part 1

Fields - Part 2

Merge Fields

Standard & Merge Fields

Layout Objects - Part 1

Layout Objects - Part 2

Adding Objects - Part 1

Adding Objects - Part 2

Fill and Line - Part 1

Fill and Line - Part 2

Fill and Line - Part 3

Text Formatting - Part 1

Text Formatting - Part 2

Field Formatting - Part 1

Field Formatting - Part 2

Field Formatting - Part 3

Field Format - Part 1

Field Format - Part 2

Field Borders

Format Painter & Show

Arranging Objects - Part 1

Arranging Objects - Part 2

Aligning Objects

Forward/Back, Group, Lock

Tab Order

Value Lists - Part 1

Value Lists - Part 2

Value Lists - Part 3

Value Lists - Part 4

Layout Clean-up - Part 1

Layout Clean-up - Part 2

Printing Layout - Part 1

Printing Layout - Part 2

Printing Layout - Part 3

Sliding/Printing - Part 1

Sliding/Printing - Part 2

Non-Printing Objects

Page Numbering

Subsummary Part - Part 1

Subsummary Part - Part 2


Relational Databases


Related Databases - Part 1

Related Databases - Part 2

Terminology

Tips & Notes

Planning

One-to-Many - Part 1

One-to-Many - Part 2

One-to-Many - Part 3

Portals - Part 1

Portals - Part 2

Many-to-Many - Part 1

Many-to-Many - Part 2

Many-to-Many - Part 3

Many-to-Many - Part 4

Self-Joining - Part 1

Self-Joining - Part 2

Related Field in Layout

Data Conduit - Part 1

Data Conduit - Part 2

Data Conduit - Part 3

Lookups - Part 1

Lookups - Part 2


Introducing Calculations


Using Calculations

Specify Calculation Dialog

Syntax & Conventions

Text Examples - Part 1

Text Examples - Part 2

Text Examples - Part 3

Number Examples - Part 1

Number Examples - Part 2

Aggregate & Summary - 1

Aggregate & Summary - 2

Logical Examples

Status Examples - Part 1

Status Examples - Part 2


Introducing Scripts


What Are Scripts

Scriptmaker - Part 1

Scriptmaker - Part 2

Script Steps

Planning Scripts

Storing Settings - Part 1

Storing Settings - Part 2

Storing Settings - Part 3

Buttons - Part 1

Buttons - Part 2

Advanced Script - Part 1

Advanced Script - Part 2

Advanced Script - Part 3

Advanced Script - Part 4

Advanced Script - Part 5

Advanced Script - Part 6

Advanced Script - Part 7

Advanced Script - Part 8

Advanced Script - Part 9


Creating Databases for Others


Access Privileges - Part 1

Access Privileges - Part 2

Access Privileges - Part 3

Sharing Files on Network









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 6 at £79.95

| rss feed | add to google toolbar Add latest courses to Google Toolbar | After Effects Projects |

• TutorRoom© 2005 •