FileMaker Pro Training at The Learning Center

Currently Not Logged In (Click here to login to E-Learning)

The Learning Center of Las Vegas, Nevada offers Computer Professional and Certification training and testing for Microsoft, MCSE, MCAD, MCDBA, MCSD, .Net, CISCO, A+, Network+, and many applications including Microsoft Office.


Serving Your Training Needs Since 1985
Click on the links for the course you need information for: *FileMaker Pro 6.0 Beginning* *FileMaker Pro 6.0 Advanced* If a link doesn’t contain the information you require now, please check back soon or call 702-320-8885 for more details.

FileMaker Pro 6.0 Beginning

Length of Course:	1 day
Prerequisites:	Before taking this course, students should be familiar with the basic functions of their computer's operating system. Students should also have basic word processing skills, such as copying and pasting text, formatting text, etc.
Course Objective:	You have probably used a computer to gather, process, and share information. For example, you may have searched for product information on the Internet, totaled expenses using a spreadsheet application, or typed and printed a memo using a word processing application. You may now need to store a large amount of information in an organized manner so that you can quickly and easily sort the information in various ways, and locate specific pieces of information efficiently. In this case, you'll use FileMaker Pro to create and use databases to store and organize information so that it is available for efficient retrieval.

Course Outline:

Maintaining a Database

Browse Records

Add Records

Edit Records

Sort Records

Print a Report

Finding Records

Find Records Meeting All Specified Criteria

Specify an OR Search

Refine Found Sets

Setting Up a Database

Create a New Database File

Import Data

Calculate Field Data Automatically

Create an Automatic Numbering Field

Control Field Validation

Formatting Fields

Position and Resize Fields

Format Fields

Format Value Lists

Create Repeating Fields

Set Tab Order

Adding Graphics and Text to Layouts

Draw and Position Graphic Elements

Import Graphics

Add Text Elements

Creating Layouts for Mailing Form Letters

Create Mailing Labels

Create a Personalized Form Letter

Creating Columnar Reports

Create a Columnar Report Layout

Create Summary Data

Create Sub-summary Data

Return to the Top of the Page

FileMaker Pro 6.0 Advanced

Length of Course:	1 day
Prerequisites:	Before taking this course, students should have completed the FileMaker Pro 6.0 Beginning course. In addition, they should be familiar with the basic functions of their computer's operating system. Students should also have basic word processing skills, such as copying and pasting text, formatting type, etc. Finally, students should have basic knowledge of a Web design application or HTML.
Course Objective:	You have probably been using FileMaker Pro for a while, maintaining databases that other people have designed, and even designing some yourself. You may have created several databases to track information like contacts, inventory, or other information that you can't adequately manage using a spreadsheet or word processing application. However, you may be faced with a project where a single FileMaker database cannot handle the information you need to manage. For example, you may want to link customers with the purchases they make. If you have tried to place this information in a single database, you may have duplicated data unintentionally. In this course, you will use FileMaker Pro to create a system of integrated databases that can manage the information efficiently, and make it easy to alter the system as your needs change.

Course Outline:

Defining One-to-Many and Many-to-One Data Relationships

Define a Many-to-One Relationship

Display Related Information from a "Many" Database

Setting Up a Many-to-Many Database Relationship

Create an Intermediate Database

Access Data from a Related "Many" File

Summarize Related "Many" Data

Control Addition or Deletion of Related Records

Create Value Lists from Data in Related Files

Creating Buttons and Scripts

Create Buttons that Execute Commands

Create Scripts to Perform Complex Tasks

Create Buttons to Execute Scripts

Sharing FileMaker Pro Databases

Set Up a Database for Access by Multiple Users

How to Control Access to a Database

Creating a Database for the Web

Define Container and Global Fields

Enable the FileMaker Pro Web Companion

Determine the Look of a Published Database

Create a Custom Home Page for a Web-Enabled Database

Return to the Top of the Page

Legal Terms and Conditions