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

FileMaker Pro 8.5 Essential Training
Illustration by Bruce Heavin

FileMaker Pro 8.5 Essential Training

with Cris Ippolite

Video: Welcome

FileMaker Pro has been around almost as long as personal computers. Now in its mid-20s, the application offers new and powerful additions to its impressive and mature feature set. FileMaker Pro 8.5 Essential Training with Cris Ippolite gives comprehensive coverage of the program's primary principles and functions. From understanding the concept of a database and building and browsing records to designing smart user interfaces, from defining and validating fields to calculating and scripting essentials, Ippolite demonstrates and clarifies both the big picture and the finer points of database management with FileMaker Pro 8.5. The training also teaches users about a feature that is new to FileMaker 8.5--the Web Viewer--which allows the addition of a live web page within a record. Exercise files accompany the training.
Expand all | Collapse all
  1. 11s
    1. Welcome
      11s
  2. 16m 41s
    1. What is a database?
      3m 8s
    2. Flat vs. relational databases
      1m 52s
    3. Essential Preferences
      2m 49s
    4. Interface Tour
      8m 52s
  3. 1h 6m
    1. Creating databases from templates
      2m 25s
    2. Creating databases from scratch
      4m 32s
    3. Ramifications of deleting tables
      1m 38s
    4. Defining fields and field types
      8m 45s
    5. Creating auto entry fields
      7m 57s
    6. Auto-entering calculated values
      3m 10s
    7. Field Filtering
      3m 59s
    8. Looking up values from other fields
      3m 29s
    9. Field validation and custom messages
      6m 49s
    10. Validation options: Always vs. Only during data entry
      2m 59s
    11. Storage options (Global fields)
      5m 3s
    12. Indexing options for Fields
      5m 38s
    13. Modifying fields
      2m 58s
    14. Organizing fields
      4m 3s
    15. Creating, editing and locking records
      1m 57s
    16. Deleting records and backing up files
      1m 33s
  4. 1h 58m
    1. Creating layouts
      2m 18s
    2. New layout wizard
      35m 45s
    3. Exploring layout tools and status area
      16m 31s
    4. Arranging, grouping, and locking layout objects
      10m 29s
    5. Layout Setup Dialog
      8m 29s
    6. Parts overview
      6m 52s
    7. Text formatting
      2m 33s
    8. Placing and formatting objects and graphics
      2m 37s
    9. Formatting fields and applying field attributes
      8m 22s
    10. Field behaviors
      4m 45s
    11. Creating and using Tab Control
      11m 29s
    12. Using auto-complete
      3m 2s
    13. Tab order
      5m 33s
  5. 42m 33s
    1. Basic find
      7m 33s
    2. New requests in Find mode
      4m 17s
    3. Search symbols
      3m 16s
    4. Constraining and extending find requests
      3m 19s
    5. Finding matching records without Find mode
      2m 30s
    6. Find and replace
      2m 25s
    7. Sorting with one criteria
      2m 56s
    8. Sorting with related fields
      2m 11s
    9. Sorting with multiple criteria
      6m 7s
    10. Sorting using custom values
      3m 7s
    11. Sorting using buttons
      4m 52s
  6. 24m 41s
    1. Creating static value lists
      2m 44s
    2. Creating a value list from a field
      2m 26s
    3. Using value lists from other files
      1m 36s
    4. Displaying second fields only
      2m 45s
    5. Field control set up
      11m 6s
    6. Additional uses of value lists (sorting, field validations)
      4m 4s
  7. 30m 17s
    1. Print layouts
      1m 2s
    2. Previewing pages and print options
      3m 12s
    3. Printing lists
      1m 42s
    4. Printing details
      1m 42s
    5. Sliding objects
      2m 33s
    6. Printing merge letters
      3m 52s
    7. Printing labels and envelopes
      2m 30s
    8. Subsummary reports
      13m 44s
  8. 40m 40s
    1. Definition of a calculation
      2m 36s
    2. Exploring the calculation dialog window
      7m 6s
    3. Date and time functions
      9m 44s
    4. Text functions
      4m 27s
    5. Get functions
      4m 19s
    6. Logic functions
      8m 45s
    7. Summary fields and functions
      3m 43s
  9. 43m 37s
    1. Understanding scripts
      2m 26s
    2. Understanding script steps
      1m 43s
    3. Assigning script steps to buttons
      3m 28s
    4. The ScriptMaker dialog window and creating multi-line scripts
      5m 1s
    5. Subsummary script
      5m 44s
    6. Open script
      2m 32s
    7. Adding find criteria to a script
      5m 13s
    8. Using script parameters
      5m 56s
    9. The Send Mail script step and menu option
      3m 10s
    10. The script steps for saving as XLS or PDF
      8m 24s
  10. 35m 51s
    1. ER diagrams
      3m 34s
    2. Primary and foreign keys
      9m 58s
    3. Creating relationships using the FileMaker Relationship Graph
      5m 49s
    4. Tables vs. table occurrences
      1m 35s
    5. Using related fields
      10m 22s
    6. Go to related Records / Go to found set of related records
      4m 33s
  11. 15m 25s
    1. Creating portals
      8m 22s
    2. Creating and deleting records via portals
      7m 3s
  12. 8m 28s
    1. Creating a new window
      3m 46s
    2. Scripting a new window
      2m 49s
    3. New window limitations
      1m 53s
  13. 19m 49s
    1. Security overview
      2m 18s
    2. Understanding default accounts
      2m 5s
    3. Setting up accounts, privilege sets, and external privileges
      9m 55s
    4. Managing accounts
      2m 33s
    5. File options
      2m 58s
  14. 2m 13s
    1. Understanding the project
      2m 13s
  15. 33m 13s
    1. Introduction to the FileMaker Web Viewer
      28s
    2. Using the Web Viewer
      8m 55s
    3. Setting up the Web Viewer using templates
      3m 33s
    4. Configuring the Web Viewer setup dialog
      3m 45s
    5. Setting up the Web Viewer using custom URLs
      6m 19s
    6. The Web Viewer in different modes
      8m 12s
    7. Setting Web Viewer script steps
      2m 1s
  16. 11m 53s
    1. Integrating Flash and Filemaker
      11m 45s
    2. Goodbye
      8s

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 ...
Watch the Online Video Course FileMaker Pro 8.5 Essential Training
8h 31m Beginner Oct 17, 2006

