Introduction to Relational
Database Design
Using Microsoft Access
1 Day
Course Description
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.
Prerequisites
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
Is this the right course for you? Please contact our office at 202.682.4500 if you have any questions.
Other Helpful Links
©2008 Softek Services, Inc. All Rights Reserved.