| Core Services |
| Course Agendas |
| Register/Schedule |
| Cancel/Reschedule |
| Quote Request |
| Assessments |
| Student Resources |
| Classroom Rentals |
| Software Tips |
| Directions |
| Feedback Form |
| Contact Us |
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) 747-5000 if you have any questions.
Other Helpful Links
Are you interested in a class for one or a few students? Consider taking a public class. View our public training schedule for dates.
Or, are you interested in scheduling a private group class at your office or at Softek? Learn more about our private group training.
©2008 Softek Services, Inc. All Rights Reserved. - 1156 15th Street, NW Suite 100, Washington, DC 20005 - (202) 747-5000