How to Create an SQL Query in Microsoft Access

Next Video:
How to Create an Append Action Query in Microsoft Access....5

In order to create an SQL query in Microsoft Access, an individual must start with the query wizard or the query design tool. Find out how to drag fields into a query that has been created with the query design tool with help from a computer programming teacher in this free video on Microsoft Access.

Part of the Video Series: Microsoft Access Tutorial
Promoted By Zergnet


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, that's Browne with an E.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!