How to Create a Simple Query in Microsoft Access

Video Transcript

"Hi, my name is Dave Andrews. Today, I'm going to show you how to create a Simple Query in Microsoft Access. Let's open up Access, and open a data base. I'm going to select My Data Base 3. If you get a security warning, just press Open. Click on the Table subsection, to see what tables you have available. I have Table 1. Let's click on it to see the data. That is the data in Table 1. Close your table. Now, we're going to create our Simple Select Query. Click on Queries, and say, Create Query in Design View. It's going to ask you which tables you want to include. We only have one table, so select it, and say Add. Now, close the Show Table dialog. In Table 1, here are it's fields. To select which data you want to pull out, in your Simple Query, click on the field, hold your mouse down, and drag it down into the field area. I selected both the ID and the My Text, for my Simple Query. To run your query, just click over here, on the View button. That is the results from my Simple Query. My name is Dave Andrews, and I just showed you how to create a Simple Query in Microsoft Access."