Synopsis
FOCUS: Basic Report Preparation shows users how to create simple reports using FOCUS.

Audience
This course is for anyone who is interested in learning about basic report preparation using FOCUS.

Time
3 hours

Product Code: FOCS03
After completing FOCUS: Basic Report Preparation, the user should be able to:

Describe the various course conventions
Identify the screens used by the various course databases
Use the TABLE command to initiate report requests
Use the PRINT and LIST verbs to print the field values in report requests
Use the SUM, ADD, WRITE, and COUNT Verbs in report requests
Describe the basic sorting process of data
Explain the various printing techniques used for creating reports
Use the IF statement and WHERE clause to screen records
Explain the various uses of the WHERE clause

Course Conventions and Databases
Course conventions
Course databases

Starting a Simple Report
The TABLE request
PRINT and LIST

Printing Values
SUM, ADD, WRITE, and COUNT
Basic sorting

Creating Report Requests
Additional printing techniques

Record Selection
WHERE and IF conditions
Uses of the WHERE clause

This course has the following features:

A glossary
A Skill Assessment

FOCUS: Getting Started (FOCS01)
FOCUS: Working with FOCUS (FOCS02)

FOCUS: Creating Simple Reports (FOCS04)
FOCUS: Creating Complex Reports (FOCS05)
FOCUS: Additional Reporting Techniques (FOCS06)
FOCUS: Fundamentals of Graphs (FOCS07)
FOCUS: Advanced Graph Topics (FOCS08)
FOCUS: Data Manipulation for Reporting (FOCS09)
FOCUS: Advanced Screening Techniques (FOCS10)
FOCUS: Creating File Definitions (FOCS11)
FOCUS: Adjusting File Definitions (FOCS12)
FOCUS: Accessing External Files (FOCS13)
FOCUS: Basic MODIFY Requests (FOCS14)
FOCUS: Segment Modification (FOCS15)
FOCUS: Complex MODIFY Requests (FOCS16)
FOCUS: Additional File Maintenance (FOCS17)
FOCUS: Dialogue Manager and FIDEL (FOCS18)
FOCUS: More Features of FIDEL (FOCS19)
FOCUS: MAINTAIN Facility (FOCS20)
FOCUS: Completing a MAINTAIN Application (FOCS21)

© 1999-2004 SK Max. All rights reserved.

General IT

Web Design

Microsoft Certs

Desktop Computing

Business Skills

Personal Skills

Combo Packages

Business Videos

Articles

Features

Instant Mentoring

Benefits

FAQs

HTML

A+

Windows 2000

Excel 2000

Office 2000

More Courses

e-Learning Links

e-Learning Forum

Certification Info

Other Resources

Home PageContact InformationSearch the Site
HomeOur Course Cataloge-Learning EdgeFree CoursesStudent Centere-ResourcesCorporate Information