Step 1: Create and Run the Access Query

This tutorial assumes you are familiar with Microsoft Access and know how to open the program and locate the data table containing the client data you want to use to create a geocoded map of the clients' locations.

This tutorial is not intended as an endorsement or recommendation of any particular case management system. The examples in the tutorial rely on a legal services client database originally created in Access 97, using the Clients 98 program. (The data table is called CLIENTSW.) The screen shots will be familiar to legal services programs using that particular case management system. But the basic process of running an Access query to extract specific client data would apply to other case management configurations also using the Access database platform.

Introduction ::: Next Step: Convert Query Results to Excel .xls Format