IT question

Associate Level Material

Appendix A

Final Project Overview and Timeline

Final Project Overview

Throughout this course, you develop a database application using Microsoft® Access®. The database application you build is based on a scenario involving a fictitious company called Riordan Manufacturing, Inc.

Riordan Manufacturing, Inc. is an industry leader in the field of plastic injection molding. With state of the art design capabilities, Riordan Manufacturing creates innovative plastic designs that have earned international acclaim. Attention to detail, extreme precision, and enthusiastic quality control are the hallmarks of Riordan Manufacturing. With facilities in San Jose, California; Albany, Georgia; Pontiac, Michigan; and Hangzhou, China, Riordan Manufacturing has the capacity to fulfill unique client needs. Riordan Manufacturing is wholly owned by Riordan Industries, a Fortune 1000 enterprise. Riordan Manufacturing’s Planning and Development department has been tracking sales and inventory numbers using a set of spreadsheets that are passed between the people in their department using e-mail. While this solution worked when the company was smaller, the company’s recent expansion into a global marketplace necessitates a more robust method of managing department data.

In the final week, you develop a proposal to convert the database application into a business intelligence system.

Final Project Timeline

Budget your time wisely and work on your project throughout the course. As outlined below, some assignments in the course are designed to assist you in creating your final project. If you complete your course activities and use the feedback provided by the instructor, you will be on the right track to successfully complete your project.

· Due in Week One: Assignment: Create Access® 2007 Database for Final Project

· Due in Week Four: Assignment: Create Queries in Access Database Final Project

· Due in Week Five: Assignment: Create SQL Statements in Access Database Final Project

· Suggested in Week Six: Begin the Final Project: Business Intelligence System Proposal (due in Week 9)

· Due in Week Seven: Assignment: Create Reports in Access Database Final Project

· Due in Week Eight: Assignment: Create Advanced Reports in Access Database Final Project

· Due in Week Nine: Final Project: Database Application and Business Intelligence System Proposal

Final Project Requirements

50 pts	Final Database Application implemented using a Microsoft® Access® Database
70 pts	Business Intelligence System Proposal Microsoft® PowerPoint® Presentation
40 pts	Business Intelligence System Proposal Executive Summary
Total Points: 160