Page 104 - Viva ICSE Computer Studies 7 : E-book

Step 5
5. Type a new name of the fi eld in the ‘Enter Field
Properties’ dialog box.

6. Click on the OK button. Your fi eld with the
name will be entered. Step 6

Creating a Table in Design View

Design view allows you to enter names of the fi elds in the table and specify their data types.
A data type specifi es the kind of data (Numbers, Currency, Short Text) to be added in the fi eld.

Follow these steps to create a table using Design view.

Step 3

1. Select the Table Design
Step 6 option from the ‘Tables’

group on the ‘Create’ tab.
2. You will see the Table
Step 1 Step 2 Step 2 Design screen with three
columns: Field Name, Data
Type and Description. Enter
the fi eld name, data type
and description in each
fi eld of the table.

3. Save the table either by pressing the Ctrl + S keys Step 3
together or by selecting the Save option from the ‘File’
menu. Type the name of the table in the ‘Save As’ dialog
Step 4
box.
4. Click on the OK button.

Step 5

Step 5 5. A message box will appear on
the screen giving you a warning
that a primary key is not defi ned.
Click on the No option.

Press the Ctrl + W keys together
Learn More
to close the table window.
A primary key is a fi eld that contains unique values such as
Roll Number and ID.

92