Step by step exercise. Make-table queries


Objective.

 

Practice the procedures for Creating Make-table queries.

 

Exercise 1.

 

We are going to create a new query with which to create a new table with our students from Las Vegas.

1 Open the Classes.mdb database.

2 Position yourself in the Queries tab of the Database window.

3 Click on the Create query in Design view option, or click on the button and select Design View before clicking on the OK button.

The Show table box will open next.

4 Click on the Students table, this way it will remain selected if it was not already before.

5 Click on the Add button.

6 Click on the Close button to close the dialogue box as the query will be based on only the Students table.

We are going to add all the fields.

7 Double click on the students field * to select all the fields in one go.

8 Double click on the City field in order to add it to the grid so as to be able to indicate the search criteria.

9 Type Las Vegas in the Criteria: row to form the condition: City = 'Las Vegas' .

10 On the Show row uncheck the verification box of the City column so that the city does not appear twice (its already included in students.*).

Now we have the query with which to obtain the data to save in the new table.

11 Drop down the button on the toolbar and select the Make-table query... option.

12 Type the name of the new table as Students from Las Vegas. Remember that you can not have a query with the same name..

13 Click on the Ok button.

14 Click on the Datasheet view button to check the data that will be saved.

15 Click on the Design view to return to the design view.

16 Click on the run button to create the new table.

17 Close the query and name it Create Students from Las Vegas.

 



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.