| CLASS DESCRIPTION |
|
|
 |
Learn the ins and outs of this powerful database application. Learn databse entry, organization, tables, and more! |
|
| WHO IS THIS CLASS FOR |
|
|
 |
Professionals who want to learn how to create and maintain a database from simple to complex relation databases. Knowledge of Macintosh or Windows operating systems is required. |
|
| LEVEL 1 - FOUNDATIONS |
|
LEVEL 2 - MODIFYING RECORDS |
|
Understanding Concepts
Planning a Database
Creating a New Database
Using & Creating a Template
Navigating in FileMaker Pro
Understanding the Different Modes
Entering Data into Database
Editing & Deleting Records
Saving a Database |
|
|
|
Selecting & Editing Records
Understanding & Changing Fields
Data Entry Shortcuts
Specifying Auto-entry Options
Updating and Changing Data
Deleting Data
Using Filters and Sorting |
|
LEVEL 3 - WORKING WITH RELATED
TABLES |
|
LEVEL 4 - USING QUERIES &
CALCULATIONS |
|
Understanding Database Relationships
Relationship Types
Creating Additional Tables
Exploring Normalization & Indexes
Use Lookups Between Files
Defining a Relationship
Create and Delete Records
Find and Omit Records |
|
|
 |
Understanding Queries
Finding Data Using a Single Criterion
Finding Data within a Range
Using Multiple Criteria for Searches
Omitting Records
Finding & Deleting Duplicate Records
Understanding Calculations |
|
LEVEL 5 - CREATING FORMS AND
REPORTS |
|
LEVEL 6 - WORKSHOP |
|
Improving Entry Layouts
Setting the Tab Order
Repeating & Summary Fields
Defining Value Lists
Create Buttons & Boxes
Using Predefined Layouts
Creating a New Layout
Modifying a Layout
Working w/ Graphic Objects
Using Merge & Format Fields |
|
|
| Bring in your own files or work on our demo project. Level 6 is available only as part of the Training Series, not as an individual level. Workshops do not qualify for our re-take policy. |
|
| |
| HOW DO YOU WANT YOUR CLASSES SERVED? |
    |
