Senior Design III Final Presentation By Hugh Beardsworth

Senior Design III Final Presentation By Hugh Beardsworth Advisor Professor Schlemmer Project Management Database for Control Works Inc.

Overview ØIntroduction to Control Works ØDesign Protocols ØBudget ØConclusion

Control Works Introduction ØCustom control panel manufacturer ØPrimary business pumping industry ØEach control panel custom designed for a specific application ØCustom design process extremely time consuming with many repetitive calculations

Design Protocols Ø Project consists of database and programming Ø Focus on Microsoft Access database Ø Visual Basic used to create application pages that communicate with database Ø Database connected with ADO Ø Project uses SQL select statements

Budget Ø Total for fiscal year 2002: – – Microsoft Office XP Visual Basic 6. 0 Enterprise Windows NT 4. 0 server Dell Power Edge 4400 $430 660. 1, 457 2, 400 Total $4, 947

Deliverables ØSystem lets users search for projects like ones they are quoting or designing ØApplication pages written in Visual Basic 6. 0 and SQL select statements ØPages check application for proper components ØDatabase uses Microsoft Jet connection ØUsers have logons with different levels of access authenticated by database

Deliverables ØUser tasks: ØOperator interface for easy navigation ØEnter or update customer information, supplier information or parts information ØSearch using point and click operation ØSearch existing projects for components like those in new project

Proof of Design

Questions?