Step by step exercise. Moving within a table.


Objective.

 

Practise the procedures for moving all through the records in a table with Access2003.

1 If Access is not open, open it to be able to carry out the exercise.

2  Open the Classes.mdb database, found in My documents in the hard drive.

3 Open the Students table in Datasheet View by double clicking on it.

Observe how the active record is the first one.

4 Click on the button on the bar below to go to the next record.

Observe how in the white box on this same bar it is indicated which record we are in (now, the second one).

5 Click on the button to go to the last record.

6 Click on the button on the bottom bar to go to the previous record.

7 Click on the button to go to the first record.

8 Click on the button to create a new record.

Observe how the cursor is now situated in the last row of the table.

9 Insert the following records.

 

Students Code Student Name Student Surname Address City Postal Code Date of Birth
9 Louise Menor 27 Valley rd. Los Angeles 46002

04/25/65

10 Tom Smith 34 Major rd Los Angeles 46005 10/30/62

 

Now we will go to record 4.

10 Double click on the number of the current record on the bottom bar.

11 Type 4 and press ENTER key. Observe how the cursor is now situated in the fourth record.

12 Close the table by clicking on the Close button in The Datasheet window.

13 Close the database by clicking on the Close button in the Database window.

 



 
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.