Page 31 - ModularV1.1 _c8_flipbook
P. 31
Step 4 Enter a name for your table in the Table Name text
box.
Step 5 Click on the OK button.
Save As dialog box
This will open a blank table in the Design view. The table is
divided into three columns:
Field Name: Used to enter the name
of the field to be displayed as column
heading in the table.
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. Design View
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
Entering field names
discussed earlier.
HANDLING COLUMNS IN A TABLE
MS Access 2010 allows us to add, delete, hide, unhide and rename a column in a table. It also
allows us to freeze, unfreeze and move columns. Let us learn about these operations in detail.
Adding a New Column
Perform the following steps to add a column in an existing table:
Step 1 Open the table in which you want to add a column.
Step 2 Click on the column header on the left in which you want to add a column.
Working with Tables in MS Access 29

