Start learning with our library of video tutorials taught by experts. Get started

FileMaker Pro 12 Essential Training
Illustration by Richard Downs

FileMaker Pro 12 Essential Training

with Cris Ippolite

Video: Welcome

Hi! I am Cris Ippolite, and welcome to FileMaker Pro 12 Essential Training. FileMaker Pro is the leading desktop database software popular for its ease of use that's used by everyone from Fortune 500 companies to individuals who just want to be a little bit more organized. In FileMaker Pro 12 Essential Training, we will be working with a bunch of integrated data based around a database that we will create from scratch. We will start by taking a look at how to manage the various types of fields used to store your data, including how to set up containers that can be used for storing rich media.
Expand all | Collapse all
  1. 9m 32s
    1. Welcome
      1m 3s
    2. Introducing the FileMaker family
      2m 57s
    3. Touring the FileMaker Quick Start screen
      2m 40s
    4. Explaining the new file format change
      1m 45s
    5. Using the exercise files
      1m 7s
  2. 23m 50s
    1. What is a database?
      2m 49s
    2. Comparing flat and relational databases
      4m 26s
    3. Reviewing how FileMaker works
      5m 18s
    4. Touring essential preferences
      3m 7s
    5. Exploring the interface
      8m 10s
  3. 10m 45s
    1. Creating databases from templates
      3m 9s
    2. Creating new databases in spreadsheet format
      4m 26s
    3. Adding tables by importing
      3m 10s
  4. 6m 45s
    1. Determining which tables your solutions will need
      3m 33s
    2. Creating tables in the the Tables tab of the Manage Database window
      3m 12s
  5. 29m 15s
    1. Understanding relationship types
      4m 9s
    2. Diagramming relationships with entity-relationship ER diagrams
      7m 7s
    3. Understanding key fields
      4m 19s
    4. Determining which key fields you need
      3m 11s
    5. Defining primary and foreign keys
      4m 54s
    6. Creating relationships using the relationships graph and table occurrences
      5m 35s
  6. 32m 37s
    1. Deciding what fields you will need
      4m 6s
    2. Understanding field types
      6m 2s
    3. Defining fields
      7m 22s
    4. Using Auto Enter options in fields
      9m 32s
    5. Using field validation options
      5m 35s
  7. 31m 24s
    1. Using container fields in your database
      8m 3s
    2. Working with container inspector options in Layout mode
      9m 54s
    3. Applying field options and using remote container storage
      13m 27s
  8. 13m 23s
    1. Creating and duplicating records
      5m 26s
    2. Editing and locking records
      4m 9s
    3. Deleting records and backing up files
      3m 48s
  9. 20m 17s
    1. Importing data
      9m 8s
    2. Importing records to refresh data
      5m 59s
    3. Exporting data
      5m 10s
  10. 31m 55s
    1. Introducing layouts
      4m 51s
    2. Working with themes in new layouts
      4m 49s
    3. Using the Layout Assistant to create List views
      6m 22s
    4. Using the Layout Assistant to create labels and envelopes
      6m 18s
    5. Applying themes to existing layouts
      9m 35s
  11. 25m 50s
    1. Using the Layout Setup dialog
      6m 51s
    2. Understanding layout parts
      6m 31s
    3. Previewing the new Inspector
      1m 22s
    4. Exploring layout tools and the Status Area in Layout mode
      5m 19s
    5. Managing layouts and layout folders
      5m 47s
  12. 1h 0m
    1. Using guides and arranging, aligning, grouping, and locking layout objects
      13m 46s
    2. Applying Screen Stencils
      4m 3s
    3. Placing and formatting objects, parts, graphics, and image fills
      10m 41s
    4. Applying gradients
      2m 25s
    5. Formatting fields and applying field attributes
      7m 27s
    6. Understanding object states
      2m 18s
    7. Setting field behaviors
      3m 58s
    8. Using the Tab Control feature
      11m 17s
    9. Setting the tab order
      5m 1s
  13. 41m 24s
    1. Using the basic find functions
      8m 9s
    2. Reviewing new requests in Find mode
      5m 26s
    3. Establishing search operators
      6m 56s
    4. Constraining or extending found sets
      2m 56s
    5. Finding records using date, time, or timestamp criteria
      5m 50s
    6. Using Fast Match and Quick Find
      6m 12s
    7. Saving find requests
      5m 55s
  14. 17m 1s
    1. Sorting with one criterion
      4m 40s
    2. Sorting with related fields
      2m 23s
    3. Sorting with multiple criteria
      2m 26s
    4. Sorting using custom values
      3m 1s
    5. Sorting using buttons
      4m 31s
  15. 16m 38s
    1. Introducing control styles
      5m 40s
    2. Creating and applying static value lists
      5m 18s
    3. Creating and applying dynamic value lists
      5m 40s
  16. 26m 7s
    1. Previewing pages and print options
      5m 28s
    2. Printing in different views
      2m 9s
    3. Applying object sliding and visibility
      7m 0s
    4. Printing merge letters
      5m 20s
    5. Saving as a PDF or Excel file
      6m 10s
  17. 38m 27s
    1. Building simple reports with summary fields
      5m 36s
    2. Creating subsummary reports
      7m 3s
    3. Adding charts to reports
      10m 23s
    4. Creating subsummary reports in Table view
      3m 40s
    5. Creating quick charts in Table view
      11m 45s
  18. 54m 58s
    1. Introducing calculations
      2m 46s
    2. Exploring the Calculation dialog window
      6m 20s
    3. Using number functions
      10m 29s
    4. Using date and time functions
      5m 43s
    5. Using text functions
      12m 35s
    6. Using get functions
      5m 26s
    7. Using logic functions
      11m 39s
  19. 1h 3m
    1. Introducing scripts and script steps
      2m 21s
    2. Assigning script steps to buttons
      6m 12s
    3. Understanding the Scriptmaker dialog window
      9m 40s
    4. Creating multi-line scripts
      8m 39s
    5. Adding find criteria to a script
      8m 12s
    6. Using the New Window script step
      10m 58s
    7. Understanding the If script step
      6m 45s
    8. Using script parameters
      4m 28s
    9. Reviewing the Send Mail script option
      5m 57s
  20. 23m 10s
    1. Introducing script triggers
      2m 9s
    2. Using object-based triggers
      10m 49s
    3. Using layout-based triggers
      6m 40s
    4. Using file-based triggers (Open and Close scripts)
      3m 32s
  21. 49m 44s
    1. Using related fields
      6m 32s
    2. Creating portals and using portal filtering
      10m 30s
    3. Using related fields in calculations
      6m 14s
    4. Understanding multipredicate relationships
      9m 31s
    5. Using the Go to Related Record script step
      6m 31s
    6. Adding charts with related data to layouts
      10m 26s
  22. 1m 16s
    1. Goodbye
      1m 16s

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
please wait ...
FileMaker Pro 12 Essential Training
10h 28m Beginner May 29, 2012

