Video: How to Create a Simple Query in Microsoft Access

This Season: Tailgating; Tech Know; New Year, New You; Tax Time

A simple query in Microsoft Access will retrieve data from a Microsoft Access database. Create a simple query in Microsoft Access with tips from a software developer in this free video on computer training.

- How to Switch Users With Windows Vista

Comments

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.

Follow eHow: Follow @eHow

How to Create a Simple Query in Microsoft Access

Comments

Related Ads

Related Articles & Videos