Toggle menu

Introduction to FileMaker Pro

£449.00 + VAT

About Introduction to FileMaker Pro

To learn the basics of creating and using FileMaker Pro databases, including understanding database “jargon”, defining tables and fields, performing searches, creating forms, list and report layouts and learning to control the consistency and appearance of data.

Upcoming Course Dates

Please contact our Training Coordinator by emailing: trainingenquiries@western.co.uk

£449.00 + VAT

Book Now
  • Description
  • Course information
  • Introduction to FileMaker Pro

    Course Objectives
    To learn the basics of creating and using FileMaker Pro databases, including understanding database “jargon”, defining tables and fields, performing searches, creating forms, list and report layouts and learning to control the consistency and appearance of data. The course also includes an introduction to creating relationships between tables to share information across layouts, the charting feature of FileMaker Pro and simple automation procedures using button actions.

    Course Requirements
    None, this course is delivered on a Mac, but it is also suitable for PC users.

    How Do I Book?
    To book a training course, please call our Training Coordinator on 0117 922 5661 or alternatively send an email to trainingenquiries@western.co.uk 

  • Course Duration: 2 Days

    Course Contents

    Basics
    Definitions: databases, tables, records & fields; field types
    Quick Start screen
    Creating a new database
    Creating a database from an Excel spreadsheet
    Modes and Views
    Adding and deleting records
    Pre-defined templates
    Creating, modifying and editing records
    Sorting / finding records using different search criteria
    Security

    Layouts
    Layout mode
    Examining existing layouts
    Creating and modifying layouts
    Layout Wizard
    Layout Types
    Report and List layouts
    Creating Tabbed layouts
    Applying field, border, text, number and Conditional formatting

    Buttons
    Simple Button actions
    Basic buttons and scripts
    Usine pre-defined buttons

    Enhanced searches
    Further searching techniques
    Include and Omission searches
    Using multiple search criteria
    Multiple requests
    Using Saved Finds

    Controlling entry of field data
    Setting up Value Lists & Calendar Popups
    Entering date and page number codes
    Entering data from the last visited record
    Auto-entry of data and calculated values
    Validation

    Calculation fields
    Text vs. number calculations
    Using arithmetic and formulae
    Comparisons with Excel
    Introduction to some basic functions

    Record sets
    Using the Replace Field Contents command
    Updating – fixed value, serial numbers
    Updating according to a calculated formula

    Summary fields and summarised reports
    Summary field basics
    Making a summarised report
    Sub-summaries and how they work
    Sort options

    Creating simple charts
    The charting tool
    Creating simple pie, bar, horizontal bar, line and area charts
    Adding titles to axes and charts
    Formatting charts

    Relational databases
    Basics
    Defining relationships between tables and understanding the Match field
    Understanding one-to-many and many-to-one relationships
    Using portals and lookups

    Merge options
    The importance of layout structure
    Merge field basics
    Placing merge fields on the layout
    Printing label sheets using basic field information
    Structuring a mail-merge letter

    Production
    The 'live' issue
    Backing up
    Restoring