Filemaker Pro Course

FileMaker Pro Training Course

FileMaker Pro is a powerful database application that allows businesses to manage different kinds of data information. The information includes contacts, inventory, projects, purchases, sales orders, and much more.

After completing the FileMaker Pro training course, you will learn how to construct database with multiple tables, design data entry forms, prepare management reports and exchanging data with Microsoft Excel.

It is an ideal course for users wants to manage the database system sharing in a workgroup.

FileMaker Pro Training Course

What you’ll learn

Working with tables

  • Creating tables
  • Defining fields
  • Auto-enter settings
  • Calculated fields
  • Container fields
  • Looked-up value
  • Data validation
  • Defining repeating Fields

Working with records

  • New, edit, delete records
  • Defining search criteria
  • Efficient search using search operators
  • Omitting records
  • Sorting records

Working with multiple tables

  • Setting relationship amongst tables
  • lookup data from another tables

Drawing Techniques

  • Using different drawing tools
  • Colorize objects and lines

Layout Setup

  • Changing layout names
  • Showing / hiding layouts
  • Setting default view

Working with layouts

  • Create reports for different devices
  • Inserting fields
  • Using Inspector
  • Using Drop-down list / pop-up menu
  • Using checkboxes and radio buttons
  • Using drop-down calendar
  • Setting data formats
  • Text formattings
  • Managing and aligning objects, fields and buttons
  • Objects formattings
  • Repeating fields

Advanced Layout Design

  • Understanding and using Parts
  • Working with the three basic parts
  • Using leading grand summary
  • Using trailing grand summary
  • Using sub-summaries

Exchanging Information with other Applications

  • Importing and exporting Excel data
  • Exchanging data with other FileMaker Pro files

SCHEDULES
 
MFM8022 - 廣東話 13 Feb enrol
 
MFM8032 - Eng 27 Mar enrol
 
MFM8052 - 廣東話 09 May enrol
 
MFM8061 - 廣東話 21 Jun enrol
RELATING COURSES
  Access
  FileMaker Pro for iOS and Desktop Devices