From the course: Access: Building a Sales Database
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Products by vendor - Microsoft Access Tutorial
From the course: Access: Building a Sales Database
Products by vendor
- [Instructor] So, you wanna place an order for products. To beef up your inventory or to fulfill a specific order. Which company sells those red widgets you need? Where did I get those blue whatsits for that really good price? A query showing the vendors and what they sell will give you just what you need. So, we're gonna design a query, now. It's gonna be a product based query, however. Despite the fact that the vendor is the key piece of information. But we're gonna be using the products and vendors table, and that's gonna rely on the relationships that exist between those two tables. So, we're going to go to the create tab. And to query design. And then in the show table dialogue box, we want products and then vendors. And then close the box. And we can see by the line connecting the two that their relationship is based on the vendor ID. So, we have products and the vendor that sells them. That's a value within each product record and then that's related to the vendors table so…
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.