Requirementscreate a database from scratch that contains at

Assignment Help Database Management System

Reference no: EM13347996

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*

Reference no: EM13347996

Questions Cloud

Prepare a pipe network system that transfers water from the : prepare a pipe network system that transfers water from the upper pipe to the lower pipe. note that figure is a plan

Communicationa significant distinction between online and : communicationa significant distinction between online and face-to-face classes lies in the area of

A pressurized water tank is used as a source of water for a : a pressurized water tank is used as a source of water for a fire hose. the pressure of the air in the top of the tank

Question 1 explain whether the following transactions are : question 1 explain whether the following transactions are counted in the gdp. if so denote whether the expenditure

Requirementscreate a database from scratch that contains at : requirementscreate a database from scratch that contains at a minimum the elements listed below. the type of database

This assessment task needs that groups examine two firms : this assessment task needs that groups examine two firms from the one industry that display contrasting e.g.

Section 1a dihybrid cross of two plants is done and the : section 1a dihybrid cross of two plants is done and the seed pod shape is examined. the seed stock was pure one

Your company is an australian company looking to expand its : your company is an australian company looking to expand its market by introducing a new product. as the part of the

1 you have to design a wireframe prototype to meet the : 1. you have to design a wireframe prototype to meet the needs of the personas and requirements.mainly preparing the

User Account

All Pages