0345 363 1130
info@xchangetraining.co.uk
FileMaker Pro Introduction 2 Days - Online
Key Course Details:
Level:
Introduction to Intermediate
Duration:
2
Days - 10am to 5pm
Price:
£425 + vat
Learn how to set up and maintain your own custom database without having to understand complicated programming commands. We will show you a simple user interface that lets you store, retrieve, and report the information your business needs. A perfect introduction for new database users.
After we guide you through the essentials of controlling the FileMaker Pro environment, we will show you how to design and configure your own database. Find out how easy it is to import and export data, to add security, and to grant access privileges to other users. You will even learn how to run custom reports and understand basic scripting. Get to grips with the power of databases the easy way!
Learn how to set up and maintain your own custom database without having to understand complicated programming commands. We will show you a simple user interface that lets you store, retrieve, and report the information your business needs. A perfect introduction for new database users.
After we guide you through the essentials of controlling the FileMaker Pro environment, we will show you how to design and configure your own database. Find out how easy it is to import and export data, to add security, and to grant access privileges to other users. You will even learn how to run custom reports and understand basic scripting. Get to grips with the power of databases the easy way!
-
FileMaker Pro Introduction 2 Days
Course Details
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.
-
Full 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
- 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
- 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
- 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
- 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
- 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
- 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
-
Location Details
This course is provided as a remote online course with live training provided by our Industry Professional.
Accessing the live online course anywhere is easy and all you will need is:
- Computer with the trial or full version of the software
- Separate screen or device for the shared video display
- Sound output via computer or headset
- Ideally a camera and microphone on the computer for remote contact
Our goal is for you to be able to create simple but professional documents that are ready to use for the web and for print.
It is important to note this is not a classroom based training.
-
FileMaker Pro Introduction 2 Days - Upcoming Online Course Dates
29 Jan - 30 Jan £425 + vat 24 Mar - 25 Mar £425 + vat 02 Jun - 03 Jun £425 + vat -
Client Reviews
"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
"I found the course very informative. I learnt a great deal in the one day which I will now endeavour to incorporate into our processes."
Ian Steer, The Stationary Office, Acrobat - 1 Day Intermediate
"The course was perfect for what we were looking for - the right level of detail without too much jargon!"
Sophie Blaken, E.ON, Dreamweaver for HTML Emails Introduction
"Great course which I enjoyed and also like the teaching methodology which was very participatory. The trainer was patient and welcomed as many questions from us as were needed! "
Ellen Kandororo-Dingani , Royal Commonwealth Society, Dreamweaver - 2 Day Introduction
"I was first sceptical of this course, with regards to the knowledge I would gain in such a short time, but having taken this course, I could not have been happier. The tutor was fantastic, very knowledgable and helpful. I would not only recommend XChange training but would consider doing further courses myself. "
Gary Carney, none, HTML & CSS - 2 Day Introduction
"Have thoroughly enjoyed attending the photoshop training course. The instructor was extremely helpful, friendly and knowledgable. I have gained lots of useful hints, tips and techniques to help me. Will happily recommend to others. Thank you."
Michaela Dixon, Motor Mart Ltd, Photoshop - 1 Day Introduction
"Trainer and content of the course were both excellent and exactly what I was after. With only two of us in the group we were really able to adapt the course to our personal needs and even work through real life examples. Would definitely recommend to any of my colleagues."
Claire Douglas, Centrica, Adobe Photoshop - One Day Introduction
"Absolutely loved the third day, and the very hands on practical examples that we worked through. Will really help aid my retention of this useful new skillset."
Louisa Pavis, HSBC Global Services, Storyline - 3 Day Introduction Masterclass
£425 + vat
Next Dates:
29 Jan - 30 Jan
24 Mar - 25 Mar
02 Jun - 03 Jun
Whats Included:
Live online remote tuition 
Certified hands-on training 
Small class size (max 4-8) 
6 months post course support 
Quality reference manual 
Authorised Course Certificate
Frequently Asked Questions
What are the course times?
For all online courses the normal session timings are 10am to 5pm with an hour break for lunch. In addition to the hour lunch break there are also two fifteen minute coffee breaks mid morning and mid afternoon.
Daily times are:
09.45 - Registration
10.00 - Course start
13.00 - Lunch
14.00 - Afternoon starts
17.00 - Course ends
Do you offer discounts
or promotions?
We offer a range of regular discounts available for self funding individuals, charities and education along with period special offers. See our promotions page for full details.
What is provided with this course?
For this online course you will need to have your computer ready with the relevant software (trial or full) and our live instructor will guide you through the skills remotely during the session. Files for use in the training will be made available in advance for download. After the course you will receive the authorised Certificate and 6 months direct post course support.
Does this course give
a qualification?
Although this course does not provide an actual qualification each delegate is provided with an official Certificate for completion of the course level.
Can you invoice my company?
In short yes we can provide 30 day invoice terms to any UK Limited company with the provision of your official purchase order and/or completing the invoice request for your booking online.
Adobe Design Ready in just 5 days!
Learn Adobe Design skills with our value Adobe Design Masterclass Bundle →