Lesson 1: Introduction to Relational
Databases
- The Basics of Relational Databases
- Planning the Database
Lesson 2: Designing Tables
- Deciding on Tables and Fields
- Selecting Primary Key Fields
- Identifying Table Relationships
- More on Keys and Relationships
Lesson 3: Data Normalization
- Solving Data Problems
- Higher Normal Forms
Lesson 4: Data Integrity
- Referential Integrity
- Field-level Integrity
- Table-level Integrity
- Reviewing and Finalizing the Database
Design
Lesson 5: Query Basics
- Performing Queries
- Multiple Table Queries
Lesson 6: More on Queries
- Other Types of Queries
- SQL
- Optimizing Query Performance
Appendix: Additional resources
The conceptual content of this course in not
specific to any software application. Microsoft Access 97 or
Access 2000 is needed to perform the tasks in the lessons
pertaining to queries.