FileMaker Pro 11: Level 1

COURSE OUTLINE:

Description This one-day course teaches you how to build FileMaker Pro databases and how to use existing databases. You will build a multiple-table database by defining tables and fields and entering and importing data. You will then learn to search for and sort records, design data entry layouts and produce list and mail-merge reports.

Prerequisites
This class is ideally suited for people with basic computing skills, such as using a mouse and opening and closing windows. No FileMaker Pro or database experience is required.

Learning Objectives
FileMaker Pro is a cross-platform, multi-user relational database development tool that is powerful and easy to use. The FileMaker Training Series classes are an in-depth series of hands-on classes designed to take you to the next level of FileMaker expertise and prepare you for the FileMaker Certified Developer exam.

Course Content


PLANNING AND CREATING A DATABASE

Preparing to build a database
Introduction to creating tables, fields and relationships
Setting auto-enter and validation options

ADDING RECORDS TO A DATABASE

Entering data
Dreating new records
Duplicating and deleting records
Importing data
Replacing data
Converting Excel spreadsheets

FINDING AND SORTING RECORDS

Entering Find requests
Using comparison operators
AND vs. OR requests
Using Omit
Understanding the 'Found Set'
Constraining and extending the found set
Sorting records

WORKING IN LAYOUT MODE

Adding and rearranging fields and labels in layouts
Formatting fields
Adding graphics
Ceating new list and mailing label layouts
Using merge fields
Sending reports as PDFs