Overview

Our Introduction to FileMaker Pro course assumes no prior knowledge of FileMaker or of databases in general. It gives users a thorough grounding in using FileMaker databases, setting up new database files, defining fields and creating layouts and reports.

Course Outline

Database structure

Essential database concepts, Databases vs. database files, Creating a database file, Defining fields, Using field types, What are relationships, Efficiency of using relationships

Editing records

Creating and deleting records, Modifying records, Navigating through records, Navigating with shortcut keys, Using Auto Enter options, Using lists for data entry

Layouts and reports

How FileMaker uses layouts, Modifying the default layout, The layout environment, Changing layout options, Creating a letter layout, The Merge Field command, Using the field tool, Creating a label layout, Creating a report layout, FileMaker's layout parts, Layout set up, Layout order

Sorting and Finding

Using the Find command, Searching for multiple criteria, Finding ranges, Uses of the Found Set, Specifying sort criteria, Unsorting records, Exporting and importing records

Relationships

Overview of relationships, Defining relationships, Including related fields, Using lookups