Page 92 - iPlus_Ver_2.0_class_7
P. 92
i + RULES FOR WRITING A FIELD NAME IN ACCESS
You should remember the following rules 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:
4 Click on the View command. 3 Click on the Fields tab.
1 Click on the Create tab.
2 Click on the Table
command. 5 Select the Design View option.
6 Enter the name for
your table in the Table 7 Click on the
Name text box.
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.
90
iPlus (Ver. 2.0)-VII

