Reference no: EM131929

Requirements

Create a database from scratch that contains, at a minimum, the elements listed below. The type of database you create is up to you. However, I highly encourage you to build a "real-world" application where you create a database for work, school, or your own use using real data. For example, you might use sales, wage, inventory, or other data from work, incorporate a project from another class, or build an application to use for school.

A brief paragraph or two describing the purpose of your database an its functionality, plus a detailed E-R diagram.

It should include, at a minimum,

Tables

• At least three related tables
• Use correct relationships
• Enforce referential integrity
• Make all foreign keys look-up fields
• Use cascade update

Queries (these queries can be linked to forms and/or reports)

• Multiple table and parameter
• Create calculated field
• Crosstabs, find duplicates, find unmatched, and find top value queries (choose two)
• Append, delete, make-table, and update queries (choose two)

Forms

• Main and subform
• Hyperlink
• Data entry controls; textboxes, list boxes, combo boxes, option groups, check boxes, toggle buttons, and command buttons (choose four)
• Format forms attractively using color, shading, lines, and fonts

Reports

• Export reports to Word or Excel
• Apply sorting and grouping options
• Create a summary calculated field
• Apply conditional formatting
• Create a custom format and use for all reports
• Format forms attractively using color, shading, lines, and fonts 

Macros

• Create and run a macro
• Create and use a switchboard

Customization

• Create a custom menu, toolbar, or short-cut menu and attach it to the switchboard.
• Set start-up options

Grades will be determined by the completed objectives listed below.