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

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."