I performed a systems analysis that identified the business needs for this project, designed the relational database in Microsoft Access and set up the table tracking system. I also designed the “look and feel” of the standardized Excel table structures used to report statistical results and managed the editing and production of the final compendium document which accompanied the interim repots sent for U.S. congressional review.
The relational database was constructed using Microsoft Access running on a Novel network It was used to manage the coordination and linkage between several review cycles and the final production of the tables in a WordPerfect document. The table tracking software managed documentation regarding reviewers’ comments, table creation and revision and the location and storage of the software programs that selected, merged and compiled the data for a given table or set of tables.