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
   26   27   28   29   30   31   32   33   34   35   36