How to Create an SQL Query in Microsoft Access

Video Transcript

"Hi, my name is Chip Browne. I teach Microsoft applications programs at a local business college here in Utah, it's Steven Henagar. I also create practice tests for Microsoft Office Applications specialists certifications. Today we're going to learn how to create an SQL Query in Microsoft Office Access two thousand seven. Microsoft Access is a registered trademark of Microsoft Corporation. I am not affiliated with Microsoft Corporation. To create in Microsoft Access, you can do it in one two ways. We could use the query wizard and we can use the query design tool. Let's start with the query wizard. Click on the create tab, in the other group, click on query wizard. Next, choose simple query wizard. There we choose one of our tables and fields with that table or query. Here we title the query and choose whether to open or modify the query design. This is the results of that query. Now, let's do this with the query design tool. Click on the create tab, in the other group, click on query design. Choose a table of query. Drag one or more fields to your query. Click, shift click, we'll select many fields, followed by a click and drag and drop. This is how you create a query using a query design tool, next on a query. These are two ways to create simple queries using Microsoft Access. For more information and videos, visit me Chip Browne at chipbrowne.com, that's Browne with an E."