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