Sequel Viewpoint Complete

Viewpoint Express helps you master the basics of Viewpoint—the graphical interface for Sequel—with a minimal time investment and flexible scheduling options. Once you have the basics under your belt, you’ll be able to access, analyze, and report on key business information with ease.

Topics covered include how to:

• Review the Viewpoint environment
• Review database concepts and terminology
• Use SQL to create powerful Views
• Format column results for impact and clarity
• Make calculations from simple to conditional
• Convert and manipulate dates
• Add run-time prompts
• Create Union Views (queries)
• Create summary results (using Group By, Host Tables, and Client Tables)
• Create Viewpoint output (using Excel add-in, Dashboards, and more)

Prerequisites:

• A high-speed Internet connection
• A screen resolution of 1024 x 768 or higher
• Current versions of Sequel and Viewpoint
• A workstation with dual monitors or a projector to display the teacher’s screen
• View design authority 
• Access to Viewpoint during class for hands-on exercises
• An IBM i user library where class objects can be saved
• Access to all objects (files and views) in the SEQUELEX library

This class follows an approach to learning that includes:

• Presentation and live demonstrations
• Hands-on activities on your own system
• Participant interaction with trainers during sessions