Jet Essentials Introduction

Course Duration is 1 Day

£595.00 Plus VAT

Business Benefit

This course will Help Report Designers to solidify knowledge of Jet Essentials and report design. Users will create a range of reports during the workshop.

How to Book

If you are interested in booking this course, then please select an available date and then click book now to complete the booking.

Who Should Attend

Anyone wanting to use Jet Essentials in Microsoft Excel.

Learning Outcomes – by the end of this course you will be able to…

Understanding fundamental concepts
Basic Dynamic Reporting
Understanding filters, tables and fields
Understanding Report Options

Course Content

Foundational Concepts
Jet Reports, Excel, Relational Databases
The Report Writing Procedure
Basics of a Mock-up Report
Adding to the Mock-up: Filters, Tables, and Fields
Final Predevelopment Steps (Options Page & Report Page Setup)
Development: Basic Dynamic Reporting
Replication and the NL Function
Summary Lists (and NL Data Functions)
Data Dump Lists (and the NF function)
Development: Advanced Dynamic Reporting
Grouping Reports
Summing and Subtotalling
Final Development Steps (Report Options, NP(Eval), Graphs, etc)
Multilevel Grouping Reports