Page 252 - IT 402 v2.0 class 10
P. 252
onsider about the following points while creating a table:
In a table each field should have a uni ue name. No two fields in a table can have the identical name.
ach field should be predefined with data type that identifies the type of data to be entered in that
field.
special field which uni uely identifies a record in a table is called primary key. In primary key column no
two records can be identical, for example, in your class, two students cannot have the same roll number
even if their names are same.
o set the rimary key for the table:
Step 1: osition the mouse pointer on the field which is to be set as primary key.
Step 2: ight click the mouse button and select the option rimary ey .
Step 3: Select rimary ey.
Step 4: rimary key defined.
4
3
Step 5: lick on the Save icon from the standard toolbar. Save s dialog box appears on the screen.
Step 6: Type the name of table.
Step 7: lick on the O button. table with the given name is created.
6
7
250 Touchpad Information Technology-X

