Client: Medical Coding
Platform: MS Access (split accdb)
Delivery Date: February 2015
Project Description: Manager would like to track and record number of reports and time spent per coder, and generate productivity and management reports.
Features: When users open the DB, what they nicknamed “the widget” appears — designed to be small, unobtrusive, and take up minimal screen real estate. Dropdowns make data entry faster and ensure uniform entries. Clicking “Start” records start time and opens a form where they can select a comment about the report if desired. Clicking “Note Completed” enters productivity info into table. Users can easily view the detail or summary of their work completed for the day. Managers can access various reports on employee productivity and workload for various types of inputs, and edit dropdown selections.