New Horizons Lexington KY Computer Training
New Horizons Computer Learning Center presents
 

Relational Database Design: A Practical Approach On-Site Training

This on-site training class is also available as Public Schedule Seminar.

In this course, students will design and create a relational database.

Course Description/Agenda


Duration
Classroom Learning - 1 Day(s)
Online LIVE - 1 Sessions

Overview
In this course, students will design and create a relational database.

Who Should Attend
Individuals who are able to write simple queries or run queries that someone else has designed.

Prerequisite(s) or equivalent knowledge
Access 2007 - Level 1

Outline
Lesson 1: Analyzing Client Requirements
Analyze Current Data Storage Systems
Identify New Client Requirements
Determine the Required Data Fields
Group Fields into Tables
Identify Key Fields
Lesson 2: Creating a Preliminary Design
Create a Preliminary Entity Relationship Diagram
Apply the First Normal Form
Apply the Second Normal Form
Apply the Third Normal Form
Apply the Higher Normal Forms
Denormalize Tables
Incorporate Client Feedback
Lesson 3: Implementing the Database Design
Translate Business Rules into Constraints
Create Tables
Create Indexes
Lesson 4: Generating Reports
Manipulate Data
Generate Reports Using Conditions
Generate Reports from Multiple Tables
Generate Summary Reports
Create Views
Lesson 5: Customizing a Database
Modify Constraints
Modify Fields
Modify Tables

 

More Seminar Information

New Horizons Computer Learning Center
New Horizons Lexington KY Computer Training

Delivery Method

 On-Site Training On-Site Training

Also Available As

 Seminar Seminar

  		Add to favorites Add to favorites
Email Email this page
 

On-Site Training
Information Request Form

Please complete the form for more information and/or a quote for this on-site class.

Name:

Email

Phone:

City and State

Company:

Number of students:
(at least 10 for consideration)

When do you want to hold the
seminar?

How long would you like for the
seminar?

Additional comments to trainer:

We value your privacy!