Watching:

Four ways to add fields to a query


show more Four ways to add fields to a query provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

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 click on Query Design. Double-click on SalesReps to add it to the grid and then close the Show Table window. Hold your cursor over the bottom edge of the table until you get a double headed arrow, and pull down so that you can see more 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 will double-click on LastName and it appears below. You can also click in the filed name in grid and use the dropdown to choose your next field.

I will choose Address. A third way is to click on the field in the field list and drag it down in 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 first name and drop it on top of Address. Address will move to the right and make room for the new column. If you do need to reorder your columns, you can always click on the thin grey bar at the top of the column. Let go off your mouse button then click on it again and drag it where you need it to go. Look for the black line to know where you are dropping the field.

I will show you again. Now, for our last way of adding field SeQuery, first delete all of these columns. I will click on the thin gray bar above LastName when I have that black down arrow, and I will hold my mouse button down and drag across to Address and then I will hit Delete on my keyboard. Now, go back up to the SalesReps field list; and this time double-click on the asterisk (*). Now, the first table on the grid simply says SalesReps.*, but when I go up to the ribbon and I 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.

Four ways to add fields to a query
Video duration: 1m 41s 3h 43m Intermediate

Viewers:

Four ways to add fields to a query provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...