Tracking Application for Library Digitization Project

Client: Internal
Platform: MS Access
Delivery Date: Ongoing
Project Description: This project involves the scanning of over 15,000 library volumes. The majority of the work is done by student employees. This application streamlines data entry in multiple ways; provides lookups to help the students identify and decipher features of the volumes; and ultimately helps them identify the correct location for each volume in the institution’s digital repository.
Features: Students first search a combobox displaying a list of volumes already scanned, to help prevent duplicate entries. The “Add New” feature searches* a list of all volumes obtained from the library catalog and passes the values for call number, title, and author name into the form, automating some data entry and minimizing errors. Additional lookups on the main data entry form include a dropdown list for degree; selecting an item from the list automatically populates the “Department” field, as the degree-department relationship is not always apparent to the students. Two options exist for identifying faculty names from frequently illegible signatures: a set of comboboxes on the bottom of the ETD Register form (not shown), and a separate split form accessed by the “Show Faculty List” button, which allows the entries to be sorted by first or last name, or department. Students can also view a list of books with no scan date, and books whose “Uploaded?” value is FALSE, to help identify volumes that may need attention.
Users: 4

Main data entry form (click to enlarge):

“Add New” interface:

Split form for identifying faculty names:

*Hearty thanks to Open Gate Software for their search-as-you-type demo database.

Tracking patient referrals

Client: New Patient Scheduling
Platform: MS Access (split accdb)
Delivery Date: April 2014
Project Description: Manager wants to track and time process of scheduling new patients.
Features: Users can enter information about a new referral, and complete the referral when the appointment is scheduled. Managers can edit lookup table, view statistics and access reports on number of referrals scheduled, time to complete, and referring institutions.
Users: 6

User Interface Screenshots:

PR Navigation

PR New Referral

PR Complete Referral

PR Mgr Nav

Sample Manager Report:

PR Report Sample

Example code: Edit Referral (manager only)

PR Mgr Edit Code

A simple task tracking application

Client: Facilities Management
Platform: MS Access (split accdb)
Delivery Date: November 2013
Project Description: Manager desires user-friendly app to allow patient assistants to quickly record tasks as they go through their day.
Features: For untimed tasks, the application records name of task and date/time completed. For timed tasks, application records start time, awaits finish time, prompts for user initials, records time spent on task. Manager can run report of tasks completed by date, and track which users are completing timed tasks.
Users: 5

Main user interface:
GSA click form

Open-Close task dialog:
GSA open-close dialog

Example code: Open-Close
GSA open-close code
GSA open-close code2

Contact me if you’d like a copy of this database (cleaned) or for a quote for a custom application like this.