BIC Administrator Training

Who will benefit by attending this course?

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. To give you a holistic view of the tool, you should first attend the Report Manager training.

Course Pre-requisites

• An understanding of Relational Databases
• Basic knowledge of ODBC drivers and DSN’s
• Basic knowledge of MS SQL Server
• General understanding of business practices
• Intermediate Microsoft Excel knowledge

• Administrator Module Overview
• Installation and Version Numbers
• Components and Relational dynamics
• File and folder structure
• Update repository
• Administrator module functionality
• Layout of the Administrator Module
• Data Connection; Data Containers and Data Expressions
• Maintaining Data Expressions
• Working with Alchemex Containers
• Auto Connection
• Create a Multiple Table Data Container
• Case Study
• Linking to other Data sets
• PL Utilities
• Software Upgrades
• Report download community

Download registration form

Terms and Conditions Unless otherwise specified, all prices include VAT All course manuals are included in the class-room course fee Learners may be required to bring their own consumable items such as a writing pad, pens, etc. Payment for training is strictly to be paid at least a week before commencement date No Cancellations will be accepted, the full course fee will be charged – although substitutions may be made Lemay’s Training Centre reserves the right to cancel any course should there be an insufficient number of delegates booked for a course. Courses will only be run if there are sufficient learner numbers Additional Modules can be arranged should there be enough of a demand or arrangements can be made for 1 on 1 training Additional Modules - Manufacturing, Point of Sale, Multi Currency, Receipting, Serial Number Tracking, Time and Billing, General Ledger Manager, Multi Stores available on request Assessments & Certification Assessments are based on information taught in the classroom and not necessary based on the training material Marking of the exams will take between 2 to 4 weeks Accreditation Refresher & Bridging Assessments will be based on the previous and current versions Should it be required that you need to write an assessment after a course, you will need to do so within 30 days after the end of the course. No extensions will be granted Students are required to purchase and book assessments The pass mark is 75% A student needs to write an assessment in order to obtain certification for attending a course