Примери за използване на Query wizard на Английски и техните преводи на Български
{-}
-
Colloquial
-
Official
-
Medicine
-
Ecclesiastic
-
Ecclesiastic
-
Computer
The Query Wizard.
On the Create tab, from the Queries group,click Query Wizard.
The Query Wizard.
Note if you're using Access 2007, click Create>Other> Query Wizard.
To start the Query Wizard, perform the following steps.
Note, if you're using Access 2007, on the Create tab,in the Other group, click Query Wizard.
Using the Query Wizard, you can select the tables and fields that you want to include.
In the New Query dialog box, click Simple Query Wizard, and then click OK.
You can use the Query Wizard to automatically create a select query. .
Dqy file for any query that you create,either by using the Query Wizard or directly in Microsoft Query. .
Use the Query Wizard for most queries The Query Wizard makes it easy to select and bring together data from different tables and fields in your database.
If you use fields from data sources that are not related to each other, the Query Wizard asks you if you want to create relationships.
In Microsoft Query, you can use the Query Wizard to create a simple query, or you can use advanced criteria in Query to create a more complex query and do the following.
If your database has tables andyou want a particular table to display automatically in the Query Wizard, click the box for step 4, and then click the table that you want.
In addition, if you use one of the query wizards, access uses the information it gathers from the table relationships you have already defined to present you with informed choices and to prepopulate property settings with appropriate default values.
Work with the data in Excel After you create a query in either the Query Wizard or Microsoft Query, you can return the data to an Excel worksheet.
This topic provides an overview of select queries, and gives steps for creating a select query, by using the Query Wizard or in Design view.
Reusing and sharing queries In both the Query Wizard and Microsoft Query, you can save your queries as a.
Work directly in Microsoft Query for other types of queries If you want to create a more complex query than the Query Wizard allows, you can work directly in Microsoft Query. .
If you saved the query when you created it in the Query Wizard or in Microsoft Query, the query file is saved on your computer, and you can use the query again to retrieve external data.
You can use Microsoft Query to view andto change queries that you start creating in the Query Wizard, or you can create new queries without using the wizard. .
In addition, if you use one of the query wizards, access uses the information it gathers from the table relationships you have already defined to present you with informed choices and to prepopulate property settings with appropriate default values.
For example, if you have a table of product sales information and a table of customer information,an inner join(the type created by the Query Wizard) will prevent the retrieval of customer records for customers who have not made a purchase.
In addition, if you use one of the query wizards, access uses the information it gathers from the table relationships you have already defined to present you with informed choices and to prepopulate property settings with appropriate default values.
Join data in different ways The inner joins that the Query Wizard creates are the most common type of join used in creating queries. .
When you use the Data Connection Wizard or Microsoft Query to connect to external data, you usually create an external data range.
The OLAP Cube Wizard in Microsoft Query, which created an OLAP Cube from a Jet database, is no longer available in Excel.
When you use the Multi-Dimensional Connection Wizard in Microsoft Query to create a data source for an OLAP database or cube, an. oqy file is created automatically.
For external data ranges that are created from Microsoft Query and the Data Connection Wizard, use the External Data Properties dialog box.
If you choose Yes,create the query, the wizard renames the original table by appending"_OLD" to the table name, and then names the new query by using the name of the original table.