Jet Essentials Introduction
£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)
Sorting
Development: Advanced Dynamic Reporting
Grouping Reports
Summing and Subtotalling
Final Development Steps (Report Options, NP(Eval), Graphs, etc)
Multilevel Grouping Reports