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
 
MFM7111 - 廣東話 09 Nov enrol
 
MFM7113 - Eng 25 Nov enrol
 
MFM7112 - Eng 28 Nov enrol
 
MFM8022 - 廣東話 13 Feb enrol
 
MFM8032 - Eng 27 Mar enrol
RELATING COURSES
  Access
  FileMaker Pro for iOS and Desktop Devices