what is the use of query wizard and how to create it?? pls answer fast
Answers
Answered by
1
When you want to select specific data from one or more sources, you can use a select query. A select query helps you retrieve only the data that you want, and also helps you combine data from several data sources. You can use tables and other select queries as data sources for a select query. 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.
let's look how to create it:-
You can create a select query by using the Query Wizard or by working in Design view. Some design elements are not available when you use the wizard, but you can add these elements later by using Design view. Although the two methods are somewhat different from each other, the basic steps are essentially the same:
Choose the tables or queries that you want to use as sources of data.
Specify the fields that you want to include from the data sources.
Optionally, specify criteria to limit the records that the query returns.
let's look how to create it:-
You can create a select query by using the Query Wizard or by working in Design view. Some design elements are not available when you use the wizard, but you can add these elements later by using Design view. Although the two methods are somewhat different from each other, the basic steps are essentially the same:
Choose the tables or queries that you want to use as sources of data.
Specify the fields that you want to include from the data sources.
Optionally, specify criteria to limit the records that the query returns.
nandani86:
thanks
Answered by
1
Use the Query Wizard to create a select query. You can use the Query Wizard to automatically create a selectquery. When you use the wizard, you have less control over the details of the query design, but the query is usually created faster than if you did not use the wizard.
Similar questions