Professional Training Series Course Descriptions

The classes below are currently offerered by the IACA:

MS Access for Crime Analysis


LAW ENFORCEMENT AGENCY USES ANALYSIS TO DRIVE EFFICIENT AND EFFECTIVE DEPLOYMENT STRATEGIES….sounds logical and proactive…BUT, how do you ACCESS and USE all that data!?! Are you struggling with how to pull your data easily from your records’ management system? Do you have your data but have no idea how to ask the right questions of it or create reports for presentation?

Through this training, you will be able to employ more directed policing efforts based on the strategies that are measurable!

BENEFITS – After taking this workshop, you will have:
• The ability to easily and consistently extract accurate information - no more pulling reports and getting different data.
• The ability to understand what information you pull.
• The ability to dig deep into your information for long-term or short-term projects. For example, say you have a rash of vehicles parked in driveways, unlocked, that are targeted during the late shift. Access allows you to just pull those reports (in a second!) and identify hotspots, times, etc. to best deploy officers.
• The analytical capacity is endless! You will have data at your fingertips. You can run reports on officer time spent at calls, days of week that have the most calls (your specifications) by a time block period, comparisons of previous years (year to date), have information on demand, and so much more!
• Automated bulletins to save time and supply timely data.

We will explore the basic and intermediate database objects of Microsoft Access, and how to utilize each one with a connection from your records management system. Instruction will specifically include activities on law enforcement-related making and appending tables, developing quality queries, displaying easily readable reports, and employing macros that automate these processes.

**Optional: Please set up remote access to your agency’s data for personalized instruction. Please work with IT staff to set up DDF files for ODBC access.

Certification Skills:

View All Classes

About the Professional Training Series

Each class offered by the IACA is designed to provide a solid foundation in key skills needed to be a successful analyst.