From the course: Learning Relational Databases

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Write queries in Access

Write queries in Access

From the course: Learning Relational Databases

Start my 1-month free trial

Write queries in Access

“

- [Narrator] I've gone ahead and fill in some data into the table that we've created in the last movie and I want to now show you how the database uses what it knows about our tables and their relationships to give us some useful information. Let's first take a look at the line items table and all the data that I've added. Here, we have a column for the invoice ID. This is a numeric value that links back to the invoice. We can see that we have two invoices, invoice one and invoice two. On those invoices we have a number of line items. On invoice number one we have two lines, one and two, and on invoice number two we have three lines, one, two and three. We also have a reference to the product ID. This is a numerical reference to the product ID that we can find in the products table, as well as the quantity of the product that was ordered. Now we have all of this data, but it doesn't really convey any true information to me. For instance I really want to know who placed the order. And…

Contents