FileMaker Pro Introduction 2 Days - London

FileMaker Pro Introduction 2 Days Overview

This 2-day Introduction course helps you learn about the tools and features available in FileMaker Pro. We will help you understand how this industry-leading program takes database management to a new level. We will guide you in learning the work area, and then move on to showing you how to create your own database with its own custom fields. Together, we will discuss the concept of 'relationships' in databases, as well as covering issues relating to database security and access privileges.

Upon successful completion of this course, you will be able to:

• Navigate the FileMaker Pro environment
• Define field formats and database tables
• Create and modify design layouts
• Add data, sort data, and delete data
• Import and export data
• Understand the scripting interface
• Produce database reports

Our goal is for you to be able to create and manage your own databases through a simple user interface.

Course Target Audience and delegate prerequisites

This course is intended for anyone planning to create or maintain a FileMaker database but who may have no previous experience with databases.

You will need basic PC or Mac skills, including a solid understanding of a computer's operating system (Windows or Mac OS). You will also need to know how to launch a program, create and save files, and copy files from CDs and other media.

 

FileMaker Pro Introduction 2 Days 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

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

• 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

What's Included

The following are provided for your best experience on this course:

• All computers for your use with choice of Windows or Mac systems
• Small class size (limited to a maximum of 4-8 attendees on all sessions)
• Quality reference manual for post course reference to take away with you
• 6 months post course support to assist you where needed
• Official Authorised Certificate for your successful completion of the course
• Lunch To give you the most flexible options for lunch we provide lunch vouchers which can be redeemed locally at a number of popular eateries including Pret A Manger, EAT, Starbucks, Tesco, Sainsburys, Boots and Greggs
• Refreshments to keep you on top form are available for you throughout the course with a full range of teas, coffees and biscuits
• Pads and pens

Daily course times run between 10am and 5pm with an hour break for lunch and both mid morning and mid-afternoon refreshment breaks. We recommend arrival at 9.45am for registration on the first day of the course.

Further details on benefits included with this FileMaker Pro course:

FileMaker Certified Instructor

Our trainers are FileMaker Specialists with years of experience teaching FileMaker. Get the database skills you need with our FileMaker professionals.

6 months support

Included with your course booking for all delegates on this course is 6 months free support so if you run into problems or need assistance relating to anything covered during your course we would be happy to assist you during this time.

Official Course Certificate

After your class with XChange Training you will receive our official Certificate as a record of your successful completion of the course.

Training Location

This course is provided at the XChange Training main London training centre based at:

5 St John’s Lane
Clerkenwell
London
EC1M 4BH

Click to View Full details of our London Training Venue and Course options

St John’s Lane is located in the heart of Clerkenwell close to the junction of Farringdon and Clerkenwell Road. Farringdon tube & train station is just a few minutes away and the training centre can also be accessed from Chancery Lane and Barbican tubes in about 10 minutes. There is also easy direct access by bus from Waterloo (243) and West End (55) with nearby stops.

Daily course times run between 10am and 5pm with an hour break for lunch and both mid morning and mid-afternoon refreshment breaks.

Scheduled Course Enquiry

If you are considering this FileMaker Pro Introduction 2 Days Course but would like further information simply send us your query quickly & easily with the form below. Whether you would like to check date availability, pricing, course suitability or just need further information about a course send us your query and we will get you a swift reply, usually within 2 business hours!

If you would prefer to check course details by phone please call us on 0345 363 1130.

Scheduled Course Name:	FileMaker Pro Introduction 2 Days
Course Location:	Scheduled - Farringdon, Central London
Scheduled Course Dates:	--Please Choose-- 02 Jul - 03 Jul30 Aug - 31 Aug15 Oct - 16 Oct10 Dec - 11 Dec
Knowledge level of delegate(s):	--Please Choose-- Beginner Some Notions Intermediate Advanced
Number of delegates:	--Please Choose-- 1 2 3 4 5 6 7 8 9 10+
Nature of enquiry:	--Please Choose-- Check Date Availability Course Information Request Price Enquiry Course Suitability Other
Lead contact name:
Email address:
Telephone number:
Company (if applicable):
Specific query details:
Captcha code	Please enter the Captcha code

 

Related Courses

Bespoke FileMaker Pro Training

Our bespoke course options for FileMaker Pro training are shown below:

Bespoke FileMaker Pro Training Courses

FileMaker Pro 15 Essentials Introduction 1 Day Training Course

FileMaker Pro 15 Introduction to Database Development 2 Day Training Course

FileMaker Pro 13 Essentials Introduction 1 Day Training Course

FileMaker Pro 13 Introduction to Database Development 2 Day Training Course

FileMaker Pro 11 Essentials Introduction 1 Day Training Course

FileMaker Pro 11 Introduction to Database Development 2 Day Training Course

FileMaker Pro 9 - Introduction to creating databases training course

FileMaker Pro 8 - Introduction to creating databases training course

Testimonials

Thank you for a brilliant course which I found very useful. The trainer was fantastic with excellent knowledge on Filemaker. I would advise anyone to go to XChange Training.

Alex Cardozo, The Met Police, Bespoke FileMaker Introduction Masterclass

Friendly and professional environment, well organised.

Paul Pritchard, Davidoff of London, FileMaker Pro - 2 Day Introduction

I am extremely happy with the whole process from enquiring to the course delivery. I can't fault my experience and would highly recommend.

Rachel Whitefield, Clarity Copiers, FileMaker Pro Introduction - Two Days

The trainer was easy to follow and very easy going, which creates a excellent training environment. I will certainly be coming back in the future. A great teacher and a great course!

Scott Godfrey, InDesign - 4 Day Masterclass

Excellent course content and structured in such a way that it is easy to understand for the beginner. Thank you for the excellent course.

Tami Penswick, Yahoo, HTML & CSS - 2 Day Introduction

I thought the training was excellent and was impressed by the knowledge of the instructor. I also found the adaptability to teach on images I brought with me extremely helpful. Many thanks!

Keith Baker, Science Press Ltd, Photoshop - 2 Day Introduction

Great trainer, great content and great practical exercises.

Amanda Cook, VMWare, Adobe Video Masterclass - 5 Day Introduction

Fantastic course which suited my requirements and I was able to pick up an understanding of the industry as well as the package. Would recommend it to anyone.

Justin Smith, Advanced Air, QuarkXPress - 2 Day Introduction

The instructor was clearly knowledgeable of their subject. Pacing was good and the content was applied to the different backgrounds of the people who were present. All staff were courteous - good facilities.

Bruce Fleming, Central Park Primary School, Photoshop - 2 Day Advanced

The trainer was very helpful and approachable and we got answers to all our questions. Great course!

Aspasia Valiasi, FilmFlex Movies, Photoshop - 1 Day Introduction