Worked closely with client to determine the data flow and reports needed. Analyzed and determined the relational table structure. Using SQL queries to bring the relational data together for the reports and forms. Ported Lotus 123 flat files into relational tables linking Access with USDA's dBase database. Used SQL statements to react with the forms.
Remote machines synchronize data by e-mail .
Seven day Diet Analysis. Embedded MSWord into the Access database under program control to permit documents to be tracked with the project. For National Intercollegiate Rodeo Association - Walla Walla Analyzed and designed the relational tables and relationships. Developed SQL query statements to be used in the forms and reports. Keeps track of both the contestants score and the animals score.