Chat with us, powered by LiveChat
  • 646-205-3261
  • Mon - Fri | 9:00AM - 6:00PM
  • 646-205-3261
Engagement Example
Access Database Project:

I.  Overview

  • Client designs and manufactures bicycle components.
  • Production integrity control system to track and report production areas
  • Development Inspection
  • Quality Requirements
  • Control Requirements

II. Problems & Opportunities

  • Multiple manufacturing facilities need to access and maintain documents
  • Multiple existing stand-alone Excel workbooks
  • Tracking multiple workbooks
  • Lack of data consolidation
  • Multiple users

III. Objectives

  • Create a Microsoft Access database to consolidate information input and production monitoring
  • Create a single point of data collection and reporting for all users

IV. Proposed Strategy

Phase I – Create an Access database with Tables, Queries, Reports and Navigation/User Forms

  • Data Tables
  • Type Tables
  • User Forms

Phase II – Split database into Front and Back Ends

  • Work with IT for best location for Front & Back-End deployment
  • End-User Training
  • Populate Database
  • Set up Excel Dashboard reporting to pull data from Access database

Phase III – Additional support as required