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

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

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

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.




City and State


Number of students:
(at least 10 for consideration)

When do you want to hold the

How long would you like for the

Additional comments to trainer:

We value your privacy!