CPE Course on Computer Accounting and Auditing Techniques

The Committee on Information Technology of the Institute is pleased to announce a CPE Course on Computer Accounting and Auditing Techniques (CAAT) with the following thoroughly revised and revamped syllabus:
About CPE Course on CAT 1 Windows 2000/XP Intro to Facilities & Commonly used features 3 0 2 Using MS Excel as
an Audit Tool An Intro., Case Studies, Data Analysis & Reporting Features 18 12 3 RDBMS Concepts Database Concepts, Terminology, Models - An Intro; RDBMS, Data Modelling using ERD, DB Design using Normalization 6 0 4 MSAccess Creating Databases & Tables - An Intro; Event Handling & Report Generation; Using Macros - An Intro.; Using Queries - An Intro.; Case Study 15 12 5 Structured Query
Language (SQL) Introduction to Data Definition Language Statements & Data Manipulation Language Statements (Creating Tables, Selecting Data, Inserting Data, Updating Records, Dropping a Table, Querying Database, Aggregating Data, Grouping, Ordering Data, Joining Tables etc.) & Case Studies 15 12 6 CAAT Tools Capabilities & Importing Data from Accounting & other Application Systems - An Intro; Analytical Reports, Duplicates/ Gaps. Sorting & Charting; Stratification, Summarization, Statistics & Aging - An Intro.; Sampling, Macros, Audit Trail, Pivot Tables - An Intro. 43 40 Total Hours Allocated 100 76 100 76