FileMaker Pro 13: Beginner


  • FileMaker Pro 13: Beginner, Singapore SKillsFuture elarning online course
  • FileMaker Pro 13: Beginner, Singapore SKillsFuture elarning online course
  • FileMaker Pro 13: Beginner, Singapore SKillsFuture elarning online course
  • FileMaker Pro 13: Beginner, Singapore SKillsFuture elarning online course
  • FileMaker Pro 13: Beginner, Singapore SKillsFuture elarning online course
  • FileMaker Pro 13: Beginner, Singapore SKillsFuture elarning online course

Course Description

FileMaker Pro is powerful enough to handle most database jobs, yet easy enough to create simple solutions in minutes. This practical ’how to’ course by FileMaker expert John Mark Osborne starts from beginner level and uses a single invoicing example to demonstrate all the features in FileMaker Pro 12 and 13. Feature that include: field creation, finding, sorting, layout mode, container fields, auto entry, validation, printing, scripts, calculations, importing, exporting, interface design as well as new FileMaker Pro 13 features: charting, snapshot links and the inspector. Examples of the invoice file are provided at every stage of the creation process so the user can easily review one section without starting from the beginning.

Discover how data can be managed efficiently.

- Find out how you can manage your database
- Learn ways to fully utilize your data's potential
- Know how queries can be implemented to run the data better
- Understand an effective solution to optimize your database's productivity

This course is SkillsFuture Credit Eligible.


Course Objectives

1. Understand the introduction to FileMaker 
2. Know how to navigate the interface of FileMaker 
3. Know how to create, manage and edit a database
4. Know how to customized functions to the database


Related Courses

  • Discover Hidden Secrets of Microsoft Excel 2013

    Discover Hidden Secrets of Microsoft Excel 2013

    SGD $45.00

    Course Description

    This VTC course will give you the knowledge and skills you need to get the most out of Microsoft Excel 2013. You will learn about the Excel interface by working in it. You will create and format worksheets, make calculations, create charts, and use tools to analyze data in meaningful ways. Author Helen Bradley teaches Excel from a business perspective, focusing on tools that maximize productivity and accuracy. She demonstrates how to design worksheets intelligently and then shows you how to check for accuracy to ensure that worksheets return correct results. She also covers automating data entry, testing formulas, and using PivotTables for data analysis. She concludes with a discussion of SkyDrive and the Excel WebApp. Find out more about Microsoft's productivity tools!- Learn and understand the purpose of Microsoft's tools- Know more about the functionality and features of each application- Learn about functions that you never knew existed in Microsoft's tools- Be fluent and an efficient user in Microsoft tools by the end of this course 

    Read more...

  • FileMaker and PHP Foundations

    FileMaker and PHP Foundations

    SGD $45.00

    Course Description

    PHP is the most widely used scripting language on the web. It's accessible, well documented, and easy to learn. When FileMaker Inc. released their API for PHP a new door was opened to build rich web applications that interact with FileMaker Pro databases. This VTC course will introduce you to the PHP language, FileMaker's API for PHP, and best practices for Custom Web Publishing with PHP. Discover how data can be managed efficiently with PHP. - Find out how you can manage your database- Learn ways to fully utilize your data's potential - Know how PHP can be implemented to run the data better - Understand how PHP is an effective solution to optimizing your database's productivity This course is SkillsFuture Credit Eligible.

    Read more...

  • Google Docs & More: Maximize your online collaboration with Google

    Google Docs & More: Maximize your online collaboration with Google

    SGD $99.00

    Course Description

    Use Google Docs to create documents for collaboration with others online. Google™ Docs has numerous tools for editing and formatting your documents. In this online training series, we’ll learn to format text, add images, links, and comments. We’ll also explore tools for replacing words, checking spelling, and adding a table of contents. Make it easy to share your documents online and collaborate with others. We’ll explore some sharing options through email, invite individuals to collaborate, and manage our list of editors. You’ll also learn to assign ownership of a document, and set downloading options.Make it easy to share your documents online and collaborate with others!- Learn and understand the basics of Google Docs and their features- Be updated on the new kind of Web mail - Learn techniques of Goggle's spreadsheet functions - Know how Google™ Forms can bring productivity and results This course is SkillsFuture Credit Eligible.

    Read more...


Content

Introduction

Preview Available

+

About John Mark Osborne

System Requirements

FileMaker 13 Family of Products pt. 1

