Page 271 - Trackpad 402_Class-X_Final
P. 271
Step 6: The green arrow key before the cell shows the currently active field. Move this arrow key to the first
column created - Adm No.
Step 7: Right-click on the arrow to display the context menu.
Step 8: Select Primary Key from the context menu as shown below:
You can create as many columns as you want in a table.
A key-like symbol appears in front of Adm No indicating that the column will now behave like a primary key
where only unique values are allowed and no value can be left blank.
Step 9: Click on icon at the toolbar of the Design view.
OR
Click on File menu and select Save As option to save the above created table.
The Save As dialog box appears where the default name is Table1.
Step 10: Remove the default name and write a new name- STUDENT.
Database Management System 271

