Database Projects

This section is under construction. I am at the very beginning of a rewrite of my resume/CV, the first in about 15 years (or 50 Internet years).

Meanwhile... 

Please see the original resume or read my blog for more information about me and my endeavors.

 

Following are a few of the database projects I have worked on during my work or educational career, or in my personal time. Most are Microsoft Access projects, although a few have also been adapted for MySQL or MSSQL. You will notice that the projects involve more than just building the database, but can include things such as system analysis and documentation, as well as database migration. Some databases can be found on my downloads page.

Undergraduate Advising Database

Records of student advising, visits, and application for graduation

This simple project was completed while working in the College of Business and Technology advising office. This is an upgrade from an existing Access database that contained a single table, forms, queries and reports. The database was normalized and forms were added to allow navigation of student records, additional information from other sources, and user maintenance of underlying data. This tracks the progress of students toward their degree requirements and their visits to the advising office. It also keeps track of graduate advisors and levels their workload. Several reports are available. A second limited, read-only interface was designed for network users within the department, but outside of the advising office. (2011) (download documentation)

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}

Forms Manager

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)

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} (download)

Compet...

Disc Golf Handicap System

 

Dynamic Web Sites

Please see my Web Projects for descriptions of Tyler Web Sites and Patriot Talon, two of the database driven websites I've developed.

See Also

Membership Database

Travel Information System

Mandatory University Reporting System