 So this week what we're doing is we're working with an access database and In particular, we're using something known as the Chinook database, which allows us to sort of kind of use a more modern Twist to the entire database concept. What we're actually looking at is say someone's iTunes Kind of folder if I say for example click on track All of a sudden I'm looking at all of the information about every track every composer all this information About everything going on with these people. Which is pretty nice as we can clearly see So one of the things we want to do know one of the things we want to do is we want to go ahead and start Designing out what we call as queries a query is basically I want to take this information I have over here, and I want to ask it a question to do that I come over to my create section And I generally speaking don't like to do query wizard. It's gonna lead you down a dark path That's not too terribly helpful in my opinion. I actually prefer the query design Now what this allows us to do all of a sudden this allows me to have Access to every single one of the tables in my database that I might want to look at Let's say for example. I want to look at just my artist Well, I happen to have an artist table and I can click on add It's going to appear kind of in that that background Section now if I close out a show table all of a sudden I have access to this I can move it around I can do anything to it But one of the things I want to do is I want to ask it a question in this case I want to bring something down here now the quick and easy way to do this is I simply double-click As you can see what happens is name appears down here and the table also kind of specifies that But what this allows me to do all of a sudden is if I want to run this Well, that's what we have a run button that we can click on and So all of a sudden I can see every single one of my Artists every artist that was ever mentioned in any track on any album whatsoever is now Available at my disposal if I want to go back for example, I can switch back and let's say for example. I want to see The track to the artist. Well, if I click on show table again, I See all my tables. I see track now track has a link to artist How do I know this? Well, if I hit add I don't but you know this album Album Makes that connection happen. Now. This is where that re kind of moving these things around can start to come into play So what I'm doing all of a sudden is I'm making a query, but instead of it just being on One table I need to make it from multiple tables in this case. I want to look at so the track name Now all of a sudden any where I have an artist name and a track name sort of that link is going to apply And when I run this You see that all of a sudden I can see the artist dot name and the track So acdc for those about to rock we salute you a cdc put the finger on you a cdc Let's get it up inject venom arrows myth Alanis Morissette, etc. Etc. So I can now start to see Sort of where this data starts to relate a little bit better