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

  • Microsoft SharePoint Server: 2007 & 2010

    Microsoft SharePoint Server: 2007 & 2010

    SGD $99.00

    Course Description

    Microsoft Office SharePoint Server 2007 is an integrated suite of server capabilities that can help improve organizational effectiveness by providing comprehensive content management including sharing of documents, photos and calendar events. This tutorial series covers the end user basics of this collaborative content management server. SharePoint “unleashes a suite of capabilities that dramatically improves the way people work”. Help improve organizational effectiveness by providing comprehensive content management including sharing of documents, photos and calendar events. Know how to collaborate with SharePoint!- Learn about the features and functions offered in Microsoft SharePoint - Find out how to improve your productivity using Microsoft SharePoint - Understand the functionality of the tools in Microsoft SharePoint - Know how you can adopt SharePoint into your daily work This course is SkillsFuture Credit Eligible.

    Read more...

  • Cubase 8

    Cubase 8

    SGD $45.00

    Course Description

    Steinberg's Cubase Elements 8 is their entry level, professional digital audio workstation. It contains all the aspiring musician and mix engineer requires to get started with audio and midi recording compositions. This VTC course covers installation issues and preference setting before moving on to connecting the program to a relevant soundcard. As the course progresses, functions such as creating busses and the implementation of the inspector are looked at prior to focusing on building a project.Learn how to work with audio files with Cubase 8. - Know how Cubase 8 handles audio files- Learn how to edit your own audio files with Cubase 8- Discover the potential of Cubase 8 with your audio files- Master audio editing with all the right tools and techniques in Cubase 8

    Read more...

  • Microsoft Visual Basic for Applications (VBA)

    Microsoft Visual Basic for Applications (VBA)

    SGD $45.00

    Course Description

    The Microsoft Office suite of applications (Word, Excel, PowerPoint, and Access) allows users to customize views or output, but the processing performed by the applications cannot be changed. However, Microsoft provides an interface in which the user can create customized processing. The language used for this customized processing is based on a computer programming language called Visual Basic. The Microsoft programming environment, called Visual Basic for Applications, has a special format and syntax that must be followed in order for the computer to properly perform the work. This VTC course describes the reserved keywords, structures, and language aspects that a user would need to know in order to create customized processing for Microsoft Office applications. Work Files are included. 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 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.