FileMaker 13 Family of Products pt. 2

About the Tutorial Series pt. 1

About the Tutorial Series pt. 2

Why an Invoicing Solution?

Work Files

What is a Database? pt. 1

What is a Database? pt. 2

Planning your Solution

New FileMaker 13 Features Overview pt. 1

New FileMaker 13 Features Overview pt. 2

New FileMaker 13 Features Overview pt. 3

New FileMaker 13 Features Overview pt. 4

Creating a Database

+

Quick Start

Considerations

New Empty File

Creating Fields

Housekeeping Fields pt. 1

Housekeeping Fields pt. 2

Adding Fields to a Layout

New Field Picker

Modifying and Organizing Fields

Working with a Database

+

Data Entry

Importing Data pt. 1

Importing Data pt. 2

Status Toolbar

Customizing the Status Toolbar

The Four Modes

Records Menu pt. 1

Records Menu pt. 2

Previewing Pages

New Layout pt. 1

New Layout pt. 2

Table View

Schema from Table View

Finding and Sorting

+

Basic Find

How the Index Works

New Requests

Range Finds

Wildcards

The Rest of the Operators

Found Sets without Find Mode

Constrain and Extend

Sorting Records

New Window

Quick Find

Save Find Requests

Snapshot Links

Layouts Beginner

+

Status Toolbar pt. 1

Status Toolbar pt. 2

Arrow Tool

Field Tools

Text Tool

Working with Text

Line Tool

Rectangles & Ovals

Merge Fields

Layouts Intermediate

+

Tab Control pt. 1

Tab Control pt. 2

New Slide Control

New Themes

Field Control and New Field Picker

Value Lists

Explicit Layout Size

Parts Overview

Adding & Modifying Parts

Layouts Menu pt. 1

Layouts Menu pt. 2

Format Menu

Layouts Advanced

+

Arrange Menu

View Menu pt. 1

View Menu pt. 2

Inspector Basics

Inspector - Position Tab pt. 1

Inspector - Position Tab pt. 2

Inspector - New Styles Tab and Themes

Inspector - Appearance Tab pt. 1

Inspector - Appearance Tab pt. 2

Inspector - Data Tab

Insert Menu

Positioning Objects Precisely

Button Tool

Web Viewer Tool

Smart Duplicate and Select Same

Working with Container Fields

+

Creating Container Fields

Inserting a Picture

Inserting a PDF

Interactive Files

External Files

Insert Other Files

New Popover Buttons

Auto-Entry

+

Serial Numbers pt. 1

Serial Numbers pt. 2

Value from Last Visited

Calculated Auto-Enter pt. 1

Calculated Auto-Enter pt. 2

Lookups pt. 1

Lookups pt. 2

RecordID and UUID

Validation

+

Strict Data Type

Not Empty/Unique and Existing

Ranges

Calculated Validations

Customizing Messages

Always vs. Data Entry

Printing

+

Printing Philosophy

Creating a Print Layout

Contact List pt. 1

Contact List pt. 2

Print Options

Labels

Adjusting Labels

Merge Letters

More Merge Letters

Tabs

Envelopes

Building a Report

Viewing a Report

Summarizing a Report

Varying a Report

Improved Contact List pt. 1

Improved Contact List pt. 2

Quick Charts

Charting in Reports

Scripting and Calculations

+

Definition of a Script

Basic Script

Script Steps with Depth

Evil Script Steps

Activating Scripts

Definition of a Calculation

Basic Calculation

Layout Navigation

Record Navigation

More Scripts

Manage Scripts

Deleting a Record

Printing a Layout

Open Script

Open Script Considerations

Close Script

Recreate the Status Toolbar

Case vs. If

Billing or Shipping Labels

Fixing the Label Calculation

Age Display

Birthdays Find

Importing and Exporting

+

Import and Export Defined

Importing FileMaker Files

Updating FileMaker Files

Importing a Folder

Importing Directly

Exporting Files

Group By

Export to HTML

Miscellanneous Features

+

Global Fields Defined

Custom Report Title

Multi-User Global Fields

Repeating Fields

Furigana

Spell Checking

Find/Replace

Send Email

Tooltips

Tab Order

Working with John Mark Osborne

+
Resource Files

Free Resources

Training

Consulting and Meta-Consulting

Solutions

Contacting Me

SkillsFuture Credit Eligible
SGD $76.00
(Price excludes GST)
GET ACCESS NOW
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.