AutoExcel offers you a good understanding of behind the scenes workings of the Pastel BIC module and how to connect to multiple databases for consolidation purposes. After completion of this workshop, you will be able to effectively create new containers as well as customise the existing containers to suite the individual requirements.

This course is for anyone responsible for the creation and maintenance of database connections and containers. These are later used in the creation of reports.
The Administrator training should be followed by the Report Manager training in order to give the delegate a holistic view of the Pastel BIC modules.

The Workshops cover the following aspects:

• Pastel BIC Overview

• Pastel BIC Installation

• Pastel BIC Version numbers

• Pastel BIC Components and Relational dynamics

• Pastel BIC file and folder structure

• Pastel BIC update repository
  Pastel BIC Administrator module functionality

• Layout of the Pastel BIC Administrator

• Pastel BIC Data Connection

• Data Containers and Data Expressions

• Maintaining Data Expressions

• Working with Pastel BIC Containers

• Pastel BIC Auto Connection

• Create a multiple table Data Container

• Creating SQL Expressions

• Case Study

• Data links to other data sets

• Registering Pastel BIC

• PL Utilities

• Software Upgrades

• Report download community

Pre-requisites needed – an understanding of Relational Databases
Basic knowledge of ODBC drivers; DSN's and MIS SQL Server
General understanding of business practices
Intermediate Microsoft Excel knowledge

Duration of course: One day (9:00 to 16:00)

AutoExcel offers you a good understanding of Pastel Accounting BIC Report Manager and it is aimed at training the person responsible for running reports and report maintenance, including report parameters and filters. This delegate should leave the workshop with the ability to create new reports from predefined data containers.

The Report Manager training is for a basic report writer who doesn't need to know about database tables and linkages.

The Workshops cover the following aspects:

• The Softline Pastel BIC Report Manager Environment

• Running your first Report

• Creating a Standard Report

• Useful Comparison Methods

• Adding and editing aggregate filters

• Managing your Reports

• Union Reports

• Hiding and Showing Reports

Each delegate will receive a manual and 3 month's email support. On completion of each course you will need to complete an assessment, on successful completion of the course and assessment you will receive a printable certificate.

For people wanting to create a new report, we recommend you do the Administrator training first and then the Report Manager training, as the Administrator. Module is the starting point to all reports.

Duration of course: One day (9:00 to 13:00)