Chat with us, powered by LiveChat
  • info@getexcelhelp.com
  • 646-205-3261
  • Mon - Fri | 9:00AM - 6:00PM
  • info@getmicrosofthelp.com
  • 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

300-101   400-101   300-320   300-070   300-206   200-310   300-135   300-208   810-403   400-050   640-916   642-997   300-209   400-201   200-355   352-001   642-999   350-080   MB2-712   400-051   C2150-606   1Z0-434   1Z0-146   C2090-919   C9560-655   642-64   100-101   CQE   CSSLP   200-125   210-060   210-065   210-260   220-801   220-802   220-901   220-902   2V0-620   2V0-621   2V0-621D   300-075   300-115   AWS-SYSOPS   640-692   640-911   1Z0-144   1z0-434   1Z0-803   1Z0-804   000-089   000-105   70-246   70-270   70-346   70-347   70-410