FileMaker Pro 6.0: Level 1


Performance-Based Objectives

Upon successful completion of this course, students will be able to:

•    Access data in an existing database.
•    Locate records and groups of records that meet specific criteria.
•    Create a new database that includes multiple records and multiple layouts.
•    Create database layouts by positioning and formatting fields.
•    Add graphic and text elements to layouts.
•    Create several layouts that can be output to display data for various needs.
•    Create a columnar report layout that includes sub-summary data for specified groups of records.

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 Content

Lesson 1: Maintaining a Database
Topic 1A: Browse Records
Topic 1B: Add Records
Topic 1C: Edit Records
Topic 1D: Sort Records
Topic 1E: Print a Report

Lesson 2: Finding Records
Topic 2A: Find Records Meeting All Specified Criteria
Topic 2B: Specify an OR Search
Topic 2C: Refine Found Sets

Lesson 3: Setting Up a Database
Topic 3A: Create a New Database File
Topic 3B: Import Data
Topic 3C: Calculate Field Data Automatically
Topic 3D: Create an Automatic Numbering Field
Topic 3E: Control Field Validation

Lesson 4: Formatting Fields
Topic 4A: Position and Resize Fields
Topic 4B: Format Fields
Topic 4C: Format Value Lists
Topic 4D: Create Repeating Fields
Topic 4E: Set Tab Order

Lesson 5: Adding Graphics and Text to Layouts
Topic 5A: Draw and Position Graphic Elements
Topic 5B: Import Graphics
Topic 5C: Add Text Elements

Lesson 6: Creating Layouts for Mailing Form Letters
Topic 6A: Create Mailing Labels
Topic 6B: Create a Personalized Form Letter

Lesson 7: Creating Columnar Reports
Topic 7A: Create a Columnar Report Layout
Topic 7B: Create Summary Data
Topic 7C: Create Sub-summary Data