Data analysis with SQL: a government audit team unlocks the key to efficiency by employing high-powered query tools. (Computers & Auditing).(standard query language)

From: Internal Auditor | Date: August 1, 2002| Author: McCollum, Tim | Copyright information

TATE LEGISLATIVE AUDITORS in Minnesota are old pros at using audit software, but in recent years they have broken out the power tools to get at the vast amounts of data that state agencies have stored in data warehouses and relational databases.

Recently, auditors from the Minnesota Office of the Legislative Auditor (OLA) began a review of the Metropolitan Airports Commission in Minneapolis. The agency stored several gigabytes of data in a relational database management ...

Read all of this article with a FREE trial to HighBeam Research

Related newspaper, magazine, and journal articles from HighBeam Research

Automated audits
CA Magazine ; The latest microcomputer-based audit software can lead to greater productivity - and boost staff morale too IF YOU'VE BEEN DISILLUSIONED WITH AUDIT software in the past, either because data transfer was too difficult or your staff spent hours wrestling with the program, it's time to reconsider.
Controls testing. (use of audit software in internal auditing)(Computers & Auditing)
Internal Auditor ; Audit software, traditionally used to perform routine calculating tasks, can be successfully adapted to far more complex audit tasks. including controls testing. For example, today's software can facilitate audits of large data populations. Auditors can adapt this data analysis capability to
Designing and implementing a computerized audit
The Secured Lender ; With the availability of low-cost Windows-based, multidimensional spreadsheet applications there is no longer a reason for an auditor to perform a manual field examination. Windows-based spreadsheets have become so easy to use, and can produce such a high quality of output, that no field auditor
Computer-assisted techniques for fraud detection
The CPA Journal ; Computer technology gives auditors a new set of techniques for examining the automated business environment. In fact, the detection of fraud is a perfect application for computer-assisted audit tools and techniques (CAATTs). As early as 1982 CAATTs was a powerful audit tool for detecting financial
Tools of the trade--Part III
CA Magazine ; Sophisticated software has enabled auditors to convert isolated breakthroughs in audit performance into everyday events For the past two issues, Michel Vezina has used this space to document auditors' increasing use of information technology. But despite instances such as the payroll system audit
Choosing the right tools: today's auditors face a dizzying array of software choices. advice from the experts, along with the results of Internal Auditory ninth annual software survey may help narrow the field and facilitate decision-making.(Cover Story)
Internal Auditor ; CORPORATE GOVERNANCE AND REGULATORY concerns are among a number of forces putting pressure on organizations to establish stronger internal controls over financial records and systems. Consequent y, internal audit departments are turning to audit software tools to help them meet the tighter
Integrated audit teamware.
Internal Auditor ; Customized audit software provides a paradigm for how internal auditors can operate in a technological work environment. In the 1980s, Deloitte & Touche set out to design a software system that would free auditors from mundane mechanical tasks and allow them to spend more time on tasks that require
E-audit: tools evolving to help you find your way along the paperless audit trail.
California CPA ; ... the tools needed to perform an audit in a highly integrated manner. The good news is that today's tools are beginning to offer higher levels of integration. The bad news is that it takes a lot of knowledge to use all the tools involved in the audit ...
Audit software.(Product Review)
Food Manufacturing ; [ILLUSTRATION OMITTED] Company's browser-based PocketdynaQ audit software is designed to be more robust, easier to use, and compatible with the latest Windows-based PDAs. Users can control content, manage assessments, monitor follow up actions, analyze data, and run reports. This next generation of
Testing application controls. (use of computer-assisted auditing tools and techniques in reviewing application controls)(Computers & Auditing)
Internal Auditor ; It's almost criminal to use audit software only to produce standard reports. In the hands of experienced, creative auditors, there is no limit to the use of computer-assisted auditing tools and techniques (CAATTs). Reviews of application controls, for example, can definitely be enhanced by CAATTs.