Page 35 - ModularV1.1 _c8_flipbook
P. 35
Tech
Funda
You can also rename a column by right-clicking on it and selecting the
Rename option.
Setting a Column Properties
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. Follow these steps to set the properties of a column:
Step 1 Open the table in the Design view.
Step 2 Click on the field name for which
you want to set the properties.
All the properties related to the
column will appear in the Field
Properties pane.
Step 3 Set the properties according to
your requirement. In this case, we
have set the Field Size property
of the Employee Name column
to 50. Now, this column accepts
maximum of 50 characters as
value. Setting Column Properties
HANDLING RECORDS IN A TABLE
MS Access facilitates you to add, delete, edit and sort records in a table. Let us learn about these
in detail.
Adding a Record
To add a record, follow these steps:
Step 1 Open the required table in Datasheet view.
Step 2 Place the pointer where you want to add the new record.
Selecting table Adding record
Working with Tables in MS Access 33

