Working with IBR in Microsoft Access

Incident-based reporting systems such as NIBRS represent a rich source of data for analysts, but they can be complicated to work with. Rather than using specialized statistical packages, you may find that a familiar desktop program such as Microsoft ACCESS fills your needs.

Reading NIBRS Data into ACCESS
This section walks users through the process of reading NIBRS ASCII data into ACCESS. An executable program is available for downloading. ACCESS 97 and ACCESS 2000 versions are available.

Reading State-Level IBR Data into ACCESS
Now you can read state-level data formatted for the FBI into ACCESS. A description of the process is available, as well as an executable program available for downloading. ACCESS 97 and ACCESS 2000 versions are available.

How to Edit Reading State-Level IBR Data into ACCESS
Since state formats may differ from the format required by the FBI, documentation is provided to allow users to make modifications to the program that reads state-level IBR data into ACCESS. ACCESS 97 and 2000 versions are available.