Proudly serving the D.C. metro
area for over 25 years.


Softek Services, Inc.
1156 15th Street, NW, Suite 100
Washington, DC 20005
(202) 747-5000

Computer Training Software Consulting Database Programming

Get tips on our Facebook Find us on Google+ Tweet Us Read Reviews on Yelp Softek on Linkedin

  • Instructor-led Training Instructor-led Training
  • Join a Public Class Join a Public Class
  • Private Group Classes Private Group Classes
  • Transition Classes Transition Classes
  • Virtual Training Virtual Training
  • Customization & Documentation Customization & Documentation
  • Web and Database Development Web and Database Development
  • We Have Classrooms We Have Classrooms
     

Introduction to Relational Database Design
Using Microsoft Access

1 Day, 9:00-4:00, 6 Hours

This thought-provoking course will explain important database terms and concepts that everyone should know in order to properly design a relational database.  The emphasis of this course is 1) building the tables, 2) establishing the relationships between the tables and 3) understanding the various considerations when building a relational database.  Microsoft Access is the software used for the examples throughout this course; however, the concepts learned can be applied to any relational database application.

This course is designed for students that need to create their own relational database or that are on a team and need to give feedback regarding the design of the database.  Students should have a basic understanding of Microsoft Access or another relational database application.

What is a Relational Database?

Steps for Designing a Relational Database

  • Step 1: Determining General Requirements
  • Worksheet 1: Determine General Requirements
  • Step 2: Generating a List of Fields
  • Splitting Information into Multiple Fields
  • Handling Calculated or Derived Fields
  • Worksheet 2: Generate a List of Fields
  • Step 3: Determining the Data Type for Each Field
  • Data Validation Rules
  • Step 4: Organizing the Fields into Appropriate Tables
  • How Many Tables Should I Create?
  • Dealing with Privileged Information
  • Worksheet 3-4: Determine the Data Types and Organize the Fields
  • Step 5: Relating Multiple Tables
  • Understanding Key Fields
  • Types of Relationships
  • Step 6: Setting Referential Integrity
  • Worksheet 5-6: Relate Multiple Tables and Set Referential Integrity
  • Step 7: Testing the Structure

 

 

On Your Own

Sample Worksheets

  • Worksheet 1: Determine General Requirements
  • Worksheet 2: Generate a List of Fields
  • Worksheet 3-4: Determine the Data Types and Organize the Fields
  • Worksheet 5-6: Relate Multiple Tables and Set Referential Integrity

View Upcoming Schedule or Register for a Class

Is this the right course for you? Please contact our office at (202) 747-5000 if you have any questions.

Back to Agenda

 

Investment

Public Class

$350 per student

View Schedule or Register

Private Group Classes

Conducted at Your Office

$1400 flat fee for up to 8 students
$1600 flat fee for up to 12 students
$100 per additional student

Conducted at Softek’s Facility

$1550 flat fee for up to 8 students
$1750 flat fee for up to 12 students
$100 per additional student

Have more or fewer students? Or, need to schedule more than one training day? Fill out our quote request form for a price quote based on your training needs. 

Why choose Softek?

  • Live, in-person training
  • Instructors with 10+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee