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

  • Audio Mixing Essentials

    Audio Mixing Essentials

    SGD $54.00

    Course Description

    VTC's Audio Mixing Essentials is an advanced course on the often mysterious art of audio mixing. Instead of showing you how to open an equalizer plug-in in a specific program, this tutorial will show you how to use an equalizer (in any program) in order to improve the sound of your next mix. This course first discusses the mixing process and then uses two mixing examples to demonstrate mixing from start to finish (“This Too Shall Pass” by Mile High Chapter and “Night Train To Cairo” by Scot). The mixing of the second project is done in work files and referenced in the course so that they have no narration in order to place more attention on the audio adjustments being made. This course will give any novice recording engineer the tools, techniques, and knowledge to effectively mix professional sounding projects.Master the mysterious art of audio mixing. - Learn the tools and techniques of audio mixing- Know what to use to produce good audio - Discover the secrets of producing a quality audio - Learn the ropes of creating your own master piece with this course This course is SkillsFuture Credit Eligible.

    Read more...

  • Database Optimization

    Database Optimization

    SGD $45.00

    Course Description

    This Database Optimization course provides viewers with important techniques and checklists to configure, monitor, and manage their databases. You will learn how to develop a tuning strategy, explore the tuning and diagnostic tools, understand the relational database model and implications on performance, evaluate the application for efficient design, structure, and other factors affecting performance and evaluate hardware for effects on performance. Join us as we review best practices in designing, optimizing, and maintaining your database. You will benefit from this course whether you have some experience with optimizing databases or are just starting out. Work files are included. Learn how you can manage your database from becoming redundant. - Find out how you can mange your database- Learn ways to fully utlize your data's potential - Know how to analyze reports from your data - Learn how to apply formula, queries and commands into your database This course is SkillsFuture Credit Eligible.

    Read more...

  • Microsoft Visual Basic for Access 2010

    Microsoft Visual Basic for Access 2010

    SGD $40.00

    Course Description

    Microsoft Access allows a user to create many different items: tables, forms, reports, macros, and queries. However, the greatest power lies in Modules. Modules contain Visual Basic for Applications (VBA) code that runs in the background, performing more complex operations than any of the other items can perform. This VTC course will discuss how to do many different processes in VBA Modules, including creating customized data items and classes, as well as referencing data that exists in a separate database. 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...


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.