Basic Level (FM-BG-2D)
2-day "Comprehensive" £450+VAT (*1-day "Crash" £245+VAT)

Web Design Training

 

2-day Course Topics

Content Summary: Plan, organise and input your data.
Results: A handful of databases from template.

Ideal for: Studio managers, marketeers, admin and PAs.

 

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

Back to top >>

 

OTHER FILEMAKER PRO TRAINING COURSES:

COMPLETE LIST OF COURSES >>

NEW VERSION: 14.0.3
Released: September 30, 2015

""

FILEMAKER PRO V.14

FileMaker Pro v11 Pack

New Features Summary:

  • Greater and speedier automation
  • Mobile function integration
  • More designs
  • Solutions at a glance and at your fingertips
  • Greater control
  • Continuous connection with your data

" "

"I found the training very useful and feel like I have learned a lot."

Mathieu Demeurs-King
FILEMAKER PRO:
Basic Level, 2-days

" "