Drive your public
safety career forward

Searching the Marketplace

Courses in the FirstForward Marketplace may be found by entering simple keywords. These search terms are used to match against course titles, course descriptions, topic areas, class locations, and the name of the vendor providing the training.

You may further refine the keyword search by including special commands:

  • To match the beginning and end of a word, include * in the middle of a keyword as wildcard (e.g., crim*s)
  • To match a specific phrase, add double quotes (e.g., "in the field")
  • To require words, add + before the word or phrase (e.g., +enforcement)
  • To exclude words, add - before the word or phrase (e.g., -structure)

Except when an exact match is required, the Marketplace search will attempt to match similar words, including partial matches and some misspellings.

Tools for:
Featured Training
Using MS Office, Access and Excel for Law Enforcement
Loading Nationally Certified

Using MS Office, Access and Excel for Law Enforcement

Institute for Law Enforcement Administration

Classroom Training
$399.00

Course Information

Using Microsoft Office as a tool, this two-day program will demonstrate the benefits of technology in crime analysis, investigations and community policing. 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.
Note: In order to receive the most benefit from this learning experience, please bring a laptop loaded with MS Office Professional* (version 2007 or later) with both Microsoft Access and Excel. MS Office 2016 (365) would be preferred). If a laptop is not available, the student may share with another student or simply observe the techniques being used in class.
Topics include:
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 Macro

*$50 ILEA member discount*
14 hours
20 to 35 students with 1 instructors
Law Enforcement
Crime Analysis, Data Analysis
Any member may attend this course.

Course Content

See specific classes for location and instructor information.

Warning

This course is restricted

The training provider published this course with a restriction that requires students to have the following credentials on FirstForward:

With your current credentials, you may not purchase this training.

Assignment Restrictions

We just wanted to make sure you noticed the restrictions. While you can purchase the course it can only be assigned to employees with the required badge(s) shown below:

What would you like to do?

Course License Options

The FirstForward Marketplace offers two licensing options available to course vendors. Each course may be offered for purchase under one or both of these license options:

A course purchased with a single-view license will be accessible only once. A member may restart or resume the course while in progress, but will no longer be able to view course material once the course is completed.

A course purchased with a one-year subscription license will be accessible for 365 days. A member may restart, resume or retake the course until one year after the purchase date.

Upcoming classes

More Information

Warning

This course is restricted

The training provider published this course with a restriction that requires students to have the following credentials on FirstForward:

With your current credentials, you may not purchase this training.

FirstForward Policies

Updated: 06/29/2018 8:45 AM Eastern Standard Time