Crime Analysis in the Information Age

Using MS Office, Access and Excel for Law Enforcement

- in Tulsa, Oklahoma, USA

Tulsa Police Dept. Training Academy
Computer Lab
6066 E. 66th St. N
Tulsa, OK 74117

Past Event

Credits:14 Hours TCLEOSE Credit


Using Microsoft Office as a tool, this program will demonstrate the benefits of technology in crime analysis, investigations and community policing. Classroom work will utilize selected handouts from the book “Better Policing with Microsoft Office 2007,” co-authored by the course instructor. Utilizing exercises similar to projects faced by crime analysts, participants will use Microsoft Access and Microsoft Excel in concert to analyze crime patterns, trends and problems.

In order to receive the most benefit from this learning experience, please bring a laptop loaded with either Microsoft Office Professional 2000, 2002, 2003 or 2007 which includes Access and Excel. If a laptop is not available, the student may share with another student or simply observe the techniques being used in class. The entire class will be interactive and will be based on the book, Better Policing with Microsoft Office 2007 by Christopher W. Bruce and Mark A. Stallo, Ph.D.   

Download the Brochure (pdf)

For more details, download the online brochure.


  • $350 ILEA Member
  • $400 Non-member

*This includes all instruction, textbook and handouts. Lodging and meals excluded.


  • Creating Tables
  • Importing Data
  • Identifying a Crime Series by Using Queries
  • Creating Reports in Access
  • Formatting, Charting and Formulas in Excel
  • Predicting Future Offenses by Date and Time
  • Cleaning Data
  • Data Analysis in Excel
  • Automating Reports Through Linking and Macros

Who Should Attend?

  • Police executives and managers
  • Crime Analysts
  • Investigators
  • Community Policing personnel
  • Deployment personnel
  • Budget and Finance personnel


  • Lieutenant Mark Stallo, Ph.D.
    Dallas Police Department, TX

Mark Stallo was hired by the Dallas Police Department in October 1979. Mark was promoted to Sergeant in August 1985 and Lieutenant in September 2010. He is assigned to the Planning and Accreditation Unit. Mark has written or co-written articles and books in the area of crime analysis. He holds a B.S. in Criminal Justice from the University of Cincinnati, and a M.S. in Management and Administrative Science; a Master of Public Affairs and a Ph.D. in Public Affairs from The University of Texas at Dallas.


Law enforcement personnel attending this course are eligible for 14 hours of Texas Commission on Law Enforcement Officer Standards and Education (TCLEOSE) credit.


Monday through Tuesday 8:30 am - 4:30 pm

Overnight Accommodations

Course Cancellation Policy

Occasionally, the Institute for Law Enforcement Administration (ILEA) may be forced to cancel a scheduled program. Whenever possible, the decision to cancel is made at least fourteen days prior to the start of the program, and registered participants are notified once that decision has been made. If the distance to the training site requires that you make airline and/or hotel reservations, please contact ILEA (+1.972.244.3430) to inquire about the status of any program before making travel arrangements. While paid registrations in cancelled courses will be refunded in full, ILEA will not be responsible for monetary loss due to cancellations or changes in airline or hotel reservations.

Privacy Policy

We do not sell or rent information to any outside parties. By providing your information, you will receive postal and electronic communications from the Institute for Law Enforcement Administration (ILEA) of The Center for American and International Law (CAIL) in accordance with CAIL's Privacy Policy. If we co-sponsor a program with another organization, information may be shared between the parties. All such co-sponsors will be identified on the event details and registration page. At any point, you can opt-out or unsubscribe by selecting either link at the bottom of each email or call us at 972.244.3400.

Registrar: +1.972.244.3405
ILEA: +1.972.244.3430 
Fax: +1.972.244.3431