X Close Window

This document sets forth the Privacy Policy (the "Privacy Policy") for this Web site, www.xchangetraining.co.uk (the "Site"). If you have objections to the Privacy Policy, you should not access or use this Site. This Privacy Policy does not govern privacy practices associated with offline activities or other XChange Training UK Ltd web sites.

Our commitment

XChange Training UK Ltd are committed to ensuring the security and protection of the personal information that we process, and to provide a compliant and consistent approach to data protection. We have a robust and effective data protection program in place which complies with existing law and abides by the data protection principles.

XChange Training UK Ltd are dedicated to safeguarding the personal information under our remit with a data protection regime that is effective and fit for purpose with GDPR compliance.

Collection of personal information

As a visitor to this Site, you can engage in many activities without providing any personal information. In connection with other activities, such as course bookings, enquiries or subscribing XChange Training UK Ltd will ask you to provide certain information about yourself by filling out and submitting an online form with a consent request to contact you in compliance with GDPR law.

When you use the Site, XChange Training UK Ltd or third parties authorised by XChange Training UK Ltd may also collect certain technical and routing information about your computer to facilitate your use of the Site and its services. For example, we may log environmental variables, such as browser type and operating system of your computer. We use these environmental variables to facilitate and track your use of the site and its services. Without expressly informing you in each particular circumstance, we do not match such information with any of your personal information.

What personal information we collect

The information we collect is based on what you provide us which can include:

What we do with the information we gather

We require this information to understand your needs and provide you with a better service, and in particular for the following reasons:

Security

We are committed to ensuring that your information is secure. In order to prevent unauthorised access or disclosure, we have put in place suitable physical, electronic and managerial procedures to safeguard and secure the information we collect online.

Links to other websites

The Site contains links to other sites at which personal information is collected. In such instances, unless expressly provided to the contrary, the collection and use of your personal information will be governed by the privacy policy applicable to that site. That privacy policy should identify the entity that is collecting your personal information.

Use of cookies

XChangeTraining.co.uk is built without the use of cookies meaning when you visit this Site, you can browse the Site and access important information without revealing your identity.

Communications from the site

Users who no longer wish to receive our newsletter and promotional communications may opt-out of receiving these communications by replying to unsubscribe in the subject line in the email or email us at info@xchangetraining.co.uk.

In your correspondence, please indicate with as much detail as possible the location on this Site where you provided your personal information.

Entities collecting personal information

Personal information on this Site is collected by XChange Training UK Ltd who are located at: 5 St John's Lane, Clerkenwell, London, EC1M 4BH, United Kingdom and its phone number is: +44 (0)345 363 1130.

Controlling your personal information

If you have previously agreed to us using your personal information for direct marketing purposes, you may change your mind at any time by writing to or emailing us at info@xchangetraining.co.uk

We will not sell, distribute or lease your personal information to third parties unless we have your permission or are required by law to do so. We may use your personal information to send you promotional information about third parties which we think you may find interesting if you tell us that you wish this to happen. You may request details of personal information which we hold about you. If you would like a copy of the information held on you please write to XChange Training, 5 St John’s Lane, London, EC1M 4BH.

If you believe that any information we are holding on you is incorrect or incomplete, please write to or email us as soon as possible, at the above address. We will promptly correct any information found to be incorrect.

How your personal information is used

XChangeTraining.co.uk collects your information in order to record and support your participation in the activities you select. If you subscribe to a service or register a product, for example, the information is used to register your rights, if any, to technical support or other benefits that may be made available to registered users. Your personal information is also used to keep you informed about product upgrades, special offers, and other products and services of XChange Training UK Ltd and selected third parties if you have so opted to receive such communications.

XChangeTraining.co.uk may collect information about the use of the Site, such as the types of services used and how many users we receive daily. This information is collected in aggregate form, without identifying any user individually. XChange Training UK Ltd may use this aggregate, non-identifying statistical data for statistical analysis, marketing, or similar promotional purposes.

Privacy-related queries

XChange Training UK Ltd takes its users' privacy concerns seriously. If you believe that XChange Training UK Ltd has not complied with this Online Privacy Policy with respect to your personal information or you have other related inquiries or concerns, you may write to the XChange Training UK Ltd Privacy Officer at the address indicated above.

X Close Window

X
Close

XChange Training Location Manchester

Use Filemaker for versatile database management Customised workflows & processes Centralised data location Organise data to suit your business Marketing automation Quick data retrieval

FileMaker Pro Introduction 2 Days - Manchester

Key Course Details:

Level:

Introduction to Intermediate

Duration:

2
Days
- 10am to 5pm

Price:

£495 + 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.

    classroom image
  • 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
    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
  • Location Details

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

    Piccadilly House
    49 Piccadilly
    Manchester
    M1 2AP

    Piccadilly House is located in the heart of Manchester directly next to the Piccadilly Gardens transport interchange with excellent bus and tram connections and is easily accessed from Piccadilly train Station (5 mins). Victoria station is also close by (around 10 mins).

    Daily course times run between 10am and 4:30pm 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.

    View Full details of our Manchester Training Venue and Course options

    XChange Training Location Manchester

    ↑ Click the map to view a larger version ↑

    View our Manchester Centre Location on Google Maps

  • FileMaker Pro Introduction 2 Days - Upcoming Manchester Course Dates

    Next 15 May - 16 May £495 + vat
  • Client Reviews

    "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

    "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

    "Informative, personalized and excellent tuition provided. "

    Miles Walker, Travel Counsellors, Dreamweaver - 1 Day Introduction

    "Great one to one training which was really specific and which I can implement immediately to my everyday workload as soon as I get back in to the office!"

    Brunella Capozzi, Disney, Photoshop - 2 Day Bespoke

    "A great course which covered all the key basics that I was looking for."

    Adrian Stanley, Microsoft Project - 1 Day Introduction

    "I was very happy with the way the course was ran and felt everything I wanted to learn was covered. Our tutor was very helpful and friendly. Would definitely recommend to a colleague or friend."

    Jade Barnes, ANS Group, Adobe InDesign - Two Day Introduction

    "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

    "The course was well informed and our tutor was very knowledgeable and patient with all students. I would highly recommend this course and XChange Training for the future. "

    Jenni Prichard, Kinleigh Folkard & Hayward, Photoshop - 2 Day Introduction

    "Very well tailored to what we need to do in our jobs. The training was nicely split between listening to instructions and doing tasks."

    Erin McGann, Southbank Centre, InDesign - 1 Day Intermediate