Access Database Consultant Developer Programmer

Law Enforcement

Microsoft Access Database for Law Enforcement

Police Officers


Here are some clients we have helped in the Law Enforcement industry:

Client

Location

Project Description

Bear Technologies

Klamath Falls, OR

Partner to fix Access database for their Police Client: Tulelake Police Department, OR. We provided them with this quote:

1. Asp.net application that can be run from any computer using a web browser. this will be used on any and all PCs used by the department

2. 3 tables plus asp.net log in tables a. Crime Report (currently 130 +/- fields) b. Officers (currently 9 fields); add user name field from asp.net for correlation c. State Abbreviations (currently 1 field)

3. Forms for data input a. Log in to asp.net app b. New user to asp.net app c. Edit/Add officer to SQL database (there will be an association of New user to asp.net using user name from asp.net) d. Edit/Add State Abbreviations to SQL database e. Edit/Add Crime Report to SQL database

4. Reports a. Crime Report

5. Search feature on Crime Report form

6. Record navigation feature on Crime Report

7. Print Button on Crime Report

8. Sync Button on log in to asp.net for - requires password

9. Sync new records to SQL Server Express

10. Update modified records to SQL Server Express

11. At present a sync from SQL Server Express to the asp.net application is not included

12. At present migrating old data from MS Access to SQL Server Express is not included

Our Clients Include:

  • The Army, Defense Supply Center, Chesterfield (Richmond) Virginia - Warehouse Inventory Application subcontracted through Goodwill Industries as a prime vendor
    The Army, Defense Supply Center, Chesterfield (Richmond) Virginia - Warehouse Inventory Application subcontracted through Goodwill Industries as a prime vendor
  • The Navy, Naval Research Laboratory in Waldorf, Maryland - Inventory, Purchase Orders, Service Life Tracking Microsoft Access database subcontracted through ACSG as the prime vendor
    The Navy, Naval Research Laboratory in Waldorf, Maryland - Inventory, Purchase Orders, Service Life Tracking Microsoft Access database subcontracted through ACSG as the prime vendor
  • Pepsi Bottling Group in Somers (New York) New York - Overall Equipment Effectiveness Microsoft Access database that tracks SKU production and downtime categories to improve LEAN efficiency
    Pepsi Bottling Group in Somers (New York) New York - Overall Equipment Effectiveness Microsoft Access database that tracks SKU production and downtime categories to improve LEAN efficiency
  • Virginia Commonwealth University, Medical College of Virginia, Richmond Virginia - Mortality Statistic tracking for the hospital using an Access database
    Virginia Commonwealth University, Medical College of Virginia, Richmond Virginia - Mortality Statistic tracking for the hospital using an Access database