From the course: Access Basics for Excel Users
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Create relationships - Microsoft Access Tutorial
From the course: Access Basics for Excel Users
Create relationships
- [Instructor] Creating relationships between common fields in separate tables is the first step in maximizing the use of Access' powerful features. A relationship basically allows us to bring different datasets together in one table without having to manually add or copy data. And to do this, all we need is a field that's common to both tables. Make sure you have 02_03_Relationships open to follow along with me, on the left-hand side, under the All Access Objects window, where you'll notice the two tables that have already been imported into our database. Now let's go to Database Tools and select Relationships. When the Show Table dialog box appears, simply select both tables and then click on Add and then Close. Now to make this next step a little bit easier, let's go ahead and drag the Category table a little bit lower down. What you'll notice is the Area Name is a common field that exists in both of our tables.…
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.