Agee Software, Inc.

Police Department Workload Database

Click Setup on the Main menu to open the Setup form. Enter your Department info. The ImportFolder is the path to XLS files to be imported into the database.

Click TblDoc to create an HTML data dictionary. It describes each field in the database. To see the contents (read-only) of any table in the system, select it in the Table combo and click View.

Click Export to export the data viewed to Excel XLS, dBase/Clipper DBF, TXT, Excel CSV, Word/WordPad RTF or Access MDB. If you click Edit for a table, the form used to edit it will open.

Click Link to specify where the shared data tables are located. Backup lets you easily save the data tables database to a location you specify. By default, it names the file with today's date.

Click Quit to force users out of the database for maintenance.

Compact rebuilds indexes in tables and completely deletes records marked for deletion. If you make a lot of changes to the database, it is a good practice to Compact monthly. All users must be out of the database to Compact it. You can use the Quit feature to ensure this occurs.

The Combo form lets you edit simple tables that only have a couple fields and are commonly used in combo boxes. Hr is used in the lower left of the Shift form. CT is used in the lower right of the Shift form. Law Enforcement Officer (BadgeNo), Location and Evt (Event) are used on the Shift form. Gender, Race and Charge are used on the Arrest form. If a label is blue, when you click on the label, the Combo form opens to the record in the combo box so you can edit it or add a new value. The Sort field lets you control the order of values in the Combo. You can set Sort to a value like 1.75 to insert a record between sort value 1 and 2.

Some combos show a link at the bottom of the form that lets you edit the records that contain that value.

The Data Integrity form is a framework for simple queries that lets you see records that may have incorrect data. There are lines that show what the query shows and how to fix the problems.

Calc counts the number of records returned by each query. It can take several minutes, so Calc1 returns the count of records for the current query.

Sel selects the records and opens the appropriate form so you can edit each record.

Export lets you export the records similar to the Table Export feature. .

View shows the records found by a query in read-only format.

Some queries have a Fix button that lets you automatically fix problems. It is generally a good idea to back up the database and View the records before using this feature.

SQL shows the raw SQL statement in a query so you can understand specifically what the query returns.

These queries allow users to enter data quickly without stopping to confirm information. They are easy to add, so encourage your users to identify areas where they have data entry problems and we can add a DI query to help them.

Click User on the Setup form to open the User form. You must be a super user to add or delete users or change info about other users.

More info on setting up users