Page 93 - iPlus_Ver_2.0_class_7
P. 93
• Data Type: 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: 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 as ID and assigns it as a Primary Key. The default Data Type
for the Primary Key field is AutoNumber. Enter the names of the fields and assign suitable data types.
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 rules 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:
1 Double-click 2 Click on the
to open table in field to add the
Datasheet view. new record.
Editing a Record
To do so, follow the given steps:
1 Double-click 2 Double-click
to open table in on the record that
Datasheet view. you want to edit.
91
Database and DBMS—An Introduction

