Page 91 - Trackpad_ipro 4.1_Class7
P. 91
NAMING CONVENTIONS FOR WRITING A FIELD NAME
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 (").
CREATING A TABLE
Tables can be created in two ways:
Creating tables using Design View
Creating tables using Datasheet View
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:
1 Click on the Create tab. 4 Click on the View command. 3 Click on the Fields tab.
2 Click on the Table
command.
5 Select the Design View option.
Database and DBMS—An Introduction 89