Viewers: in countries Watching now:

FileMaker Pro has been around almost as long as personal computers. Now in its mid-20s, the application offers new and powerful additions to its impressive and mature feature set. FileMaker Pro 8.5 Essential Training with Cris Ippolite gives comprehensive coverage of the program's primary principles and functions. From understanding the concept of a database and building and browsing records to designing smart user interfaces, from defining and validating fields to calculating and scripting essentials, Ippolite demonstrates and clarifies both the big picture and the finer points of database management with FileMaker Pro 8.5. The training also teaches users about a feature that is new to FileMaker 8.5--the Web Viewer--which allows the addition of a live web page within a record. Exercise files accompany the training.

Topics include:
  • Understanding database concepts Using FileMaker Pro template files Designing database layouts Choosing file options Finding and sorting data Creating value lists Printing basics Calculation and scripting essentials Defining data relationships Database security
Subjects:
Business Databases
Software:
FileMaker Pro
Author:
Cris Ippolite

Welcome

Closed captioning isn’t available for this video.

There are currently no FAQs about FileMaker Pro 8.5 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.


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 Already a member? Log in

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 8.5 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 preferences from 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.

Learn more, save more. Upgrade today!

Get our Annual Premium Membership at our best savings yet.

Upgrade to our Annual Premium Membership today and get even more value from your lynda.com subscription:

“In a way, I feel like you are rooting for me. Like you are really invested in my experience, and want me to get as much out of these courses as possible this is the best place to start on your journey to learning new material.”— Nadine H.

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.