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 explaining 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 calculated 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 calculated 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.