FileMaker Pro 11 - Getting Started

FileMaker Pro 11 is a user friendly and powerful software database. This course has been designed to give you a solid grounding in FileMaker Pro 11, and assumes you have no prior knowledge of the programme. It is an ideal way to prepare for both personal and small business use, covering all of the major areas of the programme. Upon completion of the course you will be able to confidently create and use a database unique to your requirements.

Modules:

• Module One: Introduction to Databases

We start at the basics, examining what a database is and how they can benefit you. The first steps are to identify the problem, analyse it and design and create new database, exactly to your specifications with the maximum benefit to you.

• Module Two: Creating a field

We show you how to plan your database, the types of fields, and how and when to use them

• Types of fields
  • Standard: date, text, number and calculations
  • Special: Common fields, Global fields, Repeating fields and Container fields
• Module Three: Layout

How the layout can enhance the performance of your database, and all of the different options.

• Set Up
• Duplicate
• Delete
• Arrangement
• Tab
• View and Navigation
• Module Four: Design Tips

And our expert tutor will share his design tips, meaning your database looks as good as it performs.

• Inspector
• View
• Position
• Graphics
• Part

• Module Five: Search and Sort

One of the main benefits of a database is the ability to perform a range of comprehensive searches quickly and easily,

• Standard
• Quick Find
• Wildcards
• Range
• Constraint and Extend
• Module Six: Data Entry

As you may not be the only person using this database, we teach how to make it as user friendly as possible with the different methods of data entry available.

• Standard: edit, drop down list, pop up menu, check list and radio button
• Auto entry
• Validation and Customising messages
• Calculated
• Module Seven: Output

to ensure the output meets your needs, from reports to envelopes.

• Report
• Print Form
• Design
• Sort
• Sliding Objects
• Envelope
• Highlight Records
• Export as Excel and PDF
• Module Eight: Background Structure

And how to use Scripts to automate the database, making decisions on behalf of the users.

• Script – Introduction of IF statement
• Revise Relationships
• Module Nine: Importing Records

When you have mastered all of this, you will be keen to use FileMaker Pro 11 in many areas and so we teach you how to import existing electronic data into your new databases.

• PDF
• Excel
• Other database formats. For example, Microsoft Access.