For experienced users of Aeries Query, covers applying advanced filters, hiding columns, and applying other tricks to a query statement. Also, will cover pivot tables in Excel and importing and exporting data using Excel with a focus on data evaluation.
- Exporting Query results to Excel and Access
- Using various Access tools to analyze and manipulate data
- Using Excel to create Pivot Tables, Pivot Charts, and filter data using Slicers
- Using Access to import Aeries created Excel Files to create Cross Tab and Multiple Table Queries
PDF documentation for this session is attached.