From the course: Access 2019: Building Dashboards for Excel
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Identify keys
From the course: Access 2019: Building Dashboards for Excel
Identify keys
- [Instructor] As you grow more and more knowledge about the backend of your database, there are benefits to understanding and identifying the keys. Let's take a look. Looking at our Relationships window we can easily see the primary key fields for these tables. For example, dbo_Users, the UserID is the primary key. Now a primary key is a unique identifier of that record. That way we don't enter the same record multiple times as a way to help us, but from a reporting perspective, that primary key, well, we use it to join data. Look at the dbo_VideoSessions. You see how VideoSessionID is the unique identifier for that session. That means each session gets its own unique record, but then you notice the UserID. The UserID is actually a foreign key because it's already primary in dbo_Users. If I relate UserID to the foreign key UserID in VideoSessions, it allows me to pull data of users and the sessions. Understanding…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.