Four ways to add fields to a query

When you create a Query there are several ways to add fields to the Design Grid. Go to the Create ribbon, and on the far right choose Query Design. Double-click to add the SalesReps table in the Query and then close the window. Hold your cursor over the bottom of the SalesReps table and pull down so that you can see more of your fields. I can add fields to my Query in several different ways. The first is to double-click on the Field and it will appear in the next available column. I'll double-click on LastName and it appears. You can also click in the Field Row right in the grid and use the dropdown and pick the field from there.

I'll choose Address. A third way is to click from the window above and drag it down to the grid. You can aim for the next available empty column, but this method also allows you to add columns you forgot. I can drag FirstName and drop it onto Address. Address will move to the right and make room for the new column. If you do need to reorder the columns, you can always click on this thin gray bar right here when you get a Black down-arrow. I'll let go of my mouse button, then click on that thin bar again, and pick it up and drag. If I want, I can drag it back.

Now, for our last way of adding fields to a Query, first delete all three of these columns. I'll click on the thin bar above LastName, and drag across to Address, and then let go. And then simply click Delete on my keyboard. Now, go up to the SalesReps field list, and double-click on the asterisk. The first column simply says SalesReps.*, but when I go up to the ribbon and then run the Query, all the fields in the table display. Interchanging all of these methods as needed will give you speed as you build your queries.