Dean H. Stanton · Selected Work

Multi-Store Inventory Management System

A production Microsoft Access inventory-management system designed, programmed, installed, and supported by Dean for a paying multi-store nonprofit client.

Results

Results and contributions.

01Production inventory systemDesigned, programmed, installed, and supported a Microsoft Access inventory system for a multi-store nonprofit client, including user training and ongoing maintenance.
01
Situation

Operating context

A multi-store nonprofit retail operation needed a production inventory system that could support real operating use across locations instead of disconnected manual or local records.

02
Challenge

What made the work difficult

The application had to translate inventory requirements into a workable multi-store database, then move beyond development into installation, user training, and ongoing support.

03
Dean's role

Responsibility and authority

Dean defined the requirements with the client, designed and programmed the application, led installation and training, and provided ongoing production support.

04
Actions

How the work moved forward

  1. Defined inventory and multi-store operating requirements with the client.
  2. Designed and programmed the Microsoft Access relational database application.
  3. Implemented inventory workflows for production use across multiple locations.
  4. Installed the application and trained client users.
  5. Provided ongoing production support and maintenance.