Примери за използване на Query design на Английски и техните преводи на Български
{-}
-
Colloquial
-
Official
-
Medicine
-
Ecclesiastic
-
Ecclesiastic
-
Computer
Access displays the Total row in the query design grid.
In the query design grid, click the join you want to remove.
Each field then appears in the query design grid.
In query Design view, double-click the join you want to change.
On the ribbon, select Create, then Query Design.
In the next column of the query design grid, enter the following.
The selected fields will appear in the Field row in the query design grid.
In an empty column of the query design grid, select the Field row.
On the Create tab,in the Other group, click Query Design.
In the query design grid, select the field that you want to delete, and then press DEL.
All three tables appear in the query design workspace.
In the query design grid, use the Criteria row to enter field criteria.
Each field appears in a column in the query design grid.
All three tables appear in the query design workspace, joined on the appropriate fields.
On the Create tab,in the Other group, click Query Design.
In query Design view, this is represented in the Field List by using an expandable field.
If necessary, add the Total row to the query design grid in the lower pane.
In the query design grid, click the Criteria row of the field where you want to add the criterion.
The table appears as a window in the upper section of the query design grid.
In the query design grid, in the Criteria row of the City column, type Like For what city?
Create any required joins by dragging fields from one object to another in the query design window.
In the query design grid, click the Total row of the EventDate field and then click Max.
You use these expressions in the Update To row in the query design grid for the field that you want to update.
In the query design grid, right-click the join you want to remove, and then click Delete.
Add the Order Date field from the Orders table to the first column in the query design grid.
In the query design grid, in the Criteria row of the City column, delete Las Vegas, and then type For what city?
Double-click the Product Name andList Price to add these fields to the query design grid.
In an empty column of the query design grid, right-click the Field row, and then click Zoom on the shortcut menu.
In the Class Enrollments table,double-click the asterisk(*) to add all of the table's fields to the query design grid.
The table or tables appear as one ormore windows in the upper section of the query design grid, and the windows list all the fields in each table.