| Training & Development - Technical Training Curriculum
[Back to course listing]
FileMaker Pro 10, Beginning / Level 1
This course introduces basic database concepts, as well as how to plan and create
a new database in FileMaker Pro. Learn how to define and edit fields, how to use shortcuts
to enter and edit data, and how to find and sort records. You'll learn the Layout
mode to create reports and mail labels. You will be introduced to relational
database theory, and you will build a relational database using lookups, repeating
fields, and simple calculation fields.
Presenter(s): Frank Widman, Senior Technical Training Consultant
Prerequisites: Windows/Mac experience. Please note that this is designed to accomodate both Mac and Windows users. Windows users can take the class in the Mac lab, and Mac users can take the class in the Windows lab.
Enrollment: Use our Online
Registration Form,
or call 459-5565.
Additional Information: This class is intended for users on either PC or Mac. The software, class, materials and user interface are interchangeable in both labs.
Related Courses:
| Schedule |
| Date |
Time |
Fee |
Location |
August 4, 2011
November 16, 2011
April 19, 2012
|
9am - 4pm |
$25 |
Kerr Hall Room 8
|
Course Outline
- Introduction
- Course Objective
- Database Terminology
- Planning a Database
- Creating a Database
- Creating a new database file
- Defining fields in the database
- Understanding data types
- Entering Records
- Switching modes
- Speeding up data entry
- Entering data automatically
- Laying Out Data
- Resizing fields
- Moving fields
- Adding and deleting fields
- Creating a columnar report
layout
- Adding a title to the list
- Creating a List of Values for a Field
- Formatting a value list field
- Finding and Sorting
- Finding records
- Finding for multiple criteria
- Omitting records
- Sorting records
- Relational Database Introduction
- Understanding a relational database
- Key fields
- Relationship
- Creating a Relational Database
- The steps to creating a relational database
- Setting Look-Up Relationships
- The lookup process
- Define look-up fields
- Create a look-up relationship
- Calculation Fields
- Creating calculation fields
- Using functions in a calculation
- Formatting fields containing numbers
- Mailing Labels
- Create and format a label layout
- Format individual object in the layout
|
