 So one of the things that we can do just like we did with that text files We can actually come into the data tab and we can import from Microsoft access now I know what you're saying or you're thinking at least I'm just gonna click on this thing and that's gonna work Well, what happens if I actually want to limit what I want to look at I don't want to look at an entire database That's a lot what I can do is I can come over here to from other sources and One of the things we can do inside of a database is we can ask it questions Known as a query I can select from Microsoft query and that is going to give me a nice little dialogue box like this This allows me to now Investigate and look through what kind of data I want to be working with I still want to work with an access database So let's go ahead and hit okay This is gonna make a little connection now. This is gonna be a little crummy Hopefully you've learned a little bit about file hierarchy structures. I like to save mine in my desktop Some of you may have this in your documents folder If I double click on say mine I Can see that if I come down here's my downloads folder where a lot of you may have this stuff Again, I like to store files. I'm working on on my desktop Now finally tutorial 11 I go in there. This will give me the database. I want to look for Finally when I hit okay, I get a nice little message. Ask me what columns of data Do I want now? This is a query meaning I'm able to actually pull from all my different types of Information say for example, I want to see who the heavy hitters of the portfolio Are yeah, obviously, I don't need to look at every single one of my stocks I just need to know the you know the key players the ones that they tank. I go out of business. So I'm gonna come in here and I'm gonna first select say my ticker symbol ticker symbol that way I can know what to look up when I go And look at this up say tomorrow for example I'm also include the title and How much my portfolio is of this particular stock now? We always like to the first five loans blah, blah, blah, blah, but this is gonna tell me at least the percentage How much this stock is worth in regards to and then the majority of my Portfolio next I'm gonna actually come in here. I'm gonna go and look at my long-term performance I want to take this year high in this year low and I want to look at them as well That's gonna be something that I can kind of keep an eye on as we move forward I hit next Next little part is where we can actually filter out information. Say I don't want to look at all my different Portfolio stocks, I don't want to see all of them. I only want to see for example those portfolio stocks that have a greater than or equal to of Seven percent now. I'm using the option here of zero point zero seven that translates out to zero seven percent Now I can take this information and I can hit next. Do I want to sort it? Yeah, why not? I'll sort by our portfolio percentage in descending order when I hit next pretty much Where do I want to go? I can actually save this query if I want to use it a little later And I can say finish where do I want to put it same place as always as soon as I hit ok You see it actually pulls that information from access and so suddenly we get to take a look here's all the different portfolio Stocks that are above seven percent So we've got actually a few of these we've got nine different stocks that kind of have highs and lows We get to see sort of how they perform and how much you know that matters to us