Requirements
Create a database from scratch which contains, at a minimum, the elements listed below. The type of database you create is up to you. Though, you should to build a "real-world" application where you create a database for work, school, or your own use using real data. Like, you may use sales, wage, inventory, or other data from work, or build an application to use for school.
A short 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 right 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