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.

Area	Skill	Points (0-5)
Tables	At least three related tables
Relationships	Correct and appropriate relationships
	All foreign keys look-up fields
Queries	Multiple table and parameter
	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
	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, add hyperlink
Reports	Export reports to Word or Excel
	Calculated summary fields
	Apply sorting and grouping options
	Format forms attractively using color, shading, lines, and fonts
	Create a custom format and use for all reports
Macros or Modules	Create and use switchboards
	Use VBA to customize a database by creating functions, event procedures, etc.
Usability	Is the application intuitive and easy to use?  Are objects well placed?
Functionality	Does the application do what it is supposed to do?  Does it function correctly and efficiently?
Aesthetics	Does the application look inviting?  Are things spelled correctly?
Total