ACDA ACL稽核分析師 -稽核證照-電腦稽核專家JACKSOFT

ACDA 認證制度

<上一頁>　4/4

什麼是你必須知道的觀念?

Work with the ACL interface, including the Project Navigator, Results tab, and Log
Create an ACL project
Create table layouts to access:
- Access databases
- Excel spreadsheets
- Flat fixed-length files
- Report (print-image) files
Import, copy, and edit table layouts
Work with ACL field definitions and data types
Combine multiple tables
Detect data corruption and invalid dates
Generate control totals
Detect blanks in key fields
Test bounds of data in numeric and date fields
Test numbered transactions such as (pay checks) for completeness
Test records for uniqueness
Test field relationships (e.g. is the date of birth of an employee always earlier than the employee’s hire date?)
Test reliability of a data field calculated from values in two other fields (e.g. Does“ Net Pay” always equal “Gross Pay” less ”Total Deductions” ?)
Use the following commands: Verify, Count, Total, Statistics, Sequence, Gaps, Duplicates, Stratify, Classify, Age, Summarize, Cross-Tabulate, Extract, Export, Join and Relations
Create computed fields, conditional and unconditional
Use global filters and command filters

建議考試閱讀參考資料

使用者手冊(User documentation)可以從ACL Support Center網站上下載：
- Getting Started Guide
- Data Access Guide
- ACL in Practice Tutorial
ACL線上支援：Online Help (F1 in ACL)
ACL網站的 Support Center
- Knowledge Base Search
- QuickSteps/Results
- Online Learning
上課講義(ACL 100 及 ACL 200 level courses) (只有參加認證課程才提供)

<上一頁>　4/4