Abstract
The purpose of this instructional resource is to explain how Structured Query Language (SQL) queries can help auditors to independently retrieve properly formatted data as audit evidence or for further analyses. It demonstrates data extraction using Microsoft (MS) Access, one of the simplest SQL-compliant database software applications. We use a dataset fragment that is extracted from the publicly available enterprise datasets provided by Walton College (University of Arkansas) to run SQL queries as a part of audit investigations. Data extraction is the first step of Extract, Transform, and Load (ETL) and may be time-consuming. We demonstrate how SQL queries can assist with this task, thereby allowing the auditor to begin analysis sooner. This instructional resource can be used to prepare future auditors for the emerging data-rich and technology-driven business environment.
| Original language | American English |
|---|---|
| Pages (from-to) | 237-265 |
| Number of pages | 29 |
| Journal | Journal of Emerging Technologies in Accounting |
| Volume | 19 |
| Issue number | 1 |
| DOIs | |
| State | Published - Mar 1 2022 |
ASJC Scopus subject areas
- Accounting
- Computer Science Applications
Keywords
- Data Query Language
- Structured Query Language (SQL)
- audit data retrieval
- audit procedures
- data extraction