Generating Reports on Database Information. Database software report generating features provide you with printed reports, on-screen reports, or reports saved to disk of your information for review and analysis. Database software should give you the capability to generate numerous reports in a variety of report formats. The reports that you generate will generally be based upon records you have searched and retrieved using the search commands previously discussed in "Searching and Retrieving Records for Editing and Reports." Again, it is important that you become familiar with the search commands, so you can retrieve the records that meet your report needs. After you have retrieved specific database records, you can generate reports in a variety of formats based on those records.Four sample reports that you could generate are listed below: 1. Document Number Report - Includes information about the document number, date of the document, type of document, and summary of the document. 2. Chronological Document Report - Includes information about the document date, document number, summary of the document, and the names of the persons and their connection to the document. 3. Persons Connected with Document Report - Includes information on the document number, persons connected to the document, document type, and document summary. 4. Legal Issues Document Report - Includes information on the legal issues, document date, and a summary of the document.
This is an example of a database and reports created using Microsoft Access. These are a few of the reports that will be generated automatically by double clicking on the report name. The reports are all based on the design of your database and the data that is entered.
For example, the following trial exhibit report can be generated on-screen or printed in a few seconds, since the underlying data was previously captured in the document data fields and the report was set up for automatic printing.
Another report that can be easily generated is a chronological report. Once you enter the dates of documents in the document date field, you can then retrieve all documents connected to a specific date or prepare a chronological date report of all the documents in the database. This information is extremely important in order for you to "analyze" the significant facts relevant to a case.
Integrating Images with Your Database. One of the early and major considerations is to determine whether you should scan your documents so that you can electronically retrieve them later as "document images." An image is simply a photographic reproduction of a document stored on a CD-ROM or hard disk available for instant retrieval for viewing on a monitor. A single CD-ROM can hold up to 15,000 document pages, depending upon the resolution or dpi at which it is scanned. The image picture contains words, but you cannot search the individual words on the image. For this reason, to locate an image you must index and link the document to a document index or database. The database can then be searched and the image retrieved, since it is linked to a database record. However, if you use OCR software and convert the image to machine-readable text, then the individual words can be searched. There are two choices when faced with the task of managing documents. You can manually handle, organize, and retrieve the paper. Paper has to be copied, documents have to pulled off shelves or out of boxes, files are misplaced or lost, storage is inconvenient and banker boxes are not easy to take on the road. The other choice is to scan the documents as images or as machine-readable text using OCR software and control your information digitally. There are several benefits for scanning your documents in order to digitally control the documents and other information in your cases:
The decision to image your documents should be made at the outset to ensure that a proper link is set up between your database and imaging software program. Depending upon the imaging program, images can be linked to any DOS or WINDOWS-based program. For example, if you are using Microsoft Access, the image can be linked to a particular database record. Then, when you search for and view the abstract of a record, the image can be viewed at the same time. Also, from this image, you could obtain information to put into your database record or block text, use OCR to convert it to machine-readable text, and transfer it into your database record. |