Acknowledgment
At the outset, I would like to thank the INSTITUTE OF CHARTERED ACCOUNTANTS OF INDIA for organizing this course which served as a vibrant platform for learning the dynamic areas of computers relevant to us as future chartered accountants.
I would record my gratitude and respect to the chairman and course coordinator of this chapter for their guidance throughout the training session.
I would also acknowledge my gratitude to my faculty for their lectures and guidance throughout the course and their valuable advice in my practical sessions.
Also I would record my gratitude to my parents, friends and fellow trainees who are with me during all successes and failures.
INDEX
UNIT-1 : DATABASE APPLICATION USING MS-ACCESS 5
CHAPTER 1. ADVANCED SQL QUERIES 6
CHAPTER 2. DESIGNING FORMS AND REPORTS 10
CHAPTER 3. BUILDING CRITERIA EXPRESSIONS 14
CHAPTER 4. MACROS AND SWITCHBOARDS 19
UNIT-2 : ADVANCE MS-EXCEL 33
CHAPTER 1. WORKINGWITHXML………………………………………………………………………………………… 34
CHAPTER2. IMPORTING/EXPORTINGDATA………………………………………………………………………….. 39
CHAPTER3. ADVANCESINMACROS…………………………………………………………………………………….. 42
UNIT-3 : COMPUTER ASSISTED AUDIT TECHNIQUES 46
CHAPTER 1. INTRODUCTION TO CAAT 47
CHAPTER 2. DATA ANALYSIS AND AUDIT TECHNIQUES 50
CHAPTER 3. DATA ANALYSIS USING IDEA 53
UNIT-4 : CORE BANKING SOLUTION 58
CHAPTER 1. CBS BASICS AND ITS WORKING METHODOLOGY 59
CHAPTER 2. CBS INTERFACES-THEIR FUNCTIONALITY AND CONTROLS 63
CHAPTER 3. SYSTEMS AUDIT OF CBS AND ITS INTERFACES 66
UNIT-5 : ENTERPRISE RESOURCE PLANNING 68
UNIT-6 : OFFICE AUTOMATION APPLICATION AND IT APPLICATION IN CA’sOFFICE 77