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-course 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.
Error

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?

None

What is external training?

Most vendors publish their online and classroom courses in a way that allows FirstForward to process enrollments. This includes purchase of online courses that can be assigned and completed on this website and student registrations that reserve seats in a particular class.

Some approved vendors are granted permission to also publish courses as external training. Such courses can be discovered on the FirstForward Marketplace, but all purchase, enrollment and tracking of course completion is managed on the vendor's remote website. External training will appear in the Marketplace like other training, but will link to the website where the purchase takes place.

Because course completion is tracked elsewhere, FirstForward will not be able to automatically include external training on your professional credentials. The student or the vendor providing the course will need to enter that completion manually.

Course License Options

The FirstForward Marketplace offers different licensing options available to course vendors. Each course may be offered for purchase under one or more 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.

Access to multiple courses can be purchased at once by subscribing to a course bundle offered by a vendor. All courses included in the bundle are available to take on demand for one year, allowing you the freedom to choose which topics are most important and relevant to your profession. Your subscription will allow you access to new courses as they are published and added to the course bundle.

Upcoming classes

More Information

Error

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: 05/12/2021 2:57 AM Eastern Standard Time

Updated: 05/12/2021 2:57 AM Eastern Standard Time