2012 Information Systems Section Midyear Meeting and AIS New Scholar Consortium
JANUARY 5–7, 2012  •  SCOTTSDALE, ARIZONA

Workshop Information

Workshop:	Fraud Examination Using Data Analysis and Querying Techniques in Microsoft Access
Presenters:	A. Faye Borthick, Georgia State University Uday Murthy, University of South Florida
Date:	Thursday, January 5, 2012
Time:	1:00 p.m. – 5:00 p.m.
Field of Study:	Auditing (Substantive Audit Procedures)
Program Level:	Intermediate
Method of Delivery:	Group – Live
Credit Hours:	4.0 CH

Requirement:

• Participants should bring a laptop with Microsoft Access installed

Intended Audience:

• Academics who teach accounting information systems, information systems auditing, internal auditing or forensic auditing courses.

Learning Objectives:
Attendees will be able to:

• Develop an audit plan
• Import data from text or Excel files into Microsoft Access
• Structure the data to facilitate subsequent querying
• Develop queries to identify results that may be indicative of fraudulent activity
• Use functions in Access to identify suspect transactions
• Distinguish between normal and abnormal data outliers

Prerequisites:

• Basic understanding of relational databases and beginning level experience with Microsoft Access

Advanced Preparation Required:

• Load sample data onto their laptops (to be sent to pre-registrants 12/20/11)

Back to the Information Systems Section Home Page
Back to AAA Home Page