Page 92 - Trackpad_ipro 4.1_Class7
P. 92
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: 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.
Description: It is used to give additional comments or information to the user while entering
data. The entry in this field is optional.
By default, Access names the first field ID and sets it as the Primary Key with the AutoNumber
data type, which means Access will automatically create a unique number for each record.
To move between columns and insert new fields at the end, press the Tab key.
The detailed properties of each field can be defined in the Field Properties pane according to
the naming conventions for writing a field name discussed earlier.
Setting Field Properties
To do so, follow the given steps:
2 Set the properties.
1 Click on the
field name for
which you want to
set the properties.
Adding a Record
To do so, follow the given steps:
2 Click on the
field to add the
new record.
1 Double-click to open
table in Datasheet view.
90 iPro (Ver. 4.1)-VII

