Armory Database for Microsoft Access
The typical military armory (or police kit room) is paper-based. Filling out paperwork is time consuming, does not trap potential errors (as does a computer), the pre-printed forms are expensive, and filled-out forms may be lost or rendered unreadable.
Proposal: Automate the assignment, tracking and inventory management of your armory with a database system that eliminates all paper based processing and makes all inventory data available in real time.
-
- Check In/Out
-
- Inventory Management
-
- Personnel Management
-
- Physical Inventory
- Expedite the check-in, check-out and physical inventory processes using barcode technology (and possibly other technologies).
- Items which cannot be bar-coded can be quickly entered through the computer keyboard.
- Reduce printing and paperwork costs by maintaining all required data in the computer.
- Automatically generate important functions and reports, such as a “Missing Equipment Report”, which will identify any equipment checked-out at the beginning of a shift but not returned at the end of the shift (or other time period).
NOTE: This system was developed in conjunction with the Harbor Division of the Los Angeles Police Department. Due to a reorganization of the department towards the end of this project, this system has never been implemented and fully tested. In-field testing of this system (and possibly some debugging) has yet to be done.
Check In and Check Out Screen: The identity of individuals who check equipment in or out of the system is first verified via fingerprint, or through a variety of other ways. Equipment can then be easily assigned to the users via an automated bar code based inventory management system.
The Inventory Management Screen is used to enter new equipment, remove old equipment, and to enter the status of all existing equipment (i.e. out for repair, available for use, etc.)
The process of performing a physical inventory is barcode automated. It is impossible to apply a barcode label directly to some types of equipment, and there are other means for addressing this issue, such as affixing the barcode to the shelf where that particular piece of equipment is stored.
Personnel Management: This screen lists all personnel known to the system and their associated information. Any/all personnel can be selected for a printed summary report. This screen is also used to add/change/delete personnel records.
Please call or email for sample reports. All reports are can be custom designed to match your existing paperwork.
('
’)
