IACA Microsoft Access Training

04/03/2025 2:06 PM | Anonymous member

Hello, 

Our Department is looking to host a IACA Microsoft Access for Crime Analysis in-person training. The course minimum is 10 people. We just wanted to see if anyone would be interested in taking the course. Description and link below. 

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 data…data-driven 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.

https://www.iaca.net/in-person-classes


Thank you, and feel free to email me dcasey@lynnpolice.org 


Massachusetts Association of Crime Analysts (MACA)


P.O. Box 6123

Chelsea, MA 02150


Powered by Wild Apricot Membership Software