Past Projects: MS Access

Motley Motley, Inc

Timecards Database with MS Access Training

This project had a two-fold purpose. The main goal was to create a timecard application so they can review how money is being spent on different construction projects. This project was also used as a training tutorial for one of their employees who now does simple maintenance and updates for the application.

Washington State University

Laboratory Administration Database

Developed database-driven application to manage administrative needs for self-sustaining unit which provides paid services. The application manages workflow, produces financial reports, and aids technicians in completing their tasks. Spreadsheets and Word documents were converted to a database application in which redundant data only needs to be entered once. The application was originally created using SQL Server connected to a MS Access front-end. The front-end was later moved to a web-based system. The work capacity for the group increased 5-fold after implementing this application.

Washington State University

Bacterial Culture Log

Over a decade of research data from several researchers was compiled into a single large spreadsheet, and this information was inserted into a database. The application is used to log specimen test results as well as where the specimens are stored.

Veterans of Modern Warfare

Online Store

This online store was placed inside the existing website for VMW. PayPal is used to manage payments. Emails are sent to bookkeepers and suppliers so that payments and orders are handled in a timely manner.

Washington State University

Financial Tracking and Budgeting System

SumTech upgraded legacy MS Access financial tracking software to a more intuitive user design. We moved the database from MS Access to SQL Server and redesigned the user interface from scratch. We created several financial reports for finance personnel and high level reports for deans. We also worked with importing Excel tables of data into the database.

Veterans of Modern Warfare

Membership Form, Database and Administration Application

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.

Andy Sewell with Picture

Customers, Sales, and Marketing Program

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.

Woodland Heights

Income and Expenses Program

This bookkeeping application tracks rental unit income and expenses. Information about tenants is also stored.

Pullman Christian School

Progress Report and Report Card Program

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.

Washington State University

Department Administrative Database

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.