Unit 7. Queries (III)


Saving the query

 

We can Save the query

clicking on the button on the toolbar,

or,

Selecting the Save option from the File menu.

If it is the first time we are saving the query a dialogue box will appear to give it a name.

Any name can be given except for the name of an existing table.

Next click on the OK button.

To close the query click on the button.

 

Running a query

 

We can run the query from the Query design window or from the Database window.

From the Database window:

Firstly select the query to run by clicking on it.

Next click on the button in the database window.

From the design view of the query:

Click on the button on the toolbar.

When the query is a select query, we can also click on button (Datasheet view)

When we are visualizing the result of a query, what we are really seeing is that part of the table which has complied with specific criteria, and so if we edit any data in the query that appears, we will be editing the data in the table (except for a few queries which do not permit updates).

 

To practice you can perform the Step by step exercise Creating simple queries.

 

Modifying the query design

 

If we want to modify the design of a query:

Situate yourself in the Database window, in the Queries object,

Select the query you want to modify by clicking on it.

Click on the button.

 



 

Page 7.3

Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.
© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited. April-2006.