AIN2601 SUMMARY WITH SOLUTIONS

AIN2601
Practical Accounting Data Processing

Exam: 1 November 2018 11:30-13:30

,Index

Part 1: Data Management and Utilisation.......................................................................................................................2
Study Unit 1: Data and the computerised information system process.......................................................................2
Study Unit 2: The database environment....................................................................................................................8
Study Unit 3: Utilising databases...............................................................................................................................21
Part 2: Spreadsheets.....................................................................................................................................................23
Study Unit 4: Creating user-friendly spreadsheets....................................................................................................23
Study Unit 5: Spreadsheet formulas and functions...................................................................................................28
Study Unit 6: Spreadsheet security, risks and controls..............................................................................................47
Part 3: Transaction Processing.......................................................................................................................................50
Study Unit 7: Overview of transaction processing.....................................................................................................50
Study Unit 8: Revenue and receipts cycle..................................................................................................................55
Study Unit 9: Acquisition and payments cycle...........................................................................................................72
Study Unit 10: Inventory and production cycle.........................................................................................................87
Study Unit 11: Payroll and personnel cycle................................................................................................................91
Study Unit 12: Finance and investment cycle............................................................................................................95
Study Unit 13: Financial reporting infrastructure......................................................................................................98
Study Unit 14: Selecting an appropriate accounting information system................................................................101
Study Unit 15: Getting started on Pastel partner.....................................................................................................104
Study Unit 16: Customers, suppliers, inventory and general ledger accounts.........................................................111
Study Unit 17: Process transactions........................................................................................................................112
Study Unit 18: Retrieve information and sundry processing...................................................................................113
Part 4: Management Reporting Systems.....................................................................................................................114
Study Unit 19: The value of information in the decision-making process................................................................114
Study Unit 20: Extensible business reporting language...........................................................................................114




Page 1 of 118

,Part 1: Data Management and Utilisation
Study Unit 1: Data and the computerised information system process




Characteristics of valuable information:
 Accessible
 Accurate
 Complete
 Economical
 Flexible
 Relevant
 Reliable
 Secure
 Simple
 Timely
 Verifiable


Page 2 of 118

, Page 3 of 118