Go to XChangeTraining Home Page
Main XChange Training Logo White

0845 363 1130 • info@xchangetraining.co.uk
Book a creative publishing course by clicking here Desktop Publishing Training Resources Learn more about us and our training centre in central London, UK Contact XChangeTraining
Spacer
Spacer between logo and content

FileMaker Pro 9 - Introduction to creating databases training course— Bespoke

FileMaker Pro is a leading database management tool for the Macintosh and PC. Version 9 builds on the strengths of version 8 which saw Filemaker Pro join the class of industrial-sized databases. Its popularity lies in the simplicity with which beginners can start creating databases. Filemaker Pro now offers and ever wider range of features while maintaining its still very intuitive user interface.

This course is aimed at users who want to be able to confidently use and customise existing database solutions or to start building their own simple databases with FileMaker Pro 9. This course covers all the core areas of previous Filemaker Pro 8 courses offered by XChange Training while also looking at the new features available to users of Filemaker Pro 9, such as the new layout tools and learning centre. Basic Scripting and relational issues will also be covered.

By the end of this one day course, you will be able to create a FileMaker Pro 8 database file with custom fields, that provides functionality for a variety of business applications that you have specified. You will also be confident making the next steps into more complex database design.

Arrow style bullet pointInformation on Pricing, Location and Booking for this course.

Arrow style bullet pointView all FileMaker Pro training courses

 Spacer image on FileMaker Pro training at XChangeTraining page
FileMaker Pro training at XChangeTraining
 

Horizontal Red Line
Image of book: Filemaker Pro 8 for Windows and Macintosh: Visual QuickStart Guide
As part of our dedication to offering you the very best learning experience, XChange Training offer every trainee a copy of Filemaker Pro 8 for Windows and Macintosh: Visual QuickStart Guide when they attend this course.
For more information on this and other quality course books offered by XChange Training, click here.
Horizontal Red Line

FileMaker Pro 9 - Introduction to creating databases training course Outline

The following is a general outline. The range of topics covered during your training is dependent upon student level, time available and preferences of your course booking.

Introduction
-Understanding database terms and concepts opening and browsing a FileMaker Pro database
-Different working modes and data views
-Menus and tools
-FileMaker Pro version compatibility

Working with a database
-Entering and deleting data in a record
-Adding new records
-Copying and pasting data and using view index
-Deleting and sorting records
-Finding data using multiple search requests and search
-Operators for more complex searching omitting records from a found set
-Previewing and printing records
-Importing data
-New Table Import features

Creating a new database
-Planning the database
-Different field types
-Field options such as auto-entry, validation and storage
-Creating value lists for a field
-Renaming and duplicating fields
-Adding calculation and summary fields
-Importing data from text/spreadsheet files and other FM Pro databases
-Integration with Microsoft Office
-How FileMaker Pro saves information

Working with Layouts
-Creating new Form and Columnar list layouts
-Using the layout tools
-Aligning elements accurately and sliding items
-Formatting fields on the layout
-Setting the field tab order
-Adding text and graphics to the layout
-New Field & Object Alignment Tools
-Adding header and footer parts
-Creating summary layouts
-Creating envelope and label layouts
-Adding buttons to a layout
-Linking commands to buttons

 Spacer image

Creating a relational database
-Relational vs flat file databases
-File lookups or related fields
-Creating relationships between files
-Setting relationship behaviour
-Adding lookup properties to fields
-Using fields from related databases in a layout
-Creating and using portals on a layout

Basic Scripting in FileMaker Pro
-About ScriptMaker
-Understanding the power and scope of scripts
-Modifying scripts
-Creating simple finding and sorting scripts
-Importing scripts from other databases
-Linking scripts to buttons
-Using sub-scripts and scripts from other files
-Creating conditional scripts

Network and web sharing
-Multi-user database sharing on a network
-Publishing FileMaker Pro databases on the Internet or an intranet
-Configuring Browser options Styles, data views, search
-Layouts and sort behaviour
-Controlling access privileges

Other New Features in Filemaker Pro 9
-Append to PDF for data reporting
-Send Link feature for database sharing
-Conditional Formatting of Fields
-FileMaker Web Viewer
-FileMaker Learning Center
-Visual Spell checks
Horizontal Red Line

Related FileMaker Pro training courses — Bespoke

Below you'll find an up-to-date list of related bespoke training courses in London or throughout the UK offered by XChange Training. Just click on a link to view course details:

Arrow style bullet pointFileMaker Pro 7 - Introduction to creating databases training course
Arrow style bullet pointFileMaker Pro 9 - Introduction to creating databases training course
Arrow style bullet pointInCatalog Training Course
Arrow style bullet pointInData Training Course
Arrow style bullet pointWoodWing Smart Catalog Training Course
Arrow style bullet pointXcatalog Database Publishing Training Course
Arrow style bullet pointXdata Database Publishing Training Course

  [For Pricing, Location and Booking information click on a course link above.]

 

Horizontal Red Line

Advantages of learning FileMaker Pro with XChangeTraining

-XChangeTraining offers Filemaker Pro 9 training only by experienced database developers, guaranteeing not only an expert knowledge of FileMkaer but also a high level of database knowledge in general.
-It's solutions based: before you come to XChange Training we agree the course content with you based on your needs.
-XChange training focuses on real tasks that reflect how the software is used in professional print situations.
-On-site and off-site training is available for the whole UK.
-Free email support service for 6 months after course.
-We get consistently good feedback from our clients.
 Read client testimonials...

Horizontal Red Line Spacer

Training Pricing

On-site course pricing
Prices include a set of course notes per trainee, 6 months telephone and/or e-mail support service after the course, all refreshments and lunch if held at the training centre.

For training onsite courses outside of London a standard return train fare and/or taxi fare may be applicable.

Training centre pricing
Pricing for training at the Clerkenwell facility:
1 person £449 for a 1 day course
2 people £549 for a 1 day course
3 people £599 for a 1 day course
4 people £649 for a 1 day course
5 people £699 for a 1 day course
6 people £749 for a 1 day course
7 people £799 for a 1 day course
8 people £849 for a 1 day course
All prices subject to VAT

  

Training Centre address
5 St John's Lane
Clerkenwell, London
EC1M 4BH

Tel: 0845 363 1130
Email: info@xchangetraining.co.uk

Arrow style bullet pointCourse Location Map Link

For courses held outside of London for less than 3 trainees, an additional charge may be applicable depending upon the location - please ask for details.

Training Booking
To reserve a place on a training course, please click the link at right or contact us by telephone or email on the details above. You will then be contacted shortly to confirm the booking.

 Enquire about or book
this course here
Spacer
Horizontal Red Line

All prices offered for business users and exclude delivery and VAT. E&OE
©XChange Training 2012. All Rights Reserved. | Privacy Policy