FileMaker Pro 6 or 7 - Introduction to creating databases uk training course

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

FileMaker Pro is a leading database management tool for the Macintosh and PC. Its popularity lies in the simplicity with which beginners can start creating databases. Nevertheless, as of FileMaker Pro 7, this database management application has joined the league of industial-sized databases and offers a wide range of features on top of 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 7. 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 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.

Information on Pricing, Location and Booking for this course.

Other FileMaker Pro courses

FileMaker Pro training at XChangeTraining

Enquire about or book
this course here

FileMaker Pro 7 - 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

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
-Adding header and footer parts
-Creating summary layouts
-Creating envelope and label layouts
-Adding buttons to a layout
-Linking commands to buttons

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
-Ponfiguring Browser options Styles, data views, search
-Layouts and sort behaviour
-Controlling access privileges

Advantages of learning FileMaker Pro with XChangeTraining

-XChangeTraining offers Filemaker Pro 7 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 3 months after course.
-We get consistently good feedback from our clients.
Read client testimonials...

Training Pricing

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

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

Training centre pricing
Pricing for training at the Britton Street facility:
1 person £449 for a 1 day course*
2 people £549 for a 1 day course*
3 people £649 for a 1 day course
4 people £749 for a 1 day course
5 people £849 for a 1 day course
6 people £949 for a 1 day course
All prices subject to VAT

Training Centre address
17-18 Britton Street,
Clerkenwell, London
EC1M 5NQ

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

* For courses held outside of London for less than 3 trainees, there is an additional charge of £75, plus a standard return train fare and/or taxi fare may be applicable.

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

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

FileMaker Pro 7 - Introduction to creating databases training course Outline

Related FileMaker Pro training courses — Bespoke

Advantages of learning FileMaker Pro with XChangeTraining

Training Pricing