Примери за използване на Tables or queries на Английски и техните преводи на Български
{-}
-
Colloquial
-
Official
-
Medicine
-
Ecclesiastic
-
Ecclesiastic
-
Computer
Reports can be based on Tables or Queries.
Choose the tables or queries that you want to use as sources of data.
You can add up to 255 fields from as many as 32 tables or queries.
To add additional tables or queries, repeat these steps.
If you want, select fields from other related tables or queries.
Select one or more tables or queries and then click Add.
Note: The calculation can't include fields from other tables or queries.
Add any other tables or queries that you want to use in this data connection.
You open the Query Designer,select your tables or queries, and add your fields.
The form must be bound to an object that is available in the Navigation Pane under Tables or Queries.
The tables or queries that provide the underlying data are also known as the report's record source.
You can attach popup views to any controls that display data from related tables or queries.
And as long as you have a join between your tables or queries, you can add fields from both sources.
The tables or queries appear as one or more windows in the query designer.
Subforms are useful for viewing data from multiple related tables or queries within the same form.
Printing data directly from tables or queries works when you want to print just a simple list.
For queries, users must have permissions to delete data from the parent tables or queries.
In the Navigator pane, select the tables or queries that you want to connect to, then press Load or Edit.
For queries, users must have permissions to delete data from the parent tables or queries.
If you are using other tables or queries in the database to supply data to the form, add those additional tables or queries.
In the case of mailing labels, the report gets the address data from the tables or queries containing the addresses.
A report consists of information that is pulled from tables or queries, as well as information that is stored with the report design, such as labels, headings, and graphics.
If you want to examine every possible combination of rows between two tables or queries, use a cross join.
You can then bind forms and reports to those tables or queries, and the calculations appear on the formsor reports without needing to create a calculated control.
To grant users permissions to read queries, you must also give those users permissions to read the parent tables or queries.
Subforms are especially effective when you want to show data from tables or queries that have a one-to-many relationship.
In a SELECT statement, the FROM clause specifies the tables or queries that contain the data that the SELECT clause will use.
You can then bind forms and reports to those tables or queries, and the calculations appear on the formsor reports without needing to create a calculated control.