Page 91 - iPrime_V2.2_class7
P. 91
NAMING CONVENTIONS FOR WRITING A FIELD NAME IN
ACCESS
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 grave accent (') and brackets ([ ]).
Field name cannot begin with the leading spaces.
Field name cannot include a double quotation mark (").
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 these steps:
Step 1 Click on the Table command from the Tables group
under the Create tab. This will create a new table as
Table1 in the database.
Creating a Table
Step 2 Click on the View command from the Views group under
the Home tab. A drop-down list opens.
Step 3 Click on the Design View option. This will open Save As
dialog box.
Selecting Design View
Step 4 Enter a name for your table in the Table Name text
box.
Step 5 Click on the OK button. Save As dialog box
This will open a blank table in the Design view. The table is divided into three columns:
Field Name: It is used to enter the name of the field to be displayed as a column heading
in the table.
Data Type: It is used to define the type of data that can be entered in that field. The commonly
used data types in Access are Text, Number, Date/Time, Currency, AutoNumber, Yes/No, etc.
Database and DBMS—An Introduction 89

