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