Page 255 - IT 402 v2.0 class 10
P. 255
Step 6: lick on the Finish button. newly created table opens in which the user can enter records.
Sneak Peek
To Create Table in Design View in Microsoft Access:
1. Click on Create tab.
2. Click on Table Design command.
. ype a name for the field in the Field Name column.
. Select the type of data to be entered in the field from the drop down list box of ata ype
column.
5. Mention the details of the field in the escription column.
. osition the mouse pointer on the field which is to be set as primary key right click the
mouse button and select the option Primary Key.
. ress trl S keys to save the table. Save s dialog box appears on the screen.
8. Type the table name and click on OK button.
Step 7: fter adding re uired records in the table click on the Save icon from the standard toolbar to save
the records.
Step 8: o close the table click on the lose button from the itle bar . he button of table with the name
is shown in the Table Pane.
CREATE TABLE BY USING CREATE VIEW
his option is used to create a table by specifying the field s name properties and data type. he user can
copy selected fields from specific table and create a new table with a combination of fields from different
tables. o do so:
Database Management 253

