Page 260 - IT 402 v2.0 class 10
P. 260
Step 3: ight-click on the field which has to be deleted.
Step 4: lick on the elete option from the menu. he selected field will be deleted from the table.
Step 5: lick on the Save button from the standard toolbar to make the effective changes.
Modif ing olumns fields
he properties of any existing column field of a table can be modified. o change the name data type and
properties of an existing column field:
Select the table.
lick on the dit button from the standard toolbar to open the table in esign Mode .
lick on the field to be modified.
Make the re uired changes in the fields i.e. its name type etc.
lick on the Save button.
N ot e s
fields
fields
of
of
been
modify
or
or
delete
modify
used
used
fields
the
the
have
have
fields
if
table
a
a
if
been
table
he
he user cannot delete or modify fields of a table if the fields have been used in creating tables by using
he
creating
creating
tables
using
using
by
tables
by
canno
canno
in
t
delete
in
t
user
user
first
been
the
table
which
delete
has
to
i ard.
o
iew....
reate
reate iew.... i ard. o delete or modify such fields he has to first delete the table which has been
reate iew.... i ard. o delete or modify such fields he has to first delete the table which has been
fields
he
has
such
delete
or
modify
created by using reate iew..... i ard.
created by using reate iew..... i ard.
ENTERING DATA INTO A TABLE
ntering data is the most important part after the creation of a table. o enter data in the table:
Step 1: Open the table by double-clicking the table name from the Table Pane of database window.
Or
lick on the table name and then click on the Open atabase Ob ect button from the standard
toolbar.
he table opens in the able ata iew window.
258 Touchpad Information Technology-X

