## Access database that will collect user input to record preventive maintenance activities for multiple sites. The data will then be synchronized to a central database via web services for client reporting. The scope of this project includes developing the user input side of the process including calling web services to synchronize the data.
The new system will be developed from the ground up using Microsoft Access:
Synchronization capability, Unique database IDs/Tracking, Multiple-level hierarchy for PM readings, Database security
Items to be inventoried and tracked includes such things as inventory information (manufacturer, model, serial number, etc.). In addition to inventory, the system must also accommodate readings. For instance, a site might have 2 HVAC units, and we need to track whether or not belts have the proper tension.
Each system may (or may not) have sub systems, and those sub systems will have their own readings. For example, an electrical panel may have several sub panels, and those panels may have sub panels. We need to be able to inventory and track each panel, sub panel, and reading within its hierarchy.
The system will need to allow field technicians to easily maneuver and enter data in a logical progression with minimal technical expertise and as few clicks and keystrokes as possible. All data will be saved to the local database to be synchronized later via web services.
Application will include security to the Access database to prevent technicians from viewing or updating the underlying database objects or from seeing another customer's information.