If you now want to create a query that returns all articles that a customer has ordered, you must retrieve data from two spreadsheets. If, for example, you have a spreadsheet for articles identified by an article number, and a spreadsheet for customers in which you record all articles that a customer orders using the corresponding article numbers, then there is a relationship between the two "article number" data fields. If there are data relations between a field name in one table and a field name in another table, you can use these relations for your query. Enlarge or reduce the size in which the table is displayed by positioning the mouse cursor on a border or on a corner and dragging the table until it is the desired size. To move tables, drag the upper border to the desired position. You can resize and arrange the tables according to your preferences.
Another option is to press the Delete key. You can use the Delete command to remove the table from the Design View. To remove the table from Design View, click the upper border of the table window and display the context menu. While designing a query, you cannot modify the selected tables. When you open the query design for the first time, you see a dialog in which you must first select the table or query that will be the basis for your new query.ĭouble-click fields to add them to the query. Note: the table displayed is only temporary. The query result is displayed in a table similar to the Data Source View. If you want to test a query, double-click the query name in the database document. In the top of the query Design View window, the icons of the Query Design Bar and the Design bar are displayed. To rearrange the columns in the lower pane of the Design View, drag a column header to a new location, or select the column and press Command To define a query, specify the database field names to include and the criteria for displaying the fields.
The lower pane of the Design View is where you define the query. To create a query, click the Queries icon in a database document, then click Create Query in Design View. The Query Design window layout is stored with a created query, but cannot be stored with a created view. Selecting the Create View command from the Tables tab page of a database document, you see the View Design window that resembles the Query Design window described here.
0 kommentar(er)
