Esperant Query & Reporting

An in-depth study of Esperant's query and reporting features through lectures, demonstrations, and practical assignments. Esperant is a query, reporting and analysis tool used for accessing SQL-compliant relational databases.

Duration: 1 day

Target Audience

Business professionals such as managers, financial analysts and administrative assistants.

Prerequisites

Basic knowledge of Microsoft^® Windows^TM.

Objectives

Students will learn how to use Esperant to create different types of business queries and format the results into presentation-quality reports and charts.

Key Topics

• A quick look at Esperant Data Views
• Creating queries of different types
  • Show query
  • What Percent query
  • Compare Against query
  • Show As Percent query
• Formatting query results
  • Modifying font, size, style and display format
  • Inserting headers and footers, bitmaps, text and borders
  • Moving objects around
  • Saving results in different PC formats
  • Creating charts and crosstabs
• Creating advanced queries
  • Creating run-time prompts
  • Using relative dates
  • Charting results
  • Drilling-down and drilling-up
  • Merging query results
• Using the Executive Desktop
  • Creating and running scripts

Also available in pdf format

Additional Information

For information about our courses or to register for a course, contact:

Each student in a Speedware course:

• Receives a course documentation kit as part of the registration fee
• Gets the opportunity to apply concepts through hands-on lab exercises
• Learns how to use the documentation for specific factual reference or for guidance on the job.