Filemaker Pro 7.0 – Level 1

Learning Method: Instructor-led Classroom Learning Duration: 1.00 Day


Overview:

For the beginning FileMaker student, learn to create and use databases to store and organize information. Set up a database, find records, format fields, create mailing labels, and create columnar reports.

Who Should Attend:

The target student for this course is office personnel who work with personal computers, and who need to store and organize information for their individual use, but who have little or no experience using FileMaker Pro. They may have experience using office productivity applications, such as a word processor or spreadsheet program, but probably do not have experience using other database applications.

At Course Completion:

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.

Course Outline:

Lesson 1: Maintaining a Database

  • Browse Records
  • Add Records
  • Edit Records
  • Sort Records
  • Print a Report

Lesson 2: Finding Records

  • Find Records Meeting All Specified Criteria
  • Specify an OR Search
  • Refine Found Sets

Lesson 3: Setting Up a Database

  • Create a New Database File
  • Import Data
  • Calculate Field Data Automatically
  • Create an Automatic Numbering Field
  • Control Field Validation

Lesson 4: Formatting Fields

  • Position and Resize Fields
  • Format Fields
  • Format Value Lists
  • Create Repeating Fields
  • Set Tab Order

Lesson 5: Adding Graphics and Text to Layouts

  • Draw and Position Graphic Elements
  • Import Graphics
  • Add Text Elements

Lesson 6: Creating Layouts for Mailing Form Letters

  • Create Mailing Labels
  • Create a Personalized Form Letter

Lesson 7: Creating Columnar Reports

  • Create a Columnar Report Layout
  • Create Summary Data
  • Create Sub-Summary Data
Site Loader