Page 253 - IT 402 v2.0 class 10
P. 253
Step 8: lick on File menu from the Menu bar and select the lose option to close the table.
Created table.
Lab Assignment ‘n Activity S ub j e ct E nr ich me nt
Complete the following activities and tick on the circle.
reate a able namely S N using esign iew with the following fields:
Field Name Field Type Field Name Field Type
Stu I Numeric Marks ng Numeric
Stu Name ext Marks indi Numeric
O ate Marks Maths Numeric
lass ext Marks Science Numeric
Sec ext Marks SS Numeric
oll No Numeric otal Numeric
a Set Stu I as rimary ey and with Numeric data type.
b Set the field properties as:
i idth of Stu Name as characters.
ii O as an .
iii Set re uired property as es for Stu Name.
CREATE TABLE BY USING WIZARD
i ards are the predefined format which already exist in the package. his option provides the facility that
enables the user to select a category re uired fields from predefined tables and to set type formats and
primary key and create a table.
Step 1: lick on the option se i ard to reate able... from asks pane. It opens with two pre-existing
categories of databases i.e. usiness and ersonal .
Database Management 251

