Page 32 - ModularV1.1 _c8_flipbook
P. 32
Step 3 Click on the type of field that you want to add in your table under the Add & Delete
group of the Fields tab. In this case, we have clicked the Text command to add a text
field. A new column with the name Field 1 will be added into the table.
Adding a column New field in table
There are some other commands like Number, Currency, Date & Time and Yes/No also
available to add numerals, money, date/time and yes/no types of columns/fields in a table.
Tech
Funda
Click on the More Fields command under the Add & Delete group of the
Fields tab to get more types of fields.
Deleting a Column
Perform the following steps to delete a column from a table:
Step 1 Select the column that you want
to delete.
Step 2 Click on the Delete command
under the Add & Delete group
of the Fields tab. The Microsoft
Access dialog box appears.
Deleting a column
Step 3 Click on the Yes button. The
selected column will be deleted from the table.
Microsoft Access dialog box
Hiding a Column
MS Access allows you to hide a column in a table. The column you hide will not be visible to the
user. However, it is present in the table. Perform the following steps to hide a column:
Step 1 Right-click on the selected column. A context menu appears.
Step 2 Select the Hide Fields option from the context menu. The selected column will be
hidden.
30 Modular (Ver. 1.1)-VIII

