Download
accessing an odbc database n.
Skip this Video
Loading SlideShow in 5 Seconds..
Accessing an ODBC Database PowerPoint Presentation
Download Presentation
Accessing an ODBC Database

Accessing an ODBC Database

230 Vues Download Presentation
Télécharger la présentation

Accessing an ODBC Database

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Accessing an ODBC Database

  2. External Data ODBC Command From ACL Project Screen use External Data ODBC Command

  3. Select Server The ODBC interface lists the databases available to this project.

  4. Clear Security The files are password protected. The Internal Audit ID only has write access so we cannot accidentally screw up a file.

  5. Select Table or View We will use a view developed by Information Systems for Internal Audit. ACL could connect multiple files and Internal Audit could achieve the same result with more independence but more cost.

  6. Select Check File Fields The ACL ODBC interface automatically identifies and formats the fields. If a large file is involved fields can be excluded.

  7. Save File

  8. File Layout

  9. Summarize by Day Check Register produce totals by daily check run and by payment method. The check file is sorted and footed accordingly.

  10. Select or Filter Manageable Data The datafiles can be very large so we normally use a filter to obtain an efficient files size.

  11. Place Results in File

  12. Command Execution

  13. Final ACL Control Totals Totals by day agreed to check register. Example is 11/30/07.

  14. Check Register Bank Account Number Amounts and Record Counts Agreed to ACL Report for Day in Question