Getting started with Access tutorial 9.5 add and delete target fields for queries

Now we need to add fields to the query design table. The added field is called a target field. There are two ways to add a target field to a query table: the first method is to select a blank column in the table, click a grid corresponding to the first line. A button with a down arrow appears on the right side of the grid.

Now we need to add fields to the query design table. The added field is called a target field. There are two ways to add a target field to a query table: the first method is to select a blank column in the table, click a grid corresponding to the first line. A button with a down arrow appears on the right side of the grid.

Now we are goingQueryDesign tableAddField. InstituteAddOfFieldIt is called"TargetField",QueryTableAddTargetFieldThere are two methods:

The first method is to select a blank column in the table, click a grid corresponding to the first row, a button with a down arrow appears on the right side of the grid, and click this button to display a drop-down box, in the drop-down box, you can select the correspondingTargetFieldThe "Order Number" in the "Order info table" is selected"Field.

If the sameFieldHow can we differentiate them? When weQueryFind the correspondingTargetFieldInFieldBoth haveFieldTable/QueryName, such as "order information table. Product Name"FieldIt indicates that it is the "Product Name" in the "Order info table"Field. Instead of other tables orQuery"Product Name" in"Field. In this way, it will not be confused.

The second method is simpler.Add"Order unit" in "Order info table"FieldFirst, select the table "Order info table", and then findField"Order Unit", move the cursor to the list box marked with thisFieldAnd press and hold the left mouse button. Then, the cursor turns into a long box and drag the long box to the bottom.QueryA blank column in the table, with the left mouse button removed, the order unit in the order information table is completed"FieldAddToQueryTable. In/QueryIf there are many objects in the window, this method is much more convenient than the first method.

If you wantDeleteOneTargetField, Move the mouseDeleteOfTargetFieldOn the selection bar of the column, the cursor turns into a downward arrow. Click the left mouse button to select the column and press the "DELETE" key on the keyboard.TargetFieldIsDelete.