- Discuss database principles
- Differentiate between a flat file and a normalized data
- Understand table relationships
To understand table relationships it is important to have an understanding of some basic database principles. We will explore the underlying properties of relational databases, how they are organized, and how they add value to commercial enterprises. Then we will discuss the important concept of normalized data versus flat file data organization, which is crucial to understand what makes a relational database work. Finally we will learn about the three types of relationships between tables in relational databases like Access.
Flat File vs. Normalized
You can view the transcript for “Access 2019 & 365 Tutorial The Flat File Method of Data Storage Microsoft Training” here (opens in new window).
Different Data Relationships
You can view the transcript for “Microsoft Access Relationships Explained” here (opens in new window).