Transcript Presentation - Center for Adaptive Optics

Inventory Management
Database Development
Conrad Corpuz
Mentor: Alisa Manangan
Advisor: Errol Gorospe
Maui Community College
1
Akimeka
Values
•
•
•
•
•
Ohana(family)
Laulima(cooperation)
Ho’okipa(generosity)
Koa(courage of leadership)
Lokahi(harmony)
2
Akimeka
•
•
Vaughn Vasconcellos
IM/IT services and solutions provider
3
Customers
Hamakua Health Center
4
Spreadsheet
• Simple to use
• Easy data
duplication
• Cell formulas &
Calculations
5
Database
• Multi-user sharing
• User level Security
• Data validation &
checking
• Search and retrieval
• Eliminate repeated data
• Data entry available
• Simple debugging
• No upper row limit
• Different display formats
6
Project
• Database
– Forms
– Queries
– Reports
7
Steps
•
•
•
•
•
•
•
Analysis Interview
Design Database
Presented Design
Develop Database
Test Database
Presented Database
Train Inventory Managers
8
Analysis Interview
• Interviewed corporate
and project Inventory
Managers
• Discussed
–
–
–
–
Requirements
Functionality
Unique Data Fields
Data Collection Method
9
Steps
Analysis Interview
• Design Database
• Presented Design
• Develop Database
• Test Database
• Presented Database
• Train Inventory Managers
10
Design Database
• Analyzed all data
from each project
• Started design with
common fields
• Drew up data tables
• Designed in
Microsoft Visio 2003
11
Steps
Analysis Interview
Design Database
• Presented Design
• Develop Database
• Test Database
• Presented Database
• Train Inventory Managers
12
Present Design
• Presented database
design
• Discussed changes
to improve database
performance
• Incorporated
changes
13
Steps
Analysis Interview
Design Database
Presented Design
• Develop Database
• Test Database
• Presented Database
• Train Inventory Managers
14
Develop Database
• Modified with
company logo
• Started design
with common
fields
• Implemented
exclusive tools
15
Steps
Analysis Interview
Design Database
Presented Design
Develop Database
• Test Database
• Presented Database
• Train Inventory Managers
16
Test Database
• Ran
queries/reports
• Tested search
function
• Used different
resources to
ensure database
is user-friendly
17
Steps
Analysis Interview
Design Database
Present to Inventory Managers
Develop Database
Test Database
• Presented Database
• Train Inventory Managers
18
Presented Database
• Presented database in its current
development stage
• Walked through the dashboard
• Got feedback
• Incorporated changes
19
Steps
Analysis Interview
Design Database
Presented Design
Develop Database
Test Database
Presented Database
• Train Inventory Managers
20
Training
• Presented
database to
Inventory
Managers
• Conducted tutorial
on how to use
• Provided user
guide
21
Conclusion
• Database has been established
• Inventory Managers are more
productive
• Accessible to all Inventory Managers
22
References
•
•
•
•
http://home.twcny.rr.com/accesssig/
http://www.akimeka.com/
http://www.synergysoft.ca/images/
Access 2003 Bible
23
Acknowledgements
•
Center for Adaptive Optics
– Lisa Hunter
– Scott Seagrove
– Hilary O’Bryan
•
Akimeka
–
–
–
–
•
Alisa Manangan
Errol Gorospe
Deanna Moon
Scott Oshita
Maui Economic Development Board
– Isla Yap
– Leslie Wilkins
•
Maui Community College
– Mark Hoffman
– Wallette Pellegrino
•
•
Institute for Astronomy
Funding provided through the Center for Adaptive Optics, a National
Science Foundation Science and Technology Center(STC), AST-987683
24