Software Development

Management Tools: Making good management decisions requires accurate and meaningful data. We have built several financial applications that allow reconciling, budgeting, and reporting of key financial information. Other types of data that may need to be managed include customer relations, product inventories, or time cards.

Workflow Management: When businesses work with projects or inventories, tasks are staged through a process. A project may be proposed, then assigned, then progressed, then completed, then delivered. Or a product may be ordered, then received by the warehouse, then purchased, then delivered to the client. These processes need to be tracked and managed. When stored in a relational database, progress can be easily managed with a management portal, automated alerts, and customer reports.

In research, there may be significant amounts of data collected in flat files, excel spreadsheets, and word documents. In business, there may be other unique aspects ot the business that are tracked in a similar manner with a need to condense the data into summaries and reports that are meaningful. SumTech can use programming to manage this data, often with the use of databases as well, to simplify the data, merge several files together, and report meaningful information back to the user. We also offer design consultation to help determine an appropriate way to gather important data.

Transitioning to Database: Organizations often using Microsoft Word and Excel to manage information such as employee directories, client lists, project details, inventories, and other accounts of information. When changes need to be made, several files may need to be updated, and there are often inconsistencies and errors in these documents. Relational databases help remove the inconsistencies so that updates only need to be made in one place, and all reports are automatically updated as well. History of changes can be tracked as well.

Past Projects
Veterans of Modern Warfare

Membership Form, Database and Administration Application

Veterans of Modern Warfare

As a growing national organization, VMW needs an efficient way of tracking membership, chapters, dues, etc. SumTech created an online membership application that submits information to a database for storage. Several validations are used to test that valid information is being entered. Administrators can review, update, add, and delete membership information through an MS Access program. Also, the users can use the power of MS Access queries to find useful statistics about their organization.
Later, the MS Access front-end was converted to a web application.



2/2009

Andy Sewell with Picture

Customers, Sales, and Marketing Program

Andy Sewell Water Colors

In sales, knowing your customers is vital. SumTech developed a MS Access database to manage information about customers, sales, paintings, and art shows. This information can then be used to send mailings to specific regions before future art shows, find customers who are interested in certain types of paintings, and track how well sales were at different art shows. Also, custom forms were created to allow quick entry of receipt information to the database.



1/2009

InPrayer.US

In Prayer for Washington State Website and eNewsletter

In Prayer for Washington State

People wanting to know how to specifically pray for Washington State have a place to go. This site is designed to be updated weekly and have newsletters e-mailed to members with the site’s new information. Persons may subscribe and unsubscribe to the newsletter on a weekly basis. The facilitators of In Prayer send a MS Word document to SumTech, who then converts the information to published on the web. Each newsletter is stored in a database for archiving so members may review past newsletters.



10/2008

Pullman Christian School

Progress Report and Report Card Program

Pullman Christian School

SumTech converted a system of Word documents and Excel spreadsheets to an Access database used for tracking students, courses, and grades, as well as printing report cards.
Later, they moved toward using an online subscription service. We helped determine whether the new service would meet their needs, and we aided in the transfer of data from our software to the new system.



9/2008

Washington State University

Department Administrative Database

WSU - Psychology Department

Use of Word documents, Excel files, and paper trails can be time consuming to manage. For this department, we created an administrative database to maintain confidential information about people, courses, keys, committees, rooms, money, and research projects. This process involved combining a collection of spreadsheets and documents into one robust database to accomplish several necessary tasks done by staff. Now their workload is stream-lined and more effective for accomplishing their goals.



5/2008

Washington State University

Media Library Tracking System

WSU - Biomedical Communications Unit

Instead of tracking their media library resources with tiny slips of paper, SumTech converted their process to an electronic management system. A simple user interface was created to allow users to track when media resources were checked in and out, allow administrators to edit and correct data, and allow infrequent users to intuitively understand how to work with the software.



4/2008

WSU FDIU

Investigations Documentation Program

WSU - Field Disease Investigative Unit

SumTech developed a MS Access database to log and search critical field investigation data as well as generate reports. The program code was documented to show how different sections of code work so future additions to the database could be easily made by other persons.



2/2008

Living Faith Fellowship

Worship List Documentation Program

Living Faith Fellowship

LFF keeps commonly sung hymns and songs stored in a box for the worship team to reuse each week they are needed. SumTech created a database list of all the songs available in the box, their various keys, and their composers. Now reports of what songs are available can be printed sorted by their first line, title, or key of composition. Volunteers can update the database when new songs are added to or removed from the box.



1/2007