June 2011
Beginner
552 pages
14h 54m
English
Content preview from Microsoft® Access® 2010 24-Hour TrainerBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
16
Creating Table Relationships
Access 2010 is a Relational Database Management System (RDMS), as are all previous versions of Access. The heart of RDMS is the ability to eliminate or limit the need to store redundant data. The method used to eliminate duplicated data requires conforming to the rules of normalization, rules that were originally defined by Edgar F. Codd in 1971. Normalization works because data in one table is related to data in one or more other tables. The relationships can be implicitly created in a SQL statement, or explicitly created and enforced by the RDMS.
Relationships between tables in an Access database can be explicitly created in the Relationship Tools designer on the Database Tools Ribbon. Access relationships can be defined to require referential integrity. Referential integrity is the primary way to require that a parent record exists for each child record and to prevent the deletion of parent records when related child records exist. Deleting the parent record and leaving the related child records results in what are called orphan records, which cause reporting anomalies because the information is not intact. Referential integrity is used to help prevent orphan records within a database system.
LESSON SETUP
In this lesson you learn about the different types of relationships and how to create them in Access 2010. You learn how to use the Access 2010 Relationship Tool to create and modify relationships between tables in an Access database.
RELATIONAL ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.