Projects

Dana Bell

Membership Database, Organizational Membership and Financial Database.: This membership database for a local non-profit organization combines membership records with financial records. Tracks fund-raising projects and maintains records of donations. In addition to tracking paid memberships, the database also keeps records of membership activities and interests. Numerous reports are built into the database for monthly and annual reporting purposes, with revenue and expenses categorized at multiple levels. (2011)
Travel Expense Records, Travel Expense Recording and Reporting Database.: This project was done as part of the requirement for the Computer Information Systems capstone class. The project uses a networked Microsoft Access database to track travel expenses of employees at the Columbia Scientific Balloon Facility of NASA, working on projects around the world. Some considerations in the project were the incorporation of variable per diem costs based on location and dates on site, the treatment of partial days, and a alternate navigation system similar to existing software. (2010)
Web Projects, Web Pages and Applications.: I initially developed the Home on the Web personal web site in 1995. It received a few recognitions and in February 1996, it was selected as the first winner in Gower.Net's web page contest. Since then, I've developed and maintained several static as well as database driven websites, including the site assets such as photos, images, forms and PDF documents. The most recent project also involved creating a mobile friendly version of the site. Click a site in the list to the left to visit, or hover for a preview.

Some past web related HTML projects include the development of a program to convert Morning Star magazine files to HTML format. Since then Morning Star has ceased publication. Current versions of Echobase software can also create HTML files as a command-line option. Using basic HTML technology, I have also developed numerous compiled HTML Help files, such as the help file for Inventory Manager. {1994 - 2012}
RxPads, Security Enhancements: Early in 2008, all Medicare Rx must have security features to prevent forgery. I devised a system including the use of security inks (erasable), and a designed a void pantograph to reveal alterations and attempts to copy prescriptions. The process not only met the partial requirements for Spring 2008, but also satisfied the full requirements to go into effect in October of 2008. The in-house process saved over 50% off the cost of using specialty papers that only provided a single secure feature.
Inventory Manager, Supply and Capital Inventory database.: Inventory Manager is a Microsoft Access database designed for Inventory Control, Physical Inventory and Chemical Inventory. Inventory Manager was developed initially to assist the departments for which we do printing, to better track their printing inventory. At the end of the year, however, it may be most valuable for doing your physical inventory. By preparing the database with items and pricing, when it's time for inventory, you can then print count sheets that have all items listed.
Inventory Manager also simplifies the annual inventory process by using your inventory records from previous years, and allowing you to just update the counts each year. Inventory Manager can also be used for inventory control, where you can print inventory checklists for ordering, as well as for chemical inventory records. Inventory Manager is an extraction of features built into Pressroom Manager and later Copy Center Manager. {2007 - 2008} (download)
Copy Center Manager, Copy Center and Campus Copier database.: A compiled database from a collection of databases developed over 5 years for the Copy Center department at UTHSCT. Starting with an Inventory recording and ordering database, and expanded to provide a comprehensive database of copy center tools. Functions were integrated to include lease information, monitor copier technician and service calls, take meter readings, calculate copy charges and produce departmental billing, maintain copier codes, and monitor copier supplies. Also used for improved physical inventory procedures. {2004 - 2008}
Pressroom Manager, Printer's Scheduling and Inventory Control database.: Pressroom Manager was developed to maintain records of paper inventory on a perpetual basis. It was expanded to include job scheduling for the print shop as well as maintain a Hazardous Chemical List, equipment inventory and maintenance records, physical inventory and extension, management of standing purchase orders and reports to create the departmental and employee UTHCT phone directory.
Pressroom Manager includes multiple relationships, tables, queries, forms, reports and macros. Other reports generated on request. A subset of the database was also created for the UTHCT/UTT Copy Center.{2002 - 2008}
Expenditure Authorization, Purchase Authorization Database: Developed a database to monitor expenditure authorizations for UTHSCT purchasing department. List all accounts, owners, administrators and other individuals authorized to sign for purchases. Database also contains digital images of all signatures for visual comparison by Purchasing, and links to authorizing documents. Also used to prepare various reports. Access front and back end. A SQL Server version was prepared initially but not used due to SQL Server security limitations.{2007 - 2008}
SwiftBBS, Computer Based Messaging and Communication Software.: Communication software package designed to be compatible with similar programs. Supports FidoNet technical specifications for echomail processing and file formats. Includes BBS program with internal menus, optional customizable menus with about 100 selectable functions and options, an internal text editor or optional external editor, imbedded meta codes for database displays, and custom interpretive language. The package or available utilities also include configuration program, menu editor, user editor, network mail processing software, messagebase maintenance software, and diagnostic utilities. Also, incorporates write-in-place compression. {1989 - 1996} (download)
Echobase, Electronic Message Conference Database and Query Software.: Initially developed to meet a specific need within FamilyNet International, Echobase system software has now been distributed within other networks. Echobase maintains a database of message conference listings that can be updated and queried remotely via netmail. Echobase also publishes lists of echoes periodically, monitors database and sends aging warnings and dated deletions. Other programs in the family simplify conference moderator updates to the database, allow users to browse a database in read-only mode. Replies and reports can be generated in user specified formats, and entries can be imported/exported from/to other databases. {1994 - 2004} (download Echobase or Echomod )