Step by step exercise. Introduce data into a table.


Objective.

 

Practise the procedures for introducing and modifying data 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 Select the Students table by clicking on it.

4 Click on the Open button in the Database window.

Observe how in the first field we put (Autonumber) as the type of data assigned to the Students Code. We do not need to write anything as this field fills in automatically.

5 Press ENTER to go to the next field.

6 Write the name John as Student Name.

Observe how in the Student code field now has a value of 1.

7 Press ENTER to go to the next field and write Smith as surname.

8 Press ENTER to go to the next field and write 34 Green as address.

9 Press ENTER to go to the next field and write Los Angeles.

10 Press ENTER to go to the next field and write 46002 as Postal code.

11 Press ENTER to go to the next field and write 02/15/73 as Date of Birth.

12 Press ENTER to go to the next record.

13 Add the records that appear in the next table.

Note: the field Course will be left empty for the moment as we have not yet created the courses.

 

Student Code Student Name Student Surname Address City Postcode Date of Birth
2 Mary Trask 23 Valley Los Angeles 46002 05/17/65
3 John Brown 3 Railroad Los Angeles 46005 08/25/67
4 Ane Martin 4 Almudena rd. Las Vegas 03005 07/24/65
5 Charles Lama 45 James rd. Los Angeles 46006 12/31/65
6 Frederick Major 67 Valley rd. Los Angeles 46002 02/03/68
7 Mario Martinez 2 Casinos rd. Las Vegas 03005 06/05/64
8 Charles Davis 46 James rd. Los Angeles 46006 03/24/69

Now we are going to correct the name of student 4, we type Ane instead of Anne by mistake.

14 Click on the word Ane between n and e letters and type an 'n'.

15 Close the table by clicking on the Close button on the Datasheet window.

16 Close the database by clicking on the Close button on 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.