JoinNow.pngMany of the examples in the video tutorials show actual student information. In order to navigate to the other pages and view the vides, you'll need to JOIN the wiki. On the upper left-hand corner of this webpage, you'll see the words "Join Now."


Overview

In FileMaker Pro, there are four different modes in which you can choose from when working with a database. They are Browse Mode, Find Mode, Layout Mode, and Preview Mode. Each of these modes will generate a different Menu bar with different options. This tutorial handout will mostly be focusing on the Browse and Find Modes, but with some emphasis on the Layout and Preview Modes.
Download Step Sheet

Workshop Agenda:

FileMaker Browse Mode
  • Command B
  • Rolodex
  • Record slider (Number of records)
  • Count
  • Find Button
  • Sort Button
  • Layout pull-down
  • View As buttons
  • Preview/Exit Preview
  • Window Zoom button
  • Mode Pull-down
  • Records Menu

Sorting Records
  • Command S

FileMaker Find Mode
  • Command F
  • Request Menu
  • this AND that (multiple find fields on the same find request)
  • this OR that (multiple find requests, same field)
  • Operators
  • Omit button
  • Sorting found set

Practice
Export from StudDir as tab-separated
Select fields to export
Make sure column headers are present, or add them
Drag/drop onto FMP

FileMaker Layout Mode
  • Command L
  • Layout Menu
  • Layout Types (table, list, blank layout, labels)
  • Merge << >>
  • Headers, Body, Footer
  • Preview/Exit Preview