Page 93 - TP_iPlus_V2.1_Class7
P. 93
i + CONVENTIONS FOR NAMING A FIELD
You should remember the following naming conventions while writing field names:
• Field name can be up to 64 characters long.
• Field name can include any combination of letters, numbers, spaces, and special characters
except a period (.), an exclamation mark (!), an accent grave (') and brackets ([ ]).
• Field name cannot begin with the leading spaces.
• Field name cannot include a double quotation mark (").
i + CREATING A TABLE
Tables can be created in three ways:
• Creating tables using Design View
• Creating tables using Datasheet View
• Creating tables using Templates
Let us create a table using Design view.
Creating a Table Using Design View
In this view, you can define fields that are to be included in the table. You can simultaneously
define the properties of these fields. To create a table in Design view, follow the given steps:
3 Click on the Fields tab.
1 Click on the
Create tab.
4 Click on the
View command
on the Views
group.
2 Click on the Table command
on the Tables group. 5 Select the Design View option.
6 Enter the name for
your table in the Table
Name text box.
7 Click on the OK button.
This will open a blank table in the Design view. The table is divided into three columns:
• Field Name: Used to enter the name of the field to be displayed as a column heading in the table.
91
Database and DBMS—An Introduction

