SYNOPSIS

Law enforcement agencies are increasingly working with data sets. Generated from cell phones investigations and other computer-based sources, these data sets are typically stored as evidence but only rarely “mined” for their full potential. Most analysts are familiar with the features of Excel to manage data, but when the sets are large enough, and the questions big enough, a more robust program is required. Utilizing Microsoft Access to analyzing these data sets and helping them “make sense” to others is the purpose of this course.

OBJECTIVE

The course builds a foundation in Access around several basic building blocks: Introduction to the Access, its comparison to Microsoft Excel, Data Basics, connecting to Data sets, ODBC (Open Database Connectivity), Tables and Queries, SQL and RDBMS (relational database management systems), Reporting, and the Effective Presentation of Findings. By the end of the course, students will be confident in their ability to access, manage and query data sets for the purposes of criminal investigations and overall agency benefits.

COURSE FLYER

INSTRUCTOR

Jason Druckenmiller is a police officer for a mid-size agency in Northwest Ohio.

REGISTRATION

The course is limited to 30 students.  Registration for this course is Free. Registration instructions can be found on the course flyer.