Basics of SQL for Audit Data Retrieval and Analysis

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...