Viewers: in countries Watching now:

In this course, Cris Ippolite walks through the essential FileMaker Pro skills, from creating tables to managing fields and records and working with layouts. The course shows how to find and sort data, create reports, import and export data, create scripts, and diagram relationships, and more.

Topics include:
  • Comparing flat vs. relational databases
  • Creating databases from templates
  • Determining what tables you need
  • Understanding relationship types
  • Defining key fields and creating relationships between tables
  • Creating fields
  • Using new FileMaker 12 container fields
  • Creating, duplicating, editing, and deleting records
  • Importing and exporting data
  • Managing layouts and layout objects
  • Applying new FileMaker 12 themes to layouts
  • Finding records and working with found sets
  • Building reports and charts
  • Authoring calculations
  • Creating and triggering scripts
  • Working with relationships in scripts, calculations, and charts
Subjects:
Business Databases
Software:
FileMaker Pro
Author:
Cris Ippolite

Welcome

Hi! I am Cris Ippolite, and welcome to FileMaker Pro 12 Essential Training. FileMaker Pro is the leading desktop database software popular for its ease of use that's used by everyone from Fortune 500 companies to individuals who just want to be a little bit more organized. In FileMaker Pro 12 Essential Training, we will be working with a bunch of integrated data based around a database that we will create from scratch. We will start by taking a look at how to manage the various types of fields used to store your data, including how to set up containers that can be used for storing rich media.

Then we'll take a look at how to best manage layouts to display your data, first using the included themes and then building a custom layout from scratch. I will show you how to build interesting and attractive reports, including some summary reports and charts, and we will take a close-up look at how to set up relationships between tables and then some of the powerful advantages available to you when working with relational databases. And now, without further delay, it's time for us to dive into FileMaker Pro 12 Essential Training.

There are currently no FAQs about FileMaker Pro 12 Essential Training.

 
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.
Upgrade now


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

join now Upgrade now

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed FileMaker Pro 12 Essential Training.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Notes cannot be added for locked videos.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.