» Workshops On Demand
» Filemaker Workshops - Hands-On
» Filemaker mini-lessons:

Introduction to FmPro 7/8:
» Browsing, Sorting and Finding Records
» Creating a New Database
» Designing Layouts
» Adding Shapes and Color
» Creating Mailing Labels and Form Letters
» Adding Functionality with Scripted Buttons
» Importing Records and Converting an Externally-Related Database to the new Internal Tables Model
Interface Design:
» Designing a Tabbed Template
» Changing Field Tab Order and Modifying Visual Attributes
» Adding Non-Printing User Tools to a Layout
» Grouping and Text Effects
Data Validation Strategies:
» The Auto Entry Serial Number Field Option
» The Auto Entry Date Function
» Using Values From Previous Records to expedite data entry
» Specifying AutoEnter Values for Defined Fields
» Restricting Data Types
» Using Value Lists and Creating Conditional Value Lists
Relational Concepts: Internal Tables vs. External Files:
» Defining A Relationship
» Viewing information from a "One" Table in a "Many" Table
» Creating a Portal to Display Many Related Records from within a One Record Per Entity Table
» Using Import/Export to Convert Information From a Flat File Database to a Relational Database
» Using More Than One Match Field to View A Subset of Records in a Portal
» Using a Multikey Match Field
» Using a Sorted Relationship to Specify a Particular Record in a Set of Related Records
» Linking Tables with Many-to-Many Relationships
» Using Portals to enter data in a many-to-many relationship
Report Writing:
» Creating a Basic Columnar Report
» The importance of indexing to improve search and report speed
» Creating a Grand Summary
» Creating a Report with a Subsummary Part
» Using the GetSummary function
» Creating a Crosstabular Report
New Features of Instant Web Publishing in FMPro 7/8:
» Creating a Web-enabled Database
» Hiding the Status Area and specifying an opening layout for Instant Web Publishing
Scriptwriting:
» Creating and Editing a Find/Sort Script
» Combining Predefined and User-defined criteria in a Find Script
» Creating a Menu Layout
» Creating Script Modules and calling Subscripts
» Using Loops and Conditional Statements
» Using Global Fields to Customize Report Layouts
Special:
» Create an email list from Banner and send mail to a specific found set

» Free Online lessons for Microsoft Word, Excel, Powerpoint, Publisher, and Access courtesy of Oregon State University

» Free Online Courses
» Creating RSS News Feeds
» Creating a Web Log on Darkwing with Blosxom

Computer Training Opportunities

In order to meet the needs of faculty and staff to improve their skills or learn new ones, Human Resources is involved in ongoing efforts to provide software applications training relevant to changing needs, and at prices affordable to departments. For more information regarding software applications training offered through Human Resources, and to provide feedback on relevant training needs, contact Kathy Cooks, Programs Specialist, by e-mail at computertraining@hr.uoregon.edu or 346-2939.

RAA web-based training

Human Resources arranged a web-based online project with RAA Training. After evaluating the feedback from the pilot program, Human Resources has extended the online training agreement for another year. The program provides access to three libraries, each of which includes several courses on relevant topics. This program provides online software training for a 12-month period of time beginning with your registration confirmation date.The three libraries are:

1. PC and Business Skills includes all versions of Microsoft Windows, Microsoft Office (Word, Excel, Access, PowerPoint, Outlook), and other applications;

2. IC3 serves as preparation for the Internet and Computing Core Certification (IC3) and provides fundamental computer concepts;

3. A+ -- offers training for those interested in studying to become an A+ certified computer technician.

For detailed information on rates, registration, questions and answers, and to review the RAA Training library descriptions, consult the Human Resources Training and Development website at: http://hr.uoregon.edu/training/raa.html . PLEASE NOTE: Since online training is potentially available to employees 24 hours a day, seven days a week, supervisors and their employees should discuss how training time will be counted as work time.

New Horizons Computer Learning Centers

Human Resources has purchased vouchers from New Horizons for software applications training. These vouchers can be used in Portland, Beaverton, Salem and Eugene. They are available for purchase by the departments for use by faculty and other staff. The New Horizons $63.00 (1-day class) and $126.00 (2-day class) charge per person will be billed to your department. The upper division classes, such as Dreamweaver, Day 4 (level 3), and Crystal Reports (a 2-day course), require three vouchers, for a total cost to UO employees of $189.00 per person. This affordable price is made possible by the Employee Benefit Fund, which is paying part of the cost. Participants will be using a laptop with a mouse. To register, view the course outlines, suggested pre-requisites and charges, go to our web page http://hr.uoregon.edu/training/upcoming.html .

Your department index code is required to reserve a seat. Due to limited seating, a refund will only be given if a cancellation is received in writing five working days prior to that class date, by sending e-mail to computertraining@hr.uoregon.edu .

If you have questions, you can reach Kathy Cooks at 346-2939.