[code]about queries[/code]

[dayavathi]

1) what condition must be satisfied if you want to retrieve data from two tables by using the query wizard?


2) why is design view needed when you create queries easily by using a wizard?
3 ) what are the different methods of running a query?
4 ) can you create a query that displays all the fields of table? if yes, how?
5) how can you crate queries that are based on existing queries?

[ranman256]

1. no condition. unless you want one in it. you cant add multiple table in the wizard, you can in query designer.
2. you dont. you can use the wizard anytime. but you dont have to use the wizard.
3. there is only 1 method to run a query (in design mode). click the run button. (tho in VB, you can use Docmd.openquery)
4. in query design, dbl-click the star *. this will pull all fields. or you can select all fields and drag them down into the query, or just type: select * from table.
5. start a query, drag the query into the design, or select QUERIES from the wizard (instead of tables)

[pbaldy]

I hope the teacher gives ranman a good grade.

[ItsMe]

3 ) what are the different methods of running a query?

There are different types of queries. One way to look at queries in Access is to place a query into one of two categories, an Action query or a Select query. An action query will do something like Append or Update. A select query will retrieve records and might also include aggregate calculations.

So you would not really run a query that retrieves records. You would run a query that performs an action like appending records to a table. You can run a query using VBA code or you can double click a saved query object from within the Navigation Pane or you can use the Run (Exclamation Icon) button from within Design View.

Here are two simplified examples of using VBA to run or execute an action query. Here, the actual SQL statement is being used. However, you can also execute a query object by using the name of the object in place of an SQL statement.

DoCmd.RunSQL "INSERT INTO Table2 ( MyField ) SELECT Table1.MyField FROM Table1;"
'or
CurrentDb.Execute "INSERT INTO Table2 ( MyField ) SELECT Table1.MyField FROM Table1;"