Requirements:

Make a database from scratch which contains, at a minimum, the elements listed below. The kind of database you make is up to you. Though, it is highly encourage you to build a "real-world" application where you make a database for work, school, or your own use using real data. For illustration, 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 describeing the aim of your database and its functionality, plus a detailed E-R diagram.

It must include, at a minimum,

Tables:

• At least three related tables.
• Use accurate 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.
• Make find outd field.
• Crosstabs, find duplicates, find unmatched, and find top value queries (select two).
• Append, delete, make-table, and update queries (select two).

Forms:

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

Reports:

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

Macros:

• Make and run a macro.
• Make and use a switchboard.

Customization:

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