Create a database to support the information management needs of an organization.

Proposal Specifications:

ï‚· 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.)
ï‚· Provide the following information in your proposal:

o State the problem or opportunity.
o Explain its importance.
o Explain why a database is a good tool to solve it. Describe what database features will

be used and why.
o 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.
ï‚· Create/use at least 4 tables with appropriate relationships enforced. At least 2 one-to-many relationships will need to be resolved.
ï‚· Create/use queries to join your tables, create summary views, show calculated fields, and return results based on a user-specific criteria.
ï‚· Create/use forms for entering data into your tables. At least 1 form per tables is required.
ï‚· Create/use reports to display the results of your queries. At least 2 reports are required.
ï‚· Embed photos, artwork, sound, and/or video files into your database.
ï‚· 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.
ï‚· Create a user-friendly interface for the database.
Deliverables:

ï‚· You need to submit 2 files:
o Proposal File (PowerPoint (PPT/PPTX), PDF or MS Word file types are accepted.)

o Database File (MS Access 2013 file type is required.)