Database Project (MIS 2000)

Create a database to support the information management needs of an organization.
Proposal Specifications:
1. Your project topic must be career-related (related to your academic field, job, or a
business opportunity). The best project topics are those based on actual organization’s
issue. (You can do Google Search online to get more ideas.)
2. Provide the following information in your proposal:
A. State the problem or opportunity.
B. Explain its importance.
C. Explain why a database is a good tool to solve it. Describe what database features
will be used and why.
D. Provide background on the calculations, formulas, and data sources that you need.
NOTE: Please, do not include private or sensitive information in your project!
Implementation:
 Create a MS Access Database with appropriate objects that you will use to form your
project solution.
o Create/use at least 4 tables with appropriate relationships enforced. At least 2
one-to-many relationships will need to be resolved.
o Create/use queries to join your tables, create summary views, show calculated
fields, and return results based on a user-specific criteria.
o Create/use forms for entering data into your tables. At least 1 form per tables is
required.
o Create/use reports to display the results of your queries. At least 2 reports are
required.
o Embed photos, artwork, sound, and/or video files into your database.
o Create a ‘menu’ (formerly known as ‘switchboard’ in older MS Access versions)
that allows the user(s) to display the forms and reports in your database.
o Create a user-friendly interface for the database.
Deliverables:
You need to submit 3 files:
 Proposal File (PDF or MS Word file types are accepted.)
 Database File (MS Access 2013 file type is required.)
 Presentation File (MS PowerPoint or any other web-based presentation tool is accepted)
o The presentation file should only contain slides that highlight specific features
that you had learned in this class that were used in this project, such as
relationship(s), query criteria, table customizations, etc.
 Submit both files into our Blackboard LMS (MIS 2000) course environment under the
final week’s folder.
Please, let me know if you have any additional questions about this very important final project
via our “Course Mail” in Blackboard. Thank you! I am here to help.
Aloha from Instructor Eddie Merc
MIS 2000 Class