How to Create a Microsoft Access Query That Uses More Than 1 Field

Save
Next Video:
How to Create a Microsoft Access Query That Uses More Than 1 Table....5

In Microsoft Access, creating a query that uses more than one field means running the query wizard and choosing more than one field from a given table. Title a query that returns information from a specific field in Microsoft Access 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

Comments

Video Transcript

Hi my name is Chip Browne and I teach computer programming and Microsoft applications classes at a local business college here in Utah, Steven Henagar Business College and I also create practice tests for Microsoft Office application specialist certifications. Today we are going to learn how to create a query that uses more than one field. Microsoft Access is a registered trademark of Microsoft Corporation. I am not affiliated with Microsoft Corporation. Creating a query with more than one field is very simple. We will run the query wizard. On the create tab in the other group click query wizard. Next choose a simple query wizard. Here we select a table and one or more fields from that table. Here we have chosen more than one field from the customer's table. We can title our query and open it when we run it. Here is the query returning the field's id, company, last name, first name and e-mail address. This is how you create a query with more than one field. For more information visit me, Chip Browne, at chipbrowne.com.

Featured

Related Searches